MindsDB offers a tailored SQL syntax that enables seamless interaction with a wide range of objects, including databases, projects, models, views, tables, files, and jobs. Moreover, you have the flexibility to connect MindsDB with various SQL clients, facilitating streamlined integration.

​
Connect to MindsDB

This section contains guides on how to connect MindsDB to various SQL clients.

MindsDB SQL Editor

Postgres CLI

MySQL CLI

DBeaver

MariaDB SkySQL

SQL Alchemy

Deepnote

Metabase

Tableau

Jupyter Notebooks

Grafana

​
SQL Syntax

This section contains guides on how to work with databases, projects, models, views, tables, files, and jobs.

​
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