Description

Syntax

Join our Slack

GitHub

Website

MindsDB

Documentation

Use Cases

SQL API

SDKs

REST API

Integrations

Contribute

FAQs

Get Started

Blog

Events

News

Remove a Table

Introduction

MindsDB - Platform for Building AI

Quickstart

Tutorial to Get Started with MindsDB

Docker

Docker for MindsDB

Docker Desktop

Docker Desktop Extension for MindsDB

AWS Marketplace

MindsDB at AWS Marketplace

Model Management

AI Integrations

Data Integrations

Automation

MindsDB Schema

MindsDB Projects

AI Tables

Generative AI Tables

MindsDB GUI Overview

Navigating the MindsDB GUI

Models

Handlers

Overview

Applications of MindsDB

Automated Fine-Tuning

Mistral-7B

Fine-Tune the Mistral-7B Model

OpenAI

Fine-Tune the OpenAI Model

Classification

Fine-Tune the Classification Model

Regression

Fine-Tune the Regression Model

AI Agents

Build an AI Agent

Build an AI Agent with MindsDB

AI-Powered Data Retrieval

Embedding Model

Lightwood Embedding Model

Recommender Models

Data Enrichment

Image Generator

Generating Images with OpenAI

Extract JSON

Extract JSON from Text

Text Summarization using SQL

Text Summarization with MindsDB and OpenAI using SQL

Text Summarization using MQL

Text Summarization 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

Question Answering using SQL

Question Answering with MindsDB and OpenAI using SQL

Question Answering using MQL

Question Answering with MindsDB and OpenAI using MQL

Text Sentiment with Hugging Face

Predict Text Sentiment with Hugging Face and MindsDB

Hugging Face Models

Usage Examples of Hugging Face Models

Hugging Face Inference API

Usage Examples of Hugging Face Models Through Inference API

Predictive Analytics

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

In-Database Machine Learning

Customer Churn

Predict Customer Churn with MindsDB

Home Rentals

Predict Home Rental Prices with MindsDB

AI Workflow Automation

Slack Chatbot

Build a Slack Chatbot with MindsDB and OpenAI

Twitter Chatbot

Building a Twitter Chatbot with MindsDB and OpenAI

Twilio Chatbot

Build a Twilio Chatbot with MindsDB and OpenAI

Customer Reviews Notifications

Automate notifications about incoming customer reviews

Real-time Trading Forecasts

Automate Real-Time Trading Data Forecasts

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

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

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

Agent

Chatbot

Knowledge Base

Custom Functions

Upload Custom Functions

The LLM() Function

CTEs

Common Table Expressions

CASE WHEN

The CASE WHEN Statement

Aggregate Functions

SQL Aggregate Functions

Window Functions

SQL Window Functions

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

SDKs

​Description

​Syntax

Description

Syntax