database-optimizer
Analyzes slow queries, optimizes indexes, and provides performance tuning for PostgreSQL and MySQL databases.
Install
npx skills add https://github.com/jeffallan/claude-skills --skill database-optimizerStats
| Total installs | 1,288 |
| Weekly installs | 1.3K |
| GitHub stars | 7.4K |
| First seen | Jan 20, 2026 |
| Source | @jeffallan/claude-skills |
Summary
- Analyzes slow queries using EXPLAIN ANALYZE, identifies missing indexes, and designs covering index strategies
- Provides database-specific tuning guidance for PostgreSQL and MySQL configuration, schema design, and partitioning
- Includes reference materials for query optimization, index strategies, monitoring, and lock contention resolution
- Delivers before/after performance metrics, implementation SQL, and validation queries to measure improvement
Tags
Related skills
| Skill | Installs | vs database-optimizer |
|---|---|---|
| jpa-patterns | 1,604 | +316 |
| android-kotlin | 1,122 | -166 |
| fastapi-expert | 1,625 | +337 |
| dotnet-core-expert | 1,194 | -94 |
| tanstack-start | 1,041 | -247 |
FAQ
- How many installs does database-optimizer have?
- database-optimizer has 1,288 total installs and 1.3K installs this week.
- Where is database-optimizer hosted?
- database-optimizer is published by @jeffallan/claude-skills at https://github.com/jeffallan/claude-skills.
- How many GitHub stars does database-optimizer have?
- database-optimizer has 7.4K GitHub stars.
- When was database-optimizer first indexed?
- OrangeBot.AI first indexed database-optimizer on Jan 20, 2026.
- How do I install database-optimizer?
- Run: npx skills add https://github.com/jeffallan/claude-skills --skill database-optimizer