PostgreSQL

Official docs

Agent rules

1. Neon MCP first — when enabled, use MCP for schema checks and SQL; do not guess column names from memory.
2. Idempotent migrations — IF NOT EXISTS, backward-compatible adds before destructive changes.
3. Indexes — justify new indexes; note write amplification on hot tables.
4. Transactions — multi-step writes in explicit transactions; avoid long-held locks.
5. Secrets — DATABASE_URL via Doppler or env loader; never commit connection strings.

Pairs with