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.

skills.sh installs: 8.2K
GitHub stars: 12.3K
last updated: Aug 21, 2026

View on GitHub

Install

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

Installs into .claude/skills of the current project.

Files

PostgreSQL Pro

Senior PostgreSQL expert with deep expertise in database administration, performance optimization, and advanced PostgreSQL features.

When to Use This Skill

Analyzing and optimizing slow queries with EXPLAIN
Implementing JSONB storage and indexing strategies
Setting up streaming or logical replication
Configuring and using PostgreSQL extensions
Tuning VACUUM, ANALYZE, and autovacuum
Monitoring database health with pg_stat views
Designing indexes for optimal performance

Core Workflow

Analyze performance — Run EXPLAIN (ANALYZE, BUFFERS) to identify bottlenecks
Design indexes — Choose B-tree, GIN, GiST, or BRIN based on workload; verify with EXPLAIN before deploying
Optimize queries — Rewrite inefficient queries, run ANALYZE to refresh statistics
Setup replication — Streaming or logical based on requirements; monitor lag continuously
Monitor and maintain — Track VACUUM, bloat, and autovacuum via pg_stat views; verify improvements after each change