Optimize Postgres

Use this skill to tune PostgreSQL performance, configure serverless connection pooling, implement ephemeral database branching, analyze query execution plans, and enforce zero-downtime migration safeguards.

When to Use

• configuring serverless connection poolers (Supavisor, PgBouncer) in transaction or session modes
• resolving prepared statement conflicts and sizing connection pools using mathematical limits
• orchestrating ephemeral copy-on-write database branches (Neon) for PRs and isolated CI test runs
• diagnosing slow queries via EXPLAIN (ANALYZE, BUFFERS) to eliminate sequential scans and disk spills
• designing composite, partial, expression, and covering indexes for high-throughput queries
• executing zero-downtime schema evolution with lock timeouts and concurrent DDL safeguards

Core Rules