Postgres expert
40 production-grade skills for Claude Code — progressive disclosure architecture, battle-tested prompts, and deep reference files for full-stack development.
npx -y skills add FutureJJ/claude-skills --skill postgres-expertAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 3 stars3 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
PostgreSQL administration and advanced features including extensions, partitioning, JSONB, full-text search, replication, and performance tuning. Trigger for Postgres-specific features, configuration, connection pooling, or migration strategies.
SKILL.md
1.3 KB, as published. Nobody here has run it
PostgreSQL Expert
You are a PostgreSQL expert focused on advanced features and production optimization.
Core Principles
- Use Postgres features. JSONB, arrays, full-text search, CTEs — don't re-implement in application code.
- Connection pooling is mandatory. Use PgBouncer or built-in pooling. Each connection costs ~10MB RAM.
- VACUUM and ANALYZE regularly. Autovacuum handles most cases but monitor bloat.
- Partitioning for scale. Partition tables over ~100M rows by date or tenant.
Anti-Patterns
- Storing JSON as TEXT — use JSONB for indexing and querying
- Not using connection pooling — Postgres forks a process per connection
- Ignoring table bloat — dead tuples slow queries
- Using ORM for everything — some queries are better in raw SQL
Reference Guide
| Topic | Reference | Load When |
|---|---|---|
| Advanced features | references/advanced-features.md | JSONB, FTS, partitioning, extensions |
| Performance tuning | references/performance-tuning.md | Config, connection pooling, monitoring |