PostgreSQL
Where to provision PostgreSQL credentials for your agent and how to connect them to Nora.PostgreSQL integrations let your agents query and write to a Postgres database. Nora stores the connection parameters encrypted; the agent runtime opens connections using the standard
PG* env vars (PGHOST, PGPORT, PGDATABASE, PGUSER, PGPASSWORD) — every Postgres driver picks them up automatically.
Where to apply for credentials
There’s no single console for Postgres — pick whichever provider hosts your database:Best practices
- Create a dedicated role for the agent (
CREATE ROLE nora_agent LOGIN PASSWORD '...') — don’t reusepostgressuperuser. - Grant only what’s needed —
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO nora_agent;for a typical CRUD agent; justGRANT SELECTfor read-only. - The DB host must be reachable from the agent’s network. Nora doesn’t tunnel — for managed Postgres behind a VPC, your agent runtime needs network access to the same VPC.
Connect in Nora
1
Open the PostgreSQL integration
From an agent’s detail page, open the Integrations tab and find PostgreSQL.
2
Fill in the connection fields
Host, port (5432 default), database name, username, password.
3
Connect
Click Connect. Nora validates the field shapes (port range, presence) and stores credentials encrypted. It does not open a connection from the control plane — the agent runtime does.
Verify the connection
The Test button repeats the structural check. End-to-end verification happens when your agent makes its first query.MCP server
The reference Postgres MCP server is published by the MCP project:- Package:
@modelcontextprotocol/server-postgres - Docs: github.com/modelcontextprotocol/servers/tree/main/src/postgres
- Env:
POSTGRES_URL(the MCP server reads a single connection string).
POSTGRES_URL in your agent’s runtime config (you can derive it from the PG* env vars Nora injects).