Supported databases and drivers
In Connections → Add New Connection, choose your database type to see its connection fields. If your database provider gives you a different host or port from the form’s defaults, use the provider’s values.
Which driver does my database use?
| Connection method | Example databases | Setup |
|---|---|---|
| Built-in TCP driver | MySQL, PostgreSQL, SQL Server | Enter the server address and credentials. |
| Built-in local file driver | SQLite, SQLCipher | Choose a local file. SQLCipher also requires the encryption key. |
| MySQL-compatible driver | MariaDB, TiDB, OceanBase in MySQL mode, Doris, StarRocks | Select your engine's profile. Use its configured SQL port. |
| PostgreSQL-compatible driver | CockroachDB, TimescaleDB, Redshift, YugabyteDB, openGauss | Select your engine's profile and enter the target database. |
| JDBC bridge | Oracle, DuckDB, Firebird, Snowflake, IBM Db2, BigQuery, Cassandra, ScyllaDB | Set up Java and the driver. Connection fields depend on the engine. |
| HTTP-based connection | ClickHouse, Trino, Presto, rqlite, Turso | Use the endpoint and port for that profile. For ClickHouse, 8123 is the default HTTP port. |
The SqlKit product page lists more examples. The database type picker shows the profiles in your installed version.
Which tools are available after connecting?
- Select the database and schema if your engine uses them. The object tree shows objects the engine provides, such as views and procedures.
- Whether you can view plans, edit rows, or export data depends on the engine and your account permissions. See the SQL editor for query plans and the table browser for editing or exporting rows.
- For Cassandra or ScyllaDB, select a keyspace. The table view shows a preview. Write a CQL statement in the editor to filter or sort using the database’s own rules.
If a connection opens but a workflow fails, check the active database and schema, the permissions of your database account, and the SQL dialect your engine accepts. See connection troubleshooting for network and driver errors.
