Supported Databases

Tablen supports 21 database engines across SQL, NoSQL, and cloud categories. Each database type uses a dedicated driver optimized for that engine's protocol and capabilities.

Experimental engines

Ten of the 21 engines are flagged Experimental in the app and show an "Experimental" badge in the connection type picker: BigQuery, Oracle, SQL Server, SQL Anywhere, Firebird, Cassandra, Trino, SurrealDB, DuckDB, and DynamoDB. An engine is marked experimental when at least one of the following is true: the driver hasn't yet passed the full integration test matrix, it depends on a third-party component that isn't yet shipped signed/notarized, or protocol coverage is still partial (e.g. read-only or limited DDL). These engines are usable, but expect rough edges — opt in with eyes open. The remaining engines (PostgreSQL, MySQL, SQLite, MongoDB, Redis, CockroachDB, Redshift, MariaDB, TiDB, libSQL, ClickHouse) are considered stable.

SQL Databases

PostgreSQL

• Default Port: 5432
• Driver Family: PostgreSQL (PostgresNIO)
• Features: Full SQL support, SSL/TLS with self-signed certificate support, SSH tunnel, EXPLAIN analysis, schema browsing, ER diagrams, data profiling, user management
• Compatible Variants: CockroachDB, Redshift (share the same driver family)
• SSL: Supports .prefer() mode with optional certificate verification skip for self-signed certificates

MySQL

• Default Port: 3306
• Driver Family: MySQL (MySQLNIO)
• Features: Full SQL support, SSL/TLS, SSH tunnel, EXPLAIN analysis, schema browsing, process list viewer, table maintenance
• Compatible Variants: MariaDB, TiDB (share the same driver family)

SQLite

• Default Port: N/A (file-based)
• Driver Family: SQLite (GRDB.swift)
• Features: Full SQL support, file-based connections, schema browsing, data profiling
• Note: Requires a file path instead of host/port configuration

SQL Server (Microsoft)

• Default Port: 1433
• Driver Family: Standalone
• Features: Full SQL support, SSL/TLS, SSH tunnel, schema browsing

Oracle

• Default Port: 1521
• Driver Family: Standalone
• Features: Full SQL support, SSL/TLS, SSH tunnel, schema browsing

SQL Anywhere (SAP)

• Default Port: 2638
• Driver Family: Standalone
• Features: Full SQL support, SSL/TLS, SSH tunnel

Firebird

• Default Port: 3050
• Driver Family: Standalone
• Features: Full SQL support, SSL/TLS, SSH tunnel

CockroachDB

• Default Port: 26257
• Driver Family: PostgreSQL
• Features: Uses the PostgreSQL driver. Fully compatible with PostgreSQL protocol.
• Note: Inherits all PostgreSQL driver capabilities

Redshift (Amazon)

• Default Port: 5439
• Driver Family: PostgreSQL
• Features: Uses the PostgreSQL driver. Optimized for data warehouse queries.

MariaDB

• Default Port: 3306
• Driver Family: MySQL
• Features: Uses the MySQL driver. Fully compatible with MySQL protocol.

TiDB

• Default Port: 4000
• Driver Family: MySQL
• Features: Uses the MySQL driver. Compatible with MySQL protocol.

libSQL

• Default Port: N/A (file-based)
• Driver Family: SQLite
• Features: Uses the SQLite driver. File-based like SQLite.

ClickHouse

• Default Port: 8123
• Driver Family: Standalone
• Features: Optimized for analytical queries, HTTP protocol

Trino

• Default Port: 8080
• Driver Family: Standalone
• Features: Distributed SQL query engine support

DuckDB

• Default Port: N/A (file-based)
• Driver Family: Standalone
• Features: File-based analytical database, requires file path

NoSQL Databases

MongoDB

• Default Port: 27017
• Driver Family: Standalone
• Features: Document browsing, collection management, query support

Redis

• Default Port: 6379
• Driver Family: Standalone
• Features: Key browser, key-value operations, no database name required
• Special UI: Dedicated Redis Key Browser view in the result table

SurrealDB

• Default Port: 8000
• Driver Family: Standalone
• Features: Multi-model database support, HTTP protocol

Cassandra

• Default Port: 9042
• Driver Family: Standalone
• Features: Wide-column store support, CQL queries

Cloud Databases

DynamoDB (Amazon)

• Default Port: 443 (HTTPS API)
• Driver Family: Standalone (hand-rolled AWS Signature V4, no SDK)
• Features: PartiQL queries (SELECT/INSERT/UPDATE/DELETE), table browsing with key schema (partition/sort key), works with AWS DynamoDB and DynamoDB Local
• Connection fields: Host = AWS region (e.g. eu-central-1) or a full endpoint URL for DynamoDB Local (e.g. http://localhost:8000); Username = Access Key ID; Password = Secret Access Key (stored in the Keychain)

BigQuery (Google)

• Default Port: 443
• Driver Family: Standalone
• Features: Cloud-native analytical queries, Google Cloud authentication

Driver Families

Tablen organizes database drivers into families. Databases within the same family share the underlying driver implementation:

Connection Configuration by Database Type

File-Based Databases

SQLite, libSQL, and DuckDB require a file path instead of host/port. Use the file picker in the connection dialog to select your database file.

Network Databases

All other databases require:

• Host (defaults to "localhost", resolved to 127.0.0.1 for sandbox compatibility)
• Port (auto-filled with the default port for the selected database type)
• Database name (except Redis)
• Username and Password (stored in macOS Keychain)

SSL/TLS Support

All network databases support SSL/TLS connections:

• Enable SSL in the connection settings
• Optionally skip certificate verification for self-signed certificates (sslSkipVerify)
• PostgreSQL uses .prefer() TLS mode by default

SSH Tunnel Support

All network databases support SSH tunneling:

• Password authentication
• Key file authentication
• Configurable SSH host, port, and username

Proxy Support

All network databases support proxy connections:

• HTTP Proxy
• SOCKS5 Proxy
• HTTP Tunnel