Overview

MindsDB SQL

MindsDB

Introduction

MindsDB AI SQL Server

Community Tutorials List

MindsDB SQL Syntax

Integrations Overview

How to Contribute

Contribute to MindsDB 🐻

Report an Issue

Report an Issue 📢

Issue Labels

MindsDB Installation for Development

Python Coding Standards

Building a Database Handler

Building an ML Handler

Building a Machine Learning Handler

Building an Application Handler

Writing Handlers README

Handlers README

Testing and Improving Test Coverage

Writing Tutorials

How to Write a Tutorial

Writing Documentation

MindsDB Documentation

Docs Style Guide

Style Guide for MindsDB Documentation

Join our Community

Join our Community 🐻

Whitelisting IPs

Whitelisting MindsDB Cloud Public IPs

Persisting Predictions

How to Persist Predictions

MindsDB and PHP

How to Interact with MindsDB from PHP

Benefits of MindsDB

Join our Slack

GitHub

Documentation

SQL API

SDKs

REST API

Integrations

Contribute

FAQs

Get Started

Login

Docker

Setup for Docker

Docker Extension

Setup as a Docker Extension

MindsDB GUI Overview

Navigating the MindsDB GUI

MindsDB Information Schema

Data Sources

Connect a Data Source

Projects

Create a View

Upload a File

Create a Job

JOBS

Create a Trigger

AI Engines & AI Tables

Generative AI Tables

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

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.