PostgreSQL

Use a postgres or postgresql URL with a username, password, one host, and database name:

postgres://app_reader:[email protected]:5432/warehouse?sslmode=verify-full

Supported sslmode values are disable, allow, prefer, require, verify-ca, and verify-full. The default port is 5432; the default SSL mode is prefer.

DataPorch opens PostgreSQL queries in a read-only transaction. Discovery exposes readable schemas, tables, views, columns, comments, and relevant constraints. Use a database role with only the permissions the agent should have; read-only transaction mode does not replace database authorization.

For local development, prefer a dedicated reader role and a local or private network endpoint. Do not put this URL in an agent prompt or commit it to a client config.