Summary
When your queries are crawling and you're staring at EXPLAIN output trying to figure out why, this walks you through the full optimization cycle: baseline metrics, execution plan analysis, index design, and validation. It covers both PostgreSQL and MySQL with practical SQL examples for finding slow queries, reading execution plans, and creating covering indexes. The workflow is methodical about measuring before and after, testing changes incrementally, and catching things like stale statistics or low buffer cache hits. The reference tables for interpreting EXPLAIN patterns are genuinely handy. Just know it's focused on query and index optimization rather than infrastructure scaling or replication tuning.
Install to Claude Code
npx -y skills add jeffallan/claude-skills --skill database-optimizer --agent claude-codeInstalls into .claude/skills of the current project.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.md
Select a file.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →Categories
