Overview
database-optimizer is an open-source backend skill for Claude Code and compatible agents, published by Jeffallan. Its author describes it as: “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, que…”. The project has 11k stars on GitHub and is available under the MIT license. Add it to your setup with `/plugin marketplace add Jeffallan/claude-skills`.
What database-optimizer does
Senior database optimizer with expertise in performance tuning, query optimization, and scalability across multiple database systems.
Best for
What’s inside
The SKILL.md for database-optimizer is organised into these sections:
- When to Use This Skill
- Core Workflow
- Reference Guide
- Common Operations & Examples
- Identify Top Slow Queries (PostgreSQL)
- Capture an Execution Plan
- Reading EXPLAIN Output — Key Patterns to Find
- Create a Covering Index
- Validate Improvement
- MySQL: Find Slow Queries
- Constraints
- MUST DO
Installation
Add database-optimizer to your agent with:
/plugin marketplace add Jeffallan/claude-skillsReview a skill’s source before installing it — skills can instruct your agent to run commands. This command comes from the skill’s public repository, which is the source of truth for setup steps. New to skills? Read how to install Claude Code skills.
Supported agents
- Claude Code — ships a claude code plugin marketplace
License
database-optimizer is published under the MIT license.
Strengths
- Clear MIT license — safe to read and adapt within its terms
- Ships in Jeffallan/claude-skills, an established project with 11,060 GitHub stars
- Works with Claude Code
- Actively maintained — repository updated in the last 90 days
Author
Topics
Frequently asked questions
- What does database-optimizer do?
- 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.
- How do I install database-optimizer?
- Run /plugin marketplace add Jeffallan/claude-skills in your agent, then reload your skills. Review the source at https://github.com/Jeffallan/claude-skills before installing.
- Is database-optimizer free to use?
- Yes. database-optimizer is free and open source under the MIT license, so you can read, run, and adapt it within that license's terms.
- Which agents does database-optimizer work with?
- database-optimizer lists Claude Code — named in its SKILL.md, its plugin marketplace or its repository topics. Skills use the portable SKILL.md format, so other agents that read that format may load it too.
- Where does database-optimizer come from?
- database-optimizer ships inside Jeffallan/claude-skills, a repository that contains 41 catalogued skills in total. The repository's 11,060 GitHub stars apply to that whole collection, not to this skill on its own.