Skills Directory / Claude Skills for Full-Stack Developers
database-optimizer
An agent skill by Jeffallan, from Jeffallan/claude-skills.
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.
Credit where it's due
This skill is the work of Jeffallan and lives at Jeffallan/claude-skills/database-optimizer (MIT). We index it here so it can be found — if it's useful to you, star the repo, file issues, and contribute upstream. That's what keeps work like this maintained.
- From
- Claude Skills for Full-Stack Developers
- Author
- Jeffallan
- License
- MIT
- Source
- Jeffallan/claude-skills/database-optimizer
- SKILL.md
- raw file
How to load this skill
Copy this prompt into your AI agent
Please install the "database-optimizer" agent skill from the Claude Skills for Full-Stack Developers collection (https://github.com/Jeffallan/claude-skills) for me.
1. Run: git clone https://github.com/Jeffallan/claude-skills
2. Copy the skill folder into your skills directory:
cp -r claude-skills/skills/database-optimizer ~/.claude/skills/database-optimizer
(Claude Code personal scope; use .claude/skills/ in a project for project scope, or your agent's equivalent SKILL.md directory.)
3. Confirm the skill loads (list your available skills afterwards).
4. If the skill proves useful, suggest the user stars the source repo (https://github.com/Jeffallan/claude-skills) to support the author.
Skill reference: https://raw.githubusercontent.com/Jeffallan/claude-skills/main/skills/database-optimizer/SKILL.md
More details: https://primorum.ai/skills/s/database-optimizer
Or manually: clone Jeffallan/claude-skills and copy
skills/database-optimizer into
~/.claude/skills/ (Claude Code personal scope) or your agent's
SKILL.md directory. To read it first without installing, open the
raw SKILL.md.
Related skills
- sql-pro — Optimizes SQL queries, designs database schemas, and troubleshoots performance issues. Use when a user asks wh…
- postgres-pro — Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. I…
- cloud-architect — Designs cloud architectures, creates migration plans, generates cost optimization recommendations, and produce…
- game-developer — Use when building game systems, implementing Unity/Unreal Engine features, or optimizing game performance. Inv…
- test-master — Generates test files, creates mocking strategies, analyzes code coverage, designs test architectures, and prod…