CREATE DATABASE Statement

Description

MindsDB enables connections to your favorite databases, data warehouses, data lakes, via the CREATE DATABASE syntax.

Our MindsDB SQL API supports creating a database connection by passing any credentials needed by each type of system that you are connecting to.

Syntax

CREATE DATABASE [datasource_name]
WITH
    engine=[engine_string],
    parameters={
            "key":"value",
            ...
        };

On execution, you should get:

Query OK, 0 rows affected (x.xxx sec)

Where:

	Description
[datasource_name]	Identifier for the datasource to be created
[engine_string]	Engine to be selected depending on the database connection
parameters	{"key":"value"} object with the conection parametes especific for each engine

Example

Here is a concrete example on how to connect to a MySQL database.

CREATE DATABASE mysql_datasource
WITH
 engine='mariadb',
 parameters={
                "user":"root",
                "port": 3307,
                "password": "Mimzo3i-mxt@9CpThpBj",
                "host": "127.0.0.1",
                "database": "my_database"
        };

On execution:

Query OK, 0 rows affected (8.878 sec)

Listing Linked DATABASES

You can list linked databases as follows:

SHOW DATABASES;

On execution:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mindsdb            |
| files              |
| views              |
| example_db         |
+--------------------+

Getting Linked DATABASES Metadata

You can also get metadata about the linked databases in mindsdb.datasources:

SELECT * FROM mindsdb.datasources;

On execution:

+------------+---------------+--------------+------+-----------+
| name       | database_type | host         | port | user      |
+------------+---------------+--------------+------+-----------+
| example_db | postgres      | 3.220.66.106 | 5432 | demo_user |
+------------+---------------+--------------+------+-----------+

Example configurations

Snowflake

CREATE DATABASE snowflake_datasource
WITH
    engine='snowflake',
    parameters={
            "user":"user",
            "port": 443,
            "password": "Mimzo3i-mxt@9CpThpBj",
            "host": "127.0.0.1",
            "database": "snowflake",
            "account": "account",
            "schema": "public",
            "protocol": "https",
            "warehouse": "warehouse"
    };

Singlestore

CREATE DATABASE singlestore_datasource
WITH
    engine='singlestore',
    parameters={
            "user":"root",
            "port": 3306,
            "password": "Mimzo3i-mxt@9CpThpBj",
            "host": "127.0.0.1",
            "database": "singlestore"
    };

MySQL

CREATE DATABASE mysql_datasource
WITH
    engine='mysql',
    parameters={
            "user":"root",
            "port": 3306,
            "password": "Mimzo3i-mxt@9CpThpBj",
            "host": "127.0.0.1",
            "database": "mysql"
    };

ClickHouse

CREATE DATABASE clickhouse_datasource
WITH
    engine='clickhouse',
    parameters={
            "user":"default",
            "port": 9000,
            "password": "Mimzo3i-mxt@9CpThpBj",
            "host": "127.0.0.1",
            "database": "default"
    };

PostgreSQL

CREATE DATABASE psql_datasource
WITH
    engine='postgres',
    parameters={
            "user":"postgres",
            "port": 5432,
            "password": "Mimzo3i-mxt@9CpThpBj",
            "host": "127.0.0.1",
            "database": "postgres"
    };

Cassandra

CREATE DATABASE psql_datasource
WITH
    engine='cassandra',
    parameters={
            "user":"cassandra",
            "port": 9042,
            "password": "cassandra",
            "host": "127.0.0.1",
            "database": "keyspace"
    };

MariaDB

CREATE DATABASE maria_datasource
WITH
    engine='mariadb',
    parameters={
            "user":"root",
            "port": 3306,
            "password": "Mimzo3i-mxt@9CpThpBj",
            "host": "127.0.0.1",
            "database": "mariadb"
    };

Microsoft SQL Server

CREATE DATABASE mssql_datasource
WITH
    engine='mssql',
    parameters={
            "user":"sa",
            "port": 1433,
            "password": "Mimzo3i-mxt@9CpThpBj",
            "host": "127.0.0.1",
            "database": "master"
    };

Scylladb

CREATE DATABASE scylladb_datasource
WITH
    engine='scylladb',
    parameters={
            "user":"scylladb",
            "port": 9042,
            "password": "Mimzo3i-mxt@9CpThpBj",
            "host": "127.0.0.1",
            "database": "scylladb"
    };

Trino

CREATE DATABASE trino_datasource
WITH
    engine='trinodb',
    parameters={
            "user":"trino",
            "port": 8080,
            "password": "Mimzo3i-mxt@9CpThpBj",
            "host": "127.0.0.1",
            "catalog": "default",
            "schema": "test"
    };

QuestDB

CREATE DATABASE questdb_datasource
WITH
    engine='questdb',
    parameters={
            "user":"admin",
            "port": 8812,
            "password": "quest",
            "host": "127.0.0.1",
            "database": "qdb"
    };

Work in progress

Note this feature is in beta version. If you have additional questions about other supported datasources or you expirience some issues reach out to us on Slack or open GitHub issue.