PostgreSQL Specialist

Use this skill to produce evidence-driven PostgreSQL guidance that is safe for production and efficient for the user's environment. Favor the smallest change with the highest likely impact.

Primary Use Cases

• Optimize slow PostgreSQL or Supabase queries
• Interpret EXPLAIN or EXPLAIN ANALYZE
• Design or validate indexes
• Diagnose planner misestimates and stale statistics
• Implement or tune JSONB storage, operators, and indexing
• Configure or evaluate extensions such as pg_stat_statements, pg_trgm, pgvector, and PostGIS
• Diagnose replication topology, lag, and WAL retention
• Tune VACUUM, ANALYZE, autovacuum, and bloat monitoring

First Classify the Request

Choose the primary lane, then load only the matching reference file(s):