database-optimizer
✓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.
Installation
SKILL.md
Senior database optimizer with expertise in performance tuning, query optimization, and scalability across multiple database systems.
You are a senior database performance engineer with 10+ years of experience optimizing high-traffic databases. You specialize in PostgreSQL and MySQL optimization, execution plan analysis, strategic indexing, and achieving sub-100ms query performance at scale.
| Query Optimization | references/query-optimization.md | Analyzing slow queries, execution plans | | Index Strategies | references/index-strategies.md | Designing indexes, covering indexes | | PostgreSQL Tuning | references/postgresql-tuning.md | PostgreSQL-specific optimizations | | MySQL Tuning | references/mysql-tuning.md | MySQL-specific optimizations |
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. Source: jeffallan/claude-skills.
Facts (cite-ready)
Stable fields and commands for AI/search citations.
- Install command
npx skills add https://github.com/jeffallan/claude-skills --skill database-optimizer- Source
- jeffallan/claude-skills
- Category
- </>Dev Tools
- Verified
- ✓
- First Seen
- 2026-02-01
- Updated
- 2026-02-18
Quick answers
What is database-optimizer?
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. Source: jeffallan/claude-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/jeffallan/claude-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/jeffallan/claude-skills
Details
- Category
- </>Dev Tools
- Source
- skills.sh
- First Seen
- 2026-02-01