postgres-pro
Expert PostgreSQL guidance for query optimization, index design, JSONB strategies, and database performance tuning.
Install
npx skills add https://github.com/jeffallan/claude-skills --skill postgres-proStats
| Total installs | 1,525 |
| Weekly installs | 1.5K |
| GitHub stars | 7.4K |
| First seen | Jan 20, 2026 |
| Source | @jeffallan/claude-skills |
Summary
- Covers query analysis with EXPLAIN, index design across B-tree/GIN/GiST/BRIN types, and JSONB storage strategies with containment queries
- Includes streaming and logical replication setup with lag monitoring via pg_stat_replication
- Provides VACUUM tuning, autovacuum configuration, bloat detection, and statistics refresh workflows
- Supports PostgreSQL extensions including PostGIS, pgvector, pg_trgm, and pg_stat_statements for monitoring and analysis
Tags
Related skills
| Skill | Installs | vs postgres-pro |
|---|---|---|
| senior-backend | 1,422 | -103 |
| prisma-upgrade-v7 | 1,230 | -295 |
| memory-management | 1,543 | +18 |
| mysql | 1,680 | +155 |
| nestjs-expert | 1,305 | -220 |
FAQ
- How many installs does postgres-pro have?
- postgres-pro has 1,525 total installs and 1.5K installs this week.
- Where is postgres-pro hosted?
- postgres-pro is published by @jeffallan/claude-skills at https://github.com/jeffallan/claude-skills.
- How many GitHub stars does postgres-pro have?
- postgres-pro has 7.4K GitHub stars.
- When was postgres-pro first indexed?
- OrangeBot.AI first indexed postgres-pro on Jan 20, 2026.
- How do I install postgres-pro?
- Run: npx skills add https://github.com/jeffallan/claude-skills --skill postgres-pro