Connection URL Reference
TablePro parses standard database connection URLs for importing connections, opening them directly from a browser or terminal, and configuring SSH tunnels. This page covers every supported scheme, format, and query parameter.
URL Schemes
| Scheme | Database |
|---|
postgresql:// | PostgreSQL |
postgres:// | PostgreSQL (alias) |
mysql:// | MySQL |
mariadb:// | MariaDB |
sqlite:// | SQLite |
mongodb:// | MongoDB |
mongodb+srv:// | MongoDB (SRV) |
redis:// | Redis |
rediss:// | Redis with TLS |
redshift:// | Amazon Redshift |
mssql:// | Microsoft SQL Server |
sqlserver:// | Microsoft SQL Server (alias) |
oracle:// | Oracle Database |
jdbc:oracle:thin:@// | Oracle Database (JDBC thin) |
cassandra:// | Cassandra |
scylladb:// | ScyllaDB |
+ssh to any scheme (except SQLite) to use an SSH tunnel:
postgresql+ssh://
mysql+ssh://
mariadb+ssh://
scheme://[username[:password]@]host[:port][/database][?param=value&...]
Passwords containing special characters (@, #, %, :) must be percent-encoded. For example, p@ss#word becomes p%40ss%23word.
scheme+ssh://[ssh_user@]ssh_host[:ssh_port]/[db_user[:db_pass]@]db_host[:db_port][/database][?params]
db_host is omitted, it defaults to 127.0.0.1.
Query Parameters
Connection Identity
| Parameter | Description | Example |
|---|
name | Override the connection name shown in the sidebar | ?name=Production+DB |
SSL / TLS
| Parameter | Values | Description |
|---|
sslmode | disable, prefer, require, verify-ca, verify-full | SSL mode (standard PostgreSQL names) |
tlsmode | 0—4 | SSL mode as integer: 0=disable, 1=prefer, 2=require, 3=verify-ca, 4=verify-full |
postgresql://user:pass@host/db?sslmode=require
postgresql://user:pass@host/db?tlsmode=2
Navigation
These parameters open a specific table, view, or schema immediately after connecting.
| Parameter | Description | Example |
|---|
table | Open the named table | ?table=users |
view | Open the named view | ?view=active_orders |
schema | Switch to this schema before opening (PostgreSQL/Redshift only) | ?schema=reporting |
postgresql://user:pass@host/mydb?schema=reporting&table=monthly_sales
Filtering
Apply a filter to the opened table automatically.
| Parameter | Description | Example |
|---|
column | Column name to filter on | ?column=status |
operation | Filter operator (e.g. =, !=, LIKE) | ?operation=LIKE |
value | Filter value | ?value=active |
condition | Raw SQL WHERE condition (overrides column/operation/value) | ?condition=status%3D'active'+AND+role%3D'admin' |
raw and query are accepted as aliases for condition.
Example:
postgresql://user:pass@host/mydb?table=orders&column=status&operation==&value=pending
postgresql://user:pass@host/mydb?table=orders&condition=total%3E1000
Appearance
| Parameter | Description | Example |
|---|
statusColor | Assign a color to the connection (hex, matched to nearest palette color) | ?statusColor=FF3B30 |
env | Assign an existing tag by name | ?env=production |
postgresql://user:pass@host/db?statusColor=FF3B30&env=production
MongoDB
| Parameter | Description |
|---|
authSource | Authentication database (defaults to admin) |
mongodb://user:pass@host:27017/mydb?authSource=admin
Redis
The path component sets the database index (0—15). The rediss:// scheme automatically enables TLS.
redis://:password@host:6379/2 # database index 2
rediss://:password@host:6380 # TLS, default index 0
Cassandra / ScyllaDB
The path component sets the default keyspace. Both cassandra:// and scylladb:// schemes use the same format.
cassandra://user:pass@host:9042/my_keyspace
scylladb://user:pass@host:9042/my_keyspace
cassandra://host:9042 # no auth, no default keyspace
SSH Tunnel
| Parameter | Description |
|---|
usePrivateKey | true to use key-based SSH authentication instead of password |
Opening URLs from Browser or Terminal
Launch and connect from browser/terminal:
open "postgresql://user:pass@localhost:5432/mydb"
open "mysql://root@localhost/shop?table=products"
open "postgresql+ssh://ubuntu@bastion/user:[email protected]/mydb?usePrivateKey=true"
