Connect to MindsDB

SQL Syntax

Databases

Projects

Models

Views

Tables

Files

Jobs

Join our Slack

GitHub

MindsDB

Documentation

SQL API

SDKs

REST API

Integrations

Contribute

FAQs

Get Started

Login

Overview

MindsDB SQL

Introduction

MindsDB - Middleware for Building Custom AI

Docker

Setup for Docker

Docker Extension

Setup as a Docker Extension

MindsDB GUI Overview

Navigating the MindsDB GUI

MindsDB Information Schema

AI Engines & AI Tables

Generative AI Tables

Data Sources

Connect a Data Source

Create a View

Upload a File

Create a Job

JOBS

Create a Trigger

Mistral7B Model Fine-Tuning

OpenAI Models Fine-Tuning

Classification Models Fine-Tuning

Regression Models Fine-Tuning

Agents and Chatbots

Chatbot with a Text2SQL Skill

Build a Chatbot with a Text2SQL Skill

Slack Chatbot

Implementing a Chatbot for Slack using MindsDB and OpenAI's GPT Model

Twitter Chatbot

Building a Chatbot for Twitter using MindsDB and GPT-4

Twilio Chatbot

Image Generator

Generating Images with OpenAI

Extract JSON

Retrieval Augmented Generation

Recommender Models

Question Answering using SQL

Question Answering with MindsDB and OpenAI using SQL

Question Answering using MQL

Question Answering with MindsDB and OpenAI using MQL

Sentiment Analysis using SQL

Sentiment Analysis with MindsDB and OpenAI using SQL

Sentiment Analysis using MQL

Sentiment Analysis with MindsDB and OpenAI using MQL

Text Summarization using SQL

Text Summarization with MindsDB and OpenAI using SQL

Text Summarization using MQL

Text Summarization with MindsDB and OpenAI using MQL

House Sales

Forecasting Quarterly House Sales with MindsDB

House Sales with StatsForecast

Forecasting Quarterly House Sales with StatsForecast

Brain Activity

Forecasting Eye State from Electroencephalogram Readings with MindsDB

Tutorials by Our Community

Customer Churn

Predicting Customer Churn with MindsDB

Home Rentals

Predicting Home Rental Prices with MindsDB

Hugging Face Models

Usage Examples of Hugging Face Models

Hugging Face Models Through Inference API

Usage Examples of Hugging Face Models Through Inference API

Community Tutorials List

MindsDB SQL Syntax

MindsDB SQL Editor

Postgres CLI

MindsDB and Postgres CLI

MySQL CLI

MindsDB and MySQL CLI

DBeaver

MindsDB and DBeaver

MariaDB SkySQL

MariaDB SkySQL Setup Guide with MindsDB

SQL Alchemy

MindsDB and SQL Alchemy

Deepnote

MindsDB and Deepnote

Metabase

MindsDB and Metabase

Tableau

MindsDB and Tableau

Jupyter Notebooks

MindsDB and Jupyter Notebooks

Grafana

MindsDB and Grafana

List Data Handlers

Remove a Data Source

List Data Sources

Use a Data Source

List ML Handlers

Configure an ML Engine

Remove an ML Engine

List ML Engines

Create a Project

Remove a Project

List Projects

Create, Train, and Deploy a Model

Remove a Model

List Models

Describe a Model

Retrain a Model

Finetune a Model

Manage Model Versions

Get a Single Prediction

Get Batch Predictions

Join Models with Tables

Create a Table

Remove a Table

Query a Table

Native Queries

Update a Table

Insert Into a Table

Join Tables On

Delete From a Table

Remove a View

Query a View

Remove a File

Query a File

Remove a Job

Query Jobs

Remove a Trigger

Query Triggers

Agents

Agent

Chatbot

Knowledge Base

Usage

Creates a new database connection. The example parameters below are for connecting to [MySQL](/data-integrations/mysql). See [here](/data-integrations/all-data-integrations) for which parameters to use for your datasource.

Updates an existing database connection, or creates a new connection if one doesn't exist. The example parameters below are for updating a [MySQL](/data-integrations/mysql) connection. See [here](/data-integrations/all-data-integrations) for which parameters to use for your datasource.

Update a Data Source

Deletes an existing database connection by name.

Get a Data Source

Get a Project

Starts training a new Machine Learning model.

Gets info about all models in the project.

Gets info for a specific model in the project.

Get a Model

Uses this model to make a prediction for values of new data.

Creates a new table from a select query. See [CREATE table documentation](https://docs.mindsdb.com/sql/create/table).

Gets metadata for all tables in a database.

List Tables

Get a Table

Query

Creates a [view](https://docs.mindsdb.com/sql/create/view) from a SELECT statement.

Overview

Concepts

Use Cases

​Connect to MindsDB

MindsDB SQL Editor

Postgres CLI

MySQL CLI

DBeaver

MariaDB SkySQL

SQL Alchemy

Deepnote

Metabase

Tableau

Jupyter Notebooks

Grafana

​SQL Syntax

​Databases

CREATE DATABASE

DROP DATABASE

USE

​Projects

CREATE PROJECT

DROP PROJECT

​Models

CREATE ML_ENGINE

DROP ML_ENGINE

CREATE MODEL

DROP MODEL

JOIN

DESCRIBE

RETRAIN

FINETUNE

Manage Model Versions

​Views

CREATE VIEW

DROP VIEW

​Tables

CREATE TABLE

DROP TABLE

SELECT

UPDATE

INSERT INTO

JOIN ON

​Files

Upload a File

Drop a File

SELECT FROM files

​Jobs

CREATE JOB

DROP JOB