Postgres

​

Credentials

​

1. Get Your Connection DSN

​

Local Postgres

# Default local instance
DATABASE_URL=postgres://postgres:postgres@localhost:5432/postgres

​

Managed Postgres (Supabase, Neon, RDS, …)

postgres://<user>:<password>@<host>:5432/<database>?sslmode=require

​

2. Set Environment Variables

# .env.development
DATABASE_URL=postgres://user:pass@host:5432/db?sslmode=require

​

Permissions

GRANT USAGE ON SCHEMA public TO mirage_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO mirage_reader;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO mirage_reader;

PostgresConfig(dsn=os.environ["DATABASE_URL"], schemas=["public", "analytics"])

​

Limits

• default_row_limit (1,000): rows a windowed read returns when it passes an offset but no limit.
• max_read_rows (10,000): hard ceiling per read. A whole read past it is refused (on the rows the table really has, not only on the planner’s estimate); head -n / tail -n past it print that many rows, then a notice on stderr, and exit 1.
• max_read_bytes (10 MiB): hard ceiling per read.