PostgreSQL
Connect a PostgreSQL database with the PostgreSQL database type. Managed PostgreSQL connects the same way: Amazon RDS and Aurora, Google Cloud SQL, Azure Database for PostgreSQL, Supabase and Neon.
Connect a database
Add the database as in Connect a database, with these values:
| Field | Value |
|---|---|
| Database type | PostgreSQL |
| Port | 5432, PostgreSQL's default, or the port your service shows. |
| Database name | The database to query, for example postgres. |
For the credential, create a read-only user. To keep QueryDesk's queries off your primary, connect a read replica.
Connection strings
Paste a postgres:// or postgresql:// connection string under Update with connection string on the database's settings page and click Apply. sslmode=require (or verify-ca, verify-full) turns on Encryption. Other query keys become connection parameters.
Connection parameters
Connection parameters are startup parameters QueryDesk sends whenever it opens a connection, for Test Connection and queries alike. Add them under Connection parameters, for example options with -c search_path=app, or a pooler's routing key. Only a super admin can change them.
AI read-only
With Read only set, an AI query runs in a read-only transaction that is always rolled back, so PostgreSQL refuses a write the parser didn't catch, including one inside a function. See AI governance.