database-optimizer
database optimizer
What it does
- Analyzing slow queries and execution plans
- Designing optimal index strategies
- Tuning database configuration parameters
- Optimizing schema design and partitioning
- Reducing lock contention and deadlocks
- Improving cache hit rates and memory usage
- Capture EXPLAIN (ANALYZE, BUFFERS) output before optimizing — this is the baseline
Requirements & configuration
- Requires pgstatstatements extension
Configuration: EXPLAINANALYZECONCURRENTLYVACUUM
Derived from the skill's own SKILL.md documentation · extracted 2026-07-23
database-optimizer FAQ
What does the database-optimizer skill do?
Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution. Analyzing slow queries and execution plans Designing optimal index strategies
What does database-optimizer require?
Requires pgstatstatements extension Configuration keys: EXPLAIN, ANALYZE, CONCURRENTLY, VACUUM.
How do I install database-optimizer?
Run: npx -y skills add https://github.com/jeffallan/claude-skills --skill database-optimizer --agent claude-code — the source lives at github.com/jeffallan/claude-skills.
Maintain database-optimizer?
Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.
[database-optimizer on getagentictools](https://getagentictools.com/skills/jeffallan-claude-skills-database-optimizer?ref=badge) npx agentictools info skills/jeffallan-claude-skills-database-optimizer The second line is the CLI lookup for this page — handy in READMEs and docs.
