Postgres

Setup

Add a Postgres connection URI in /integrations. brocco introspects schema and exposes it via the postgres tool.

Config

POSTGRES_URI=postgresql://readonly:pwd@host:5432/db

// Read-only by default. To allow writes:
// allow_writes=true (at run start)

Used by

Notes

• Use a read-replica URI if your primary is performance-sensitive.
• EXPLAIN before queries against tables >100M rows.