postgres-pro
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
- installs 8w
- 1,514
- 30-day movement
- starts with the next reading
- Related entries
- 2
- Connections
- 0
postgres-pro is a SKILL.md that turns an AI coding agent into a senior PostgreSQL expert, covering query optimization, replication setup, and advanced database features. It is structured with sections for when to use, a workflow, reference guidance, rules, pitfalls, and output templates, and its code is written in SQL.
Reach for it when you need the agent to follow a disciplined PostgreSQL workflow—EXPLAIN analysis, index design, replication, or VACUUM tuning—instead of ad-hoc SQL advice.
Use it to
- Analyze slow queries with EXPLAIN (ANALYZE, BUFFERS)
- Design B-tree, GIN, GiST, or BRIN indexes
- Set up streaming or logical replication
- Tune VACUUM and monitor bloat
- Work with JSONB storage and indexing
For Developers and DBAs optimizing PostgreSQL databases
- Host repository
- Jeffallan/claude-skills
- Version
- 1.1.0
- Installs, lifetime
- 7,200
- Installs, 8 weeks
- 1,514
- Licence
- MIT
- Host stars
- 12k
- Host language
- Python