Skip to main content

Databases we support

Databases we support and how to connect

If a database is not on the list, we'd still love to support it. Please open an issue to discuss it.

DatabaseDB_URI stringStatus
PostgreSQL >=10postgresql://<username>:'<password>'@<host>:5432/<database>💚
MySQLmysql://<username>:<password>@<hostname>:5432/<database>💚
SnowflakeWith password:"snowflake://<USER>:<password>@<ACCOUNT>/<DATABASE>/<SCHEMA>?warehouse=<WAREHOUSE>&role=<ROLE>"
With SSO: "snowflake://<USER>@<ACCOUNT>/<DATABASE>/<SCHEMA>?warehouse=<WAREHOUSE>&role=<ROLE>&authenticator=externalbrowser"
Note: Unless something is explicitly case sensitive (like your password) use all caps.
💚
BigQuerybigquery://<project>/<dataset>💚
Redshiftredshift://<username>:<password>@<hostname>:5439/<database>💚
Oracleoracle://<username>:<password>@<hostname>/database💚
Prestopresto://<username>:<password>@<hostname>:8080/<database>💛
Databricksdatabricks://:<access_token>@<server_name>/<http_path>?catalog=<catalog>&schema=<schema>💛
Trinotrino://<username>:<password>@<hostname>:8080/<database>💛
Clickhouseclickhouse://<username>:<password>@<hostname>:9000/<database>💛
Verticavertica://<username>:<password>@<hostname>:5433/<database>💛
DuckDBduckdb://<database>@<dbpath>💛
SQLite📝
  • 💚: Implemented and thoroughly tested.
  • 💛: Implemented, but not thoroughly tested yet.

Note: Because URLs allow many special characters, and may collide with the syntax of your command-line, it's recommended to surround them with quotes. Alternatively, you may provide them in a TOML file.