database-optimizer
An agent skill by Jeffallan, from Jeffallan/claude-skills. Tags: analytics, api, database, debugging, performance, strategy.
What it does
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.
Install
With the skills CLI, which installs into Claude Code, Codex, Cursor and other agents:
npx skills add Jeffallan/claude-skills --skill database-optimizerOr copy the skill folder into Claude Code's skills directory by hand (~/.claude/skills for every project, or .claude/skills inside one):
git clone --depth 1 https://github.com/Jeffallan/claude-skills
cp -r claude-skills/skills/database-optimizer ~/.claude/skills/database-optimizerSafety box score
Not rated yet. A safety box score grades what a skill and its scripts can reach on the machine of whoever installs it, across eight categories from shell execution to secrets access. Anyone can request one from this page; it is saved for everyone. How the score works.
Source
- Repository
- Jeffallan/claude-skills (all skills from this repository)
- Path
- skills/database-optimizer/SKILL.md
- Branch
- main
- Updated
- 2026-09-19
Related skills
- postgres-pro — Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features.
- sql-pro — Optimizes SQL queries, designs database schemas, and troubleshoots performance issues.
- redshift-guide — Amazon Redshift is NOT PostgreSQL — corrects PostgreSQL-derived LLM mistakes; covers Redshift-specific SQL, DDL, COPY/UNLOAD, system views, metadata discovery.
- django-expert — Use when building Django web applications or REST APIs with Django REST Framework. py, or any Django project file.
- java-architect — x, microservices, or reactive programming.
- microservices-architect — Designs distributed system architectures, decomposes monoliths into bounded-context services, recommends communication patterns.