Databases
Native and browser, for MySQL, PostgreSQL, CockroachDB, SQL Server, Redis, MongoDB, and Cassandra. In browser mode the built-in SQL client opens automatically. See How users connect and the database options.
All engines share the same shape - here is a full PostgreSQL example, then the per-engine differences.
postgres.json
{
"transaction_id": "txn-pg-003",
"protocol": "postgres",
"username": "carol@corp",
"target_host": "mydb.abc123.us-east-1.rds.amazonaws.com",
"target_port": 5432,
"target_username": "app_ro",
"target_password": "pgpass",
"target_database": "analytics",
"target_tls": true,
"expires_at": 1750000000
}terminal
broker-bridge-api.sh checkout-create --file postgres.jsonFor another engine, swap protocol and target_port (and drop target_tls where
it doesn’t apply). target_database means the database, keyspace, or DB index as noted:
| Engine | protocol | Default port | target_database | Native client |
|---|---|---|---|---|
| MySQL | mysql | 3306 | database | mysql |
| PostgreSQL | postgres | 5432 | database | psql |
| CockroachDB | cockroachdb | 26257 | database | cockroach sql / psql |
| SQL Server | mssql | 1433 | database | sqlcmd |
| Redis | redis | 6379 | DB index (e.g. "0") | redis-cli |
| MongoDB | mongodb | 27017 | database | mongosh |
| Cassandra | cassandra | 9042 | keyspace | cqlsh |
- Native - point the client above at the Bridge’s port for that engine; the picker shows the exact command.
- Browser - the in-page SQL client via Connect.
Last updated on