Skip to content

Latest commit

 

History

History
105 lines (69 loc) · 3.67 KB

mindsdb-sql-overview.mdx

File metadata and controls

105 lines (69 loc) · 3.67 KB
Raw
title sidebarTitle
MindsDB SQL
Overview

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.

<Card title="MindsDB SQL Editor" icon="link" href="/connect/mindsdb_editor"></Card>
<Card title="Postgres CLI" icon="link" href="/connect/postgres-client"></Card>
<Card title="MySQL CLI" icon="link" href="/connect/mysql-client"></Card>
<Card title="DBeaver" icon="link" href="/connect/dbeaver"></Card>
<Card title="MariaDB SkySQL" icon="link" href="/connect/connect-mariadb-skysql"></Card>
<Card title="SQL Alchemy" icon="link" href="/connect/sql-alchemy"></Card>
<Card title="Deepnote" icon="link" href="/connect/deepnote"></Card>
<Card title="Metabase" icon="link" href="/connect/metabase"></Card>
<Card title="Tableau" icon="link" href="/connect/tableau"></Card>
<Card title="Jupyter Notebooks" icon="link" href="/connect/jupysql"></Card>

SQL Syntax

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

Databases

<Card title="CREATE DATABASE" icon="link" href="/sql/create/database"></Card>
<Card title="DROP DATABASE" icon="link" href="/sql/drop/database"></Card>
<Card title="USE" icon="link" href="/sql/api/use"></Card>

Projects

<Card title="CREATE PROJECT" icon="link" href="/sql/create/project"></Card>
<Card title="DROP PROJECT" icon="link" href="/sql/drop/project"></Card>

Models

<Card title="CREATE ML_ENGINE" icon="link" href="/sql/create/ml-engine"></Card>
<Card title="DROP ML_ENGINE" icon="link" href="/sql/drop/ml-engine"></Card>
<Card title="CREATE MODEL" icon="link" href="/sql/create/model"></Card>
<Card title="DROP MODEL" icon="link" href="/sql/drop/model"></Card>
<Card title="JOIN" icon="link" href="/sql/api/join"></Card>
<Card title="DESCRIBE" icon="link" href="/sql/api/describe"></Card>
<Card title="RETRAIN" icon="link" href="/sql/api/retrain"></Card>
<Card title="FINETUNE" icon="link" href="/sql/api/finetune"></Card>
<Card title="Manage Model Versions" icon="link" href="/sql/api/manage-models-versions"></Card>

Views

<Card title="CREATE VIEW" icon="link" href="/sql/create/view"></Card>
<Card title="DROP VIEW" icon="link" href="/sql/drop/view"></Card>

Tables

<Card title="CREATE TABLE" icon="link" href="/sql/create/table"></Card>
<Card title="DROP TABLE" icon="link" href="/sql/drop/table"></Card>
<Card title="SELECT" icon="link" href="/sql/api/select"></Card>
<Card title="UPDATE" icon="link" href="/sql/api/update"></Card>
<Card title="INSERT INTO" icon="link" href="/sql/api/insert"></Card>
<Card title="JOIN ON" icon="link" href="/sql/api/join-on"></Card>

Files

<Card title="Upload a File" icon="link" href="/sql/create/file"></Card>
<Card title="Drop a File" icon="link" href="/sql/drop/file"></Card>
<Card title="SELECT FROM files" icon="link" href="/sql/api/select-files"></Card>

Jobs

<Card title="CREATE JOB" icon="link" href="/sql/create/jobs"></Card>
<Card title="DROP JOB" icon="link" href="/sql/drop/jobs"></Card>