1. Data Integrations
  2. Supported Integrations

The list of databases supported by MindsDB keeps growing. Here are the currently supported integrations:

You can find particular databases’ handler files here to see their connection arguments. For example, to see the latest updates to the Oracle handler, check Oracle’s readme.md file here.

Let’s look at sample codes showing how to connect to each of the supported integrations.

From Our Community

Check out the video guides created by our community:

Airtable

  • Template

  • Example

CREATE DATABASE airtable_datasource          --- display name for the database
WITH ENGINE = 'airtable',                    --- name of the MindsDB handler
PARAMETERS = {
  "base_id": " ",                            --- the Airtable base ID
  "table_name": " ",                         --- the Airtable table name
  "api_key": " "                             --- the API key for the Airtable API
};

Amazon Redshift

  • Template

  • Example

CREATE DATABASE amazonredshift_datasource         --- display name for the database
WITH ENGINE = 'amazonredshift',                   --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                                    --- host name or IP address of the Redshift cluster
  "port": ,                                       --- port used when connecting to the Redshift cluster
  "database": " ",                                --- database name used when connecting to the Redshift cluster
  "user": " ",                                    --- user to authenticate with the Redshift cluster
  "password": " "                                 --- password used to authenticate with the Redshift cluster
};

AWS DynamoDB

  • Template

  • Example

CREATE DATABASE dynamodb_datasource       --- display name for the database
WITH ENGINE = 'dynamodb',                 --- name of the MindsDB handler
PARAMETERS = {
  "aws_access_key_id": " ",               --- the AWS access key
  "aws_secret_access_key": " ",           --- the AWS secret access key
  "region_name": " "                      --- the AWS region
};

Cassandra

  • Template

  • Example

CREATE DATABASE cassandra_datasource        --- display name for the database
WITH ENGINE = 'cassandra',                  --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                              --- host name or IP address
  "port": ,                                 --- port used to make TCP/IP connection
  "user": " ",                              --- database user
  "password": " ",                          --- database password
  "keyspace": " ",                          --- database name
  "protocol_version": ,                     --- optional, protocol version (defaults to 4 if left blank)
  "secure_connect_bundle": {                --- optional, secure connect bundle file
    "path": " "                                 --- either "path" or "url"
  }
};

Ckan

  • Template

  • Example

CREATE DATABASE ckan_datasource          --- display name for the database
WITH ENGINE = 'ckan',                    --- name of the MindsDB handler
PARAMETERS = {
  "url": " ",                            --- host name, IP address, or a URL
  "apikey": " "                          --- the API key used for authentication
};

ClickHouse

  • Template

  • Example

CREATE DATABASE clickhouse_datasource       --- display name for the database
WITH ENGINE = 'clickhouse',                 --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                              --- host name or IP address
  "port": ,                                 --- port used to make TCP/IP connection
  "database": " ",                          --- database name
  "user": " ",                              --- database user
  "password": " ",                          --- database password
  "protocol": " "                           --- optional, http or https (defaults to `native`)
};

Cloud Spanner

  • Template

  • Example

CREATE DATABASE cloud_spanner_datasource       --- display name for the database
WITH ENGINE = 'cloud_spanner',                 --- name of the MindsDB handler
PARAMETERS = {
  "instance_id": " ",                          --- the instance identifier
  "database_id": ,                             --- the database identifier
  "project_id": " ",                           --- the identifier of the project that owns the instances and data
  "credentials": " ",                          --- a stringified GCP service account key JSON
};

Cockroach Labs

  • Template

  • Example

CREATE DATABASE cockroach_datasource        --- display name for the database
WITH ENGINE = 'cockroachdb',                --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                              --- host name or IP address
  "port": ,                                 --- port used to make TCP/IP connection
  "database": " ",                          --- database name
  "user": " ",                              --- database user
  "password": " ",                          --- database password
  "publish": " "                            --- optional, publish
};

Couchbase

  • Template

  • Example

CREATE DATABASE couchbase_datasource        --- display name for the database
WITH ENGINE = 'couchbase',                  --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                              --- host name or IP address of the Couchbase server
  "user": " ",                              --- user to authenticate with the Couchbase server
  "password": " ",                          --- password used to authenticate with the Couchbase server
  "bucket": " ",                            --- bucket name
  "scope": " "                              --- scope used to query (defaults to `_default` if left blank)
};                                              --- a scope in Couchbase is equivalent to a schema in MySQL

CrateDB

  • Template

  • Example

CREATE DATABASE cratedb_datasource        --- display name for the database
WITH ENGINE = 'crate',                    --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                            --- host name or IP address
  "port": ,                               --- port used to make TCP/IP connection
  "user": " ",                            --- database user
  "password": " ",                        --- database password
  "schema_name": " "                      --- database schema name (defaults to `doc` if left blank)
};

D0lt

  • Template

  • Example

CREATE DATABASE d0lt_datasource             --- display name for the database
WITH ENGINE = 'd0lt',                       --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                              --- host name or IP address
  "port": ,                                 --- port used to make TCP/IP connection
  "database": " ",                          --- database name
  "user": " ",                              --- database user
  "password": " ",                          --- database password
  "ssl": ,                                  --- optional, the `ssl` parameter value indicates whether SSL is enabled (`True`) or disabled (`False`)
  "ssl_ca": {                               --- optional, SSL Certificate Authority
    "path": " "                                 --- either "path" or "url"
  },
  "ssl_cert": {                             --- optional, SSL certificates
    "url": " "                                  --- either "path" or "url"
  },
  "ssl_key": {                              --- optional, SSL keys
    "path": " "                                 --- either "path" or "url"
  }
};

Databend

  • Template

  • Example

CREATE DATABASE databend_datasource     --- display name for the database
WITH ENGINE = 'databend',               --- name of the MindsDB handler
PARAMETERS = {
  "protocol": " ",                      --- protocol used to query Databend (defaults to `native` if left blank); supported protocols: native, http, https
  "user": " ",                          --- username used to authenticate with the Databend warehouse
  "port": ,                             --- TCP/IP port of the Databend warehouse
  "password": " ",                      --- password used to authenticate with the Databend warehouse
  "host": " ",                          --- host name or IP address of the Databend warehouse (use '127.0.0.1' instead of 'localhost' when connecting to a local server)
  "database": " "                       --- database name used when connecting to the Databend warehouse
};

Databricks

  • Template

  • Example

CREATE DATABASE databricks_datasource         --- display name for the database
WITH ENGINE = 'databricks',                   --- name of the MindsDB handler
PARAMETERS = {
  "server_hostname": " ",                     --- server hostname of the cluster or SQL warehouse
  "http_path": " ",                           --- http path to the cluster or SQL warehouse
  "access_token": " ",                        --- personal Databricks access token
  "schema": " ",                              --- schema name (defaults to `default` if left blank)
  "session_configuration": " ",               --- optional, dictionary of Spark session configuration parameters
  "http_headers": " ",                        --- optional, additional (key, value) pairs to set in HTTP headers on every RPC request the client makes
  "catalog": " "                              --- catalog (defaults to `hive_metastore` if left blank)
};

Datastax

  • Template

  • Example

CREATE DATABASE datastax_datasource           --- display name for the database
WITH ENGINE = 'astra',                        --- name of the MindsDB handler
PARAMETERS = {
  "user": " ",                                --- user to be authenticated
  "password": " ",                            --- password for authentication
  "secure_connection_bundle": {               --- secure connection bundle zip file
    "path": " "                                   --- either "path" or "url"
  },
  "host": " ",                                --- optional, host name or IP address
  "port": ,                                   --- optional, port used to make TCP/IP connection
  "protocol_version": ,                       --- optional, protocol version
  "keyspace": " "                             --- optional, keyspace
};

DB2

  • Template

  • Example

CREATE DATABASE db2_datasource        --- display name for the database
WITH ENGINE = 'DB2',                  --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                        --- host name or IP address
  "port": ,                           --- port used to make TCP/IP connection
  "database": " ",                    --- database name
  "user": " ",                        --- database user
  "password": " ",                    --- database password
  "schema_name": " "                  --- database schema name
};

Druid

  • Template

  • Example

CREATE DATABASE druid_datasource        --- display name for the database
WITH ENGINE = 'druid',                  --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                          --- host name or IP address of Apache Druid
  "port": ,                             --- port where Apache Druid runs
  "user": " ",                          --- optional, user to authenticate with Apache Druid
  "password": " ",                      --- optional, password used to authenticate with Apache Druid
  "path": " ",                          --- query path
  "scheme": " "                         --- the URI scheme (defaults to `http` if left blank)
};

DuckDB

  • Template

  • Example

CREATE DATABASE duckdb_datasource       --- display name for the database
WITH ENGINE = 'duckdb',                 --- name of the MindsDB handler
PARAMETERS = {
  "database": " ",                      --- database file name
  "read_only":                          --- flag used to set the connection to read-only mode
};
  • Template

  • Example

CREATE DATABASE elastic_datasource      --- display name for the database
WITH ENGINE = 'elasticsearch',          --- name of the MindsDB handler
PARAMETERS = {
  "hosts": " ",                         --- one or more host names or IP addresses of the Elasticsearch server
  "username": " ",                      --- optional, username to authenticate with the Elasticsearch server
  "password": " ",                      --- optional, password used to authenticate with the Elasticsearch server
  "cloud_id": " "                       --- optional, unique ID of your hosted Elasticsearch cluster (must be provided when "hosts" is left blank)
};

Firebird

  • Template

  • Example

CREATE DATABASE firebird_datasource         --- display name for the database
WITH ENGINE = 'firebird',                   --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                              --- host name or IP address of the Firebird server
  "database": " ",                          --- database name
  "user": " ",                              --- user to authenticate with the Firebird server
  "password": " "                           --- password used to authenticate with the Firebird server
};

Google BigQuery

  • Template

  • Example for Self-Hosted MindsDB

  • Example for MindsDB Cloud

CREATE DATABASE bigquery_datasource       --- display name for the database
WITH ENGINE = 'bigquery',                 --- name of the MindsDB handler
PARAMETERS = {
  "project_id": " ",                      --- globally unique project identifier
  "service_account_keys": {               --- service account keys file
    "path": " "                               --- either "path" or "url"
  }
};

Google Sheets

  • Template

  • Example

CREATE DATABASE sheets_datasource       --- display name for the database
WITH ENGINE = 'sheets',                 --- name of the MindsDB handler
PARAMETERS = {
  "spreadsheet_id": " ",                --- unique ID of the Google Sheet
  "sheet_name": " "                     --- name of the Google Sheet
};

Hive

  • Template

  • Example

CREATE DATABASE hive_datasource   --- display name for the database
WITH ENGINE = 'hive',             --- name of the MindsDB handler
PARAMETERS = {
  "user": " ",                    --- database user
  "password": " ",                --- database password
  "host": " ",                    --- host name or IP address
  "port": ,                       --- port used to make TCP/IP connection
  "database": " ",                --- database name
  "auth": " "                     --- defaults to CUSTOM if not provided; check for options here: https://pypi.org/project/PyHive/
};

Impala

  • Template

  • Example

CREATE DATABASE impala_datasource      --- display name for the database
WITH ENGINE = 'impala',                --- name of the MindsDB handler
PARAMETERS = {
  "user": " ",                         --- database user
  "password": " ",                     --- database password
  "host": " ",                         --- host name or IP address
  "port": ,                            --- port used to make TCP/IP connection
  "database": " "                      --- database name
};

Informix

  • Template

  • Example

CREATE DATABASE informix_datasource       --- display name for the database
WITH ENGINE = 'informix',                 --- name of the MindsDB handler
PARAMETERS = {
  "server": " ",                          --- server name
  "host": " ",                            --- host name or IP address
  "port": ,                               --- port used to make TCP/IP connection
  "database": " ",                        --- database name
  "user": " ",                            --- database user
  "password": " ",                        --- database password
  "schema_name": " ",                     --- database schema name
  "logging_enabled":                      --- indicates whether logging is enabled (defaults to `True` if left blank)
};

MariaDB

  • Template

  • Example

CREATE DATABASE maria_datasource            --- display name for the database
WITH ENGINE = 'mariadb',                    --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                              --- host IP address or URL
  "port": ,                                 --- port used to make TCP/IP connection
  "database": " ",                          --- database name
  "user": " ",                              --- database user
  "password": " ",                          --- database password
  "ssl": ,                                  --- optional, the `ssl` parameter value indicates whether SSL is enabled (`True`) or disabled (`False`)
  "ssl_ca": {                               --- optional, SSL Certificate Authority
    "path": " "                                 --- either "path" or "url"
  },
  "ssl_cert": {                             --- optional, SSL certificates
    "url": " "                                  --- either "path" or "url"
  },
  "ssl_key": {                              --- optional, SSL keys
    "path": " "                                 --- either "path" or "url"
  }
};

MariaDB SkySQL

  • Template

  • Example

CREATE DATABASE skysql            --- display name for the database
WITH ENGINE = 'mariadb',          --- name of the MindsDB handler
PARAMETERS = {
  "user": " ",                    --- database user
  "password": " ",                --- database password
  "host": " ",                    --- host IP address or URL
  "port": ,                       --- port used to make TCP/IP connection
  "ssl": ,                        --- optional, the `ssl` parameter value indicates whether SSL is enabled (`True`) or disabled (`False`)
  "ssl-ca": {                     --- optional, SSL Certificate Authority
    "path": " "                       --- either "path" or "url"
  },
  "database": " "                 --- database name
};

For more information on how to connect MariaDB SkySQL and MindsDB, visit our doc page here.

Matrix One

  • Template

  • Example

CREATE DATABASE matrixone_datasource        --- display name for the database
WITH ENGINE = 'matrixone',                  --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                              --- host IP address or URL
  "port": ,                                 --- port used to make TCP/IP connection
  "database": " ",                          --- database name
  "user": " ",                              --- database user
  "password": " ",                          --- database password
  "ssl": ,                                  --- optional, the `ssl` parameter value indicates whether SSL is enabled (`True`) or disabled (`False`)
  "ssl_ca": {                               --- optional, SSL Certificate Authority
    "path": " "                                 --- either "path" or "url"
  },
  "ssl_cert": {                             --- optional, SSL certificates
    "url": " "                                  --- either "path" or "url"
  },
  "ssl_key": {                              --- optional, SSL keys
    "path": " "                                 --- either "path" or "url"
  }
};

Microsoft Access

  • Template

  • Example

CREATE DATABASE access_datasource       --- display name for the database
WITH ENGINE = 'access',                 --- name of the MindsDB handler
PARAMETERS = {
  "db_file": " "                        --- path to the database file to be used
};

Microsoft SQL Server

  • Template

  • Example

CREATE DATABASE mssql_datasource        --- display name for the database
WITH ENGINE = 'mssql',                  --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                          --- host name or IP address
  "port": ,                             --- port used to make TCP/IP connection
  "database": " ",                      --- database name
  "user": " ",                          --- database user
  "password": " "                       --- database password
};

MonetDB

  • Template

  • Example

CREATE DATABASE monetdb_datasource          --- display name for the database
WITH ENGINE = 'monetdb',                    --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                              --- host name or IP address
  "port": ,                                 --- port used to make TCP/IP connection
  "database": " ",                          --- database name
  "user": " ",                              --- database user
  "password": " ",                          --- database password
  "schema_name": " "                        --- database schema name (defaults to the current schema if left blank)
};

MongoDB

For this connection, we strongly suggest using the Mongo API instead of the SQL API

MindsDB has a dedicated Mongo API that allows you to use the full power of the MindsDB platform. Using the Mongo API will feel more natural for MongoDB users and allow you to use all the features of MindsDB.

You can find the instructions on how to connect MindsDB to MongoDB Compass here or MongoDB Shell here and proceed with the Mongo API documentation for further details.

  • Template

  • Example

CREATE DATABASE mongo_datasource          --- display name for the database
WITH ENGINE = 'mongo',                    --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                            --- host name or IP address
  "port": ,                               --- port used to make TCP/IP connection
  "user": " ",                            --- database user
  "password": " "                         --- database password
  "database": " "                         --- database name
};

MySQL

  • Template

  • Example

CREATE DATABASE mysql_datasource            --- display name for the database
WITH ENGINE = 'mysql',                      --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                              --- host name or IP address
  "port": ,                                 --- port used to make TCP/IP connection
  "database": " ",                          --- database name
  "user": " ",                              --- database user
  "password": " ",                          --- database password
  "ssl": ,                                  --- optional, the `ssl` parameter value indicates whether SSL is enabled (`True`) or disabled (`False`)
  "ssl_ca": {                               --- optional, SSL Certificate Authority
    "path": " "                                 --- either "path" or "url"
  },
  "ssl_cert": {                             --- optional, SSL certificates
    "url": " "                                  --- either "path" or "url"
  },
  "ssl_key": {                              --- optional, SSL keys
    "path": " "                                 --- either "path" or "url"
  }
};

OceanBase

  • Template

  • Example

CREATE DATABASE oceanbase_datasource      --- display name for the database
WITH ENGINE = 'oceanbase',                --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                            --- host name or IP address
  "user": " ",                            --- database user
  "password": " ",                        --- database password
  "port": ,                               --- port used to make TCP/IP connection
  "database": " "                         --- database name
};

OpenGauss

  • Template

  • Example

CREATE DATABASE opengauss_datasource            --- display name for the database
WITH ENGINE = 'opengauss',                      --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                                  --- host name or IP address
  "port": ,                                     --- port used to make TCP/IP connection
  "database": " ",                              --- database name
  "user": " ",                                  --- database user
  "password": " ",                              --- database password
};

Oracle

  • Template

  • Example

CREATE DATABASE oracle_datasource         --- display name for the database
WITH ENGINE = 'oracle',                   --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                            --- host name or IP address
  "port": ,                               --- port used to make TCP/IP connection
  "sid": " ",                             --- unique identifier of the database instance
  "user": " ",                            --- database user
  "password": " "                         --- database password
};

OrioleDB

  • Template

  • Example

CREATE DATABASE orioledb_datasource      --- display name for the database
WITH ENGINE = 'orioledb',                --- name of the MindsDB handler
PARAMETERS = {
  "user": " ",                           --- database user
  "password": " ",                       --- database password
  "host": " ",                           --- host name or IP address
  "port": ,                              --- port used to make TCP/IP connection
  "server": " ",                         --- sets the current server
  "database": " "                        --- sets the current database
};

Pinot

  • Template

  • Example

CREATE DATABASE pinot_datasource        --- display name for the database
WITH ENGINE = 'pinot',                  --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                          --- host name or IP address of the Apache Pinot cluster
  "broker_port": ,                      --- port where the broker of the Apache Pinot cluster runs
  "controller_port": ,                  --- port where the controller of the Apache Pinot cluster runs
  "path": " ",                          --- query path
  "scheme": " ",                        --- scheme (defaults to `http` if left blank)
  "username": " ",                      --- optional, user
  "password": " ",                      --- optional, password
  "verify_ssl": " "                     --- optional, verify SSL
};

PlanetScale

  • Template

  • Example

CREATE DATABASE planetscale_datasource     --- display name for the database
WITH ENGINE = 'planet_scale',              --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                             --- host name or IP address
  "port": ,                                --- port used to make TCP/IP connection
  "user": " ",                             --- database user
  "password": " ",                         --- database password
  "database": " "                          --- database name
};

PostgreSQL

  • Template

  • Example

CREATE DATABASE psql_datasource         --- display name for the database
WITH ENGINE = 'postgres',               --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                          --- host name or IP address
  "port": ,                             --- port used to make TCP/IP connection
  "database": " ",                      --- database name
  "user": " ",                          --- database user
  "password": " "                       --- database password
};

QuestDB

  • Template

  • Example

CREATE DATABASE questdb_datasource      --- display name for the database
WITH ENGINE = 'questdb',                --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                          --- host name or IP address
  "port": ,                             --- port used to make TCP/IP connection
  "database": " ",                      --- database name
  "user": " ",                          --- database user
  "password": " ",                      --- database password
  "public":                             --- value of `True` or `False` (defaults to `True` if left blank)
};

S3

  • Template

  • Example

CREATE DATABASE amazons3_datasource     --- display name for the database
WITH ENGINE = 's3',                     --- name of the MindsDB handler
PARAMETERS = {
  "aws_access_key_id": " ",             --- the AWS access key
  "aws_secret_access_key": " ",         --- the AWS secret access key
  "region_name": " ",                   --- the AWS region
  "bucket": " ",                        --- name of the S3 bucket
  "key": " ",                           --- key of the object to be queried
  "input_serialization": " "            --- format of the data to be queried
};

SAP HANA

  • Template

  • Example

CREATE DATABASE sap_hana_datasource           --- display name for the database
WITH ENGINE = 'hana',                         --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                                --- host name or IP address
  "port": ,                                   --- port used to make TCP/IP connection
  "user": " ",                                --- user
  "password": " ",                            --- password
  "schema": " ",                              --- database schema name (defaults to the current schema if left blank)
  "encrypt":                                  --- indicates whether connection is encrypted (required for cloud usage)
};

Scylla

  • Template

  • Example

CREATE DATABASE scylladb_datasource           --- display name for the database
WITH ENGINE = 'scylladb',                     --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                                --- host name or IP address
  "port": ,                                   --- port used to make TCP/IP connection
  "user": " ",                                --- user
  "password": " ",                            --- password
  "protocol_version": ,                       --- optional, protocol version (defaults to 4 if left blank)
  "keyspace": " ",                            --- keyspace name (it is the top level container for tables)
  "secure_connect_bundle": {                  --- secure connect bundle file
    "path": " "                                   --- either "path" or "url"
  }
};

SingleStore

  • Template

  • Example

CREATE DATABASE singlestore_datasource          --- display name for the database
WITH ENGINE = 'singlestore',                    --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                                  --- host name or IP address
  "port": ,                                     --- port used to make TCP/IP connection
  "database": " ",                              --- database name
  "user": " ",                                  --- database user
  "password": " ",                              --- database password
  "ssl": ,                                      --- optional, the `ssl` parameter value indicates whether SSL is enabled (`True`) or disabled (`False`)
  "ssl_ca": {                                   --- optional, SSL Certificate Authority
    "path": " "                                     --- either "path" or "url"
  },
  "ssl_cert": {                                 --- optional, SSL certificates
    "url": " "                                      --- either "path" or "url"
  },
  "ssl_key": {                                  --- optional, SSL keys
    "path": " "                                     --- either "path" or "url"
  }
};

Snowflake

  • Template

  • Example

CREATE DATABASE snowflake_datasource              --- display name for the database
WITH ENGINE = 'snowflake',                        --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                                    --- host name or IP address
  "port": ,                                       --- port used to make TCP/IP connection
  "database": " ",                                --- database name
  "user": " ",                                    --- database user
  "password": " ",                                --- database password
  "account": " ",                                 --- the Snowflake account
  "schema": " ",                                  --- schema name (defaults to `public` if left blank)
  "protocol": " ",                                --- protocol (defaults to `https` if left blank)
  "warehouse": " "                                --- the warehouse account
};

Solr

  • Template

  • Example

CREATE DATABASE solr_datasource   --- display name for the database
WITH ENGINE = 'solr',             --- name of the MindsDB handler
PARAMETERS = {
  "username": " ",                --- optional, username used to authenticate with the Solr server
  "password": " ",                --- optional, password used to authenticate with the Solr server
  "host": " ",                    --- host name or IP address of the Solr serve
  "port": ,                       --- port number of the Solr server
  "server_path": " ",             --- defaults to `solr` if left blank
  "collection": " ",              --- Solr Collection name
  "use_ssl": " "                  --- defaults to `false` if left blank; refer to https://pypi.org/project/sqlalchemy-solr/
};

SQL Anywhere

  • Template

  • Example

CREATE DATABASE sqlany_datasource   --- display name for the database
WITH ENGINE = 'sqlany',             --- name of the MindsDB handler
PARAMETERS = {
  "user": " ",                      --- username
  "password": " ",                  --- password
  "host": " ",                      --- host name or IP address of the SAP SQL Anywhere instance
  "port": ,                         --- port number of the SAP SQL Anywhere instance
  "server": " ",                    --- sets the current server
  "database": " "                   --- sets the current database
};

SQLite

  • Template

  • Example

CREATE DATABASE sqlite_datasource         --- display name for the database
WITH ENGINE = 'sqlite',                   --- name of the MindsDB handler
PARAMETERS = {
  "db_file": " "                          --- path to the database file to be used
};

StarRocks

  • Template

  • Example

CREATE DATABASE starrocks_datasource      --- display name for the database
WITH ENGINE = 'starrocks',                --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                            --- host name or IP address
  "user": " ",                            --- database user
  "password": " ",                        --- database password
  "port": ,                               --- port used to make TCP/IP connection
  "database": " "                         --- database name
};

Supabase

  • Template

  • Example

CREATE DATABASE supabase_datasource             --- display name for the database
WITH ENGINE = 'supabase',                       --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                                  --- host name or IP address
  "port": ,                                     --- port used to make TCP/IP connection
  "database": " ",                              --- database name
  "user": " ",                                  --- database user
  "password": " ",                              --- database password
};

TDEngine

  • Template

  • Example

CREATE DATABASE tdengine_datasource   --- display name for the database
WITH ENGINE = 'tdengine',             --- name of the MindsDB handler
PARAMETERS = {
  "user": " ",                        --- server username
  "password": " ",                    --- server password
  "url": " ",                         --- URL to the TDEngine server (for local server, it is localhost:6041 by default)
  "token": " ",                       --- unique token provided when using TDEngine Cloud
  "database": " "                     --- database name
};

Teradata

  • Template

  • Example

CREATE DATABASE teradata_datasource     --- display name for the database
WITH ENGINE = 'teradata',               --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                          --- host name or IP address
  "user": " ",                          --- database user
  "password": " ",                      --- database password
  "database": " ",                      --- database name
  "port":                               --- port used to make TCP/IP connection
};

TiDB

  • Template

  • Example

CREATE DATABASE tidb_datasource                 --- display name for the database
WITH ENGINE = 'tidb',                           --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                                  --- host name or IP address
  "port": ,                                     --- port used to make TCP/IP connection
  "database": " ",                              --- database name
  "user": " ",                                  --- database user
  "password": " ",                              --- database password
};

Timescaledb

  • Template

  • Example

CREATE DATABASE timescaledb_datasource    --- display name for the database
WITH ENGINE = 'timescaledb',              --- name of the MindsDB handler
PARAMETERS = {
  "user": " ",                            --- database user
  "password": " ",                        --- database password
  "host": " ",                            --- host name or IP address
  "port": ,                               --- port used to make TCP/IP connection
  "database": " "                         --- database name
};

Trino

  • Template

  • Example 1

  • Example 2

CREATE DATABASE trino_datasource          --- display name for the database
WITH ENGINE = 'trino',                    --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                            --- host name or IP address
  "port": ,                               --- port used to make TCP/IP connection
  "auth": " ",                            --- optional, authentication method, currently only `basic` is supported
  "http_scheme": " ",                     --- optional, `http`(default) or `https`
  "user": " ",                            --- database user
  "password": " ",                        --- database password
  "catalog": " ",                         --- optional, catalog
  "schema": " "                           --- optional, schema
  "with":                                 --- optional, default WITH-clause (properties) for ALL tables
                                              --- this parameter is experimental and might be changed or removed in future release
};

Vertica

  • Template

  • Example

CREATE DATABASE vertica_datasource        --- display name for the database
WITH ENGINE = 'vertica',                  --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                            --- host name or IP address
  "port": ,                               --- port used to make TCP/IP connection
  "database": " ",                        --- database name
  "user": " ",                            --- database user
  "password": " ",                        --- database password
  "schema_name": " "                      --- database schema name
};

Vitess

  • Template

  • Example

CREATE DATABASE vitess_datasource       --- display name for the database
WITH ENGINE = 'vitess',                 --- name of the MindsDB handler
PARAMETERS = {
  "host": " ",                          --- host name or IP address
  "user": " ",                          --- database user
  "password": " ",                      --- database password
  "port": ,                             --- port used to make TCP/IP connection
  "database": " "                       --- database name
};

Yugabyte

  • Template

  • Example

CREATE DATABASE yugabyte_datasource       --- display name for the database
WITH ENGINE = 'yugabyte',                 --- name of the MindsDB handler
PARAMETERS = {
  "user": " ",                            --- database user
  "password": " ",                        --- database password
  "host": " ",                            --- host name or IP address
  "port": ,                               --- port used to make TCP/IP connection
  "database": " "                         --- database name
};