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, the database options, and query filtering.
All engines share the same shape - here is a full PostgreSQL example, then the per-engine differences.
{
"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": 2000000000
}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.
A MongoDB checkout also needs bridge_auth_password, and the user connects
with it rather than with any placeholder:
mongosh "mongodb://alice%25db.internal:<bridge_auth_password>@bridge.example.com:27017/appdb"MongoDB’s SCRAM exchange is mutual, so Bridge has to prove itself to the client before it can prove the checkout’s credential to the database. See Databases.