Overview

MindsDB SQL

MindsDB

Introduction

MindsDB - Platform for Customizing AI

Quickstart

Tutorial to Get Started with MindsDB

Model Management

AI Integrations

Data Integrations

Automation

Applications of MindsDB

MindsDB SQL Syntax

Integrations Overview

Data Sources

AI Engines & AI Tables

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

AI Tables

Generative AI Tables

MindsDB GUI Overview

Navigating the MindsDB GUI

MindsDB Information Schema

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

Customer reviews notifcations

Automate notifications about incoming customer reviews

Real-time trading forecasts

Automate Real-Time Trading Data Forecasts

Image Generator

Generating Images with OpenAI

Extract JSON

Semantic Search with RAG

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

Forecast Quarterly House Sales

Forecast Quarterly House Sales with MindsDB

Forecast Monthly Expenditures

Forecast Monthly Expenditures with Nixtla's StatsForecast and MindsDB

Brain Activity

Forecasting Eye State from Electroencephalogram Readings with MindsDB

Customer Churn

Predicting Customer Churn with MindsDB

Predict Home Rental Prices

Predict Home Rental Prices with MindsDB

Predict Text Sentiment

Predict Text Sentiment with Hugging Face and 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

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

Connect a Data Source

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

Evaluate Predictions

EVALUATE

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

Create a View

Remove a View

Query a View

Upload a File

Remove a File

Query a File

Create a Job

JOBS

Remove a Job

Query Jobs

Create a Trigger

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.

Updates an existing view, or creates a new view if one doesn't exist.

Update a View

List Views