Join our Slack

GitHub

MindsDB

Documentation

SQL API

SDKs

REST API

Integrations

Contribute

FAQs

Get Started

Login

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

Create a View

This endpoint creates a view which is a result-set of the SELECT statement.

Introduction

MindsDB - Platform for Building Custom AI

Docker

Docker for MindsDB

Docker Desktop

Docker Desktop Extension for MindsDB

Quickstart

Tutorial to Get Started with MindsDB

MindsDB GUI Overview

Navigating the MindsDB GUI

MindsDB Information Schema

AI Tables

Generative AI Tables

Data Sources

Automation

Automation with MindsDB

Overview

Applications of MindsDB

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

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

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

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

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

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).

REST API

Create a View

Path Parameters

Body

Response