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.