MindsDB SQL

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