Postgres Pro

This is what you reach for when you're knee-deep in PostgreSQL performance issues or setting up replication. It walks you through the full cycle: EXPLAIN ANALYZE to find bottlenecks, creating the right indexes (B-tree, GIN, GiST, BRIN), verifying the planner actually uses them, then monitoring with pg_stat views. The coverage is solid on JSONB operations, VACUUM tuning for high-churn tables, and both streaming and logical replication setup. What I appreciate is the emphasis on verification at every step, especially the "must use EXPLAIN before and after" rule and CREATE INDEX CONCURRENTLY to avoid production locks. The reference guides break out by topic (performance, JSONB, extensions, maintenance) so you're not wading through everything at once.

Install to Claude Code

npx -y skills add jeffallan/claude-skills --skill postgres-pro --agent claude-code