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:

FieldValue
Database typePostgreSQL
Port5432, PostgreSQL's default, or the port your service shows.
Database nameThe 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.

Was this page helpful?