List of supported databases
| Database | Status | Connection string |
|---|---|---|
| PostgreSQL >=10 | 💚 | postgresql://<user>:<password>@<host>:5432/<database> |
| MySQL | 💚 | mysql://<user>:<password>@<hostname>:5432/<database> |
| Snowflake | 💚 | "snowflake://<user>[:<password>]@<account>/<database>/<SCHEMA>?warehouse=<WAREHOUSE>&role=<role>[&authenticator=externalbrowser]" |
| BigQuery | 💚 | bigquery://<project>/<dataset> |
| Redshift | 💚 | redshift://<username>:<password>@<hostname>:5439/<database> |
| Oracle | 💛 | oracle://<username>:<password>@<hostname>/database |
| Presto | 💛 | presto://<username>:<password>@<hostname>:8080/<database> |
| Databricks | 💛 | databricks://<http_path>:<access_token>@<server_hostname>/<catalog>/<schema> |
| Trino | 💛 | trino://<username>:<password>@<hostname>:8080/<database> |
| Clickhouse | 💛 | clickhouse://<username>:<password>@<hostname>:9000/<database> |
| Vertica | 💛 | vertica://<username>:<password>@<hostname>:5433/<database> |
| DuckDB | 💛 | |
| ElasticSearch | 📝 | |
| Planetscale | 📝 | |
| Pinot | 📝 | |
| Druid | 📝 | |
| Kafka | 📝 | |
| SQLite | 📝 |
💚: Implemented and thoroughly tested.
💛: Implemented, but not thoroughly tested yet.
⏳: Implementation in progress.
📝: Implementation planned. Contributions welcome.
Is your database not listed here? We accept pull-requests!