database-optimizer
✓Use when user needs database query optimization, performance tuning, index strategies, execution plan analysis, or scalability across PostgreSQL, MySQL, MongoDB, Redis, and other database systems.
Installation
SKILL.md
Provides expert database performance tuning and optimization across major database systems (PostgreSQL, MySQL, MongoDB, Redis) specializing in query optimization, index design, execution plan analysis, and system configuration. Achieves sub-second query performance and optimal resource utilization through systematic optimization approaches.
| Query >100ms | EXPLAIN ANALYZE | Execution plan review | | High CPU | pgstatstatements | Find top queries | | High I/O | Index review | Missing index detection | | Connection exhaustion | Pool tuning | PgBouncer/connection limits | | Replication lag | Write optimization | Batch operations |
| P50 latency | <50ms | <2s | | P95 latency | <100ms | <5s | | P99 latency | <200ms | <10s | | Cache hit ratio | >95% | >90% | | Index usage | >95% | >80% |
Facts (cite-ready)
Stable fields and commands for AI/search citations.
- Install command
npx skills add https://github.com/404kidwiz/claude-supercode-skills --skill database-optimizer- Category
- {}Data Analysis
- Verified
- ✓
- First Seen
- 2026-02-01
- Updated
- 2026-02-18
Quick answers
What is database-optimizer?
Use when user needs database query optimization, performance tuning, index strategies, execution plan analysis, or scalability across PostgreSQL, MySQL, MongoDB, Redis, and other database systems. Source: 404kidwiz/claude-supercode-skills.
How do I install database-optimizer?
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/404kidwiz/claude-supercode-skills --skill database-optimizer Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code or Cursor
Where is the source repository?
https://github.com/404kidwiz/claude-supercode-skills
Details
- Category
- {}Data Analysis
- Source
- skills.sh
- First Seen
- 2026-02-01