Database Optimizer

by Jeffallan

Database Optimizer is a DevOps skill for Claude Code, published by Jeffallan in claude-skills.

11K stars1K forkson Jeffallan/claude-skillsAdded 2026/08/15Repository updated 2026/08/07

View source on GitHub Download repo ZIP

ai-agentsclaudeclaude-codeclaude-marketplaceclaude-skills

Install in seconds

Install Database Optimizer

Copy Database Optimizer into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.

terminal

npx degit https://github.com/Jeffallan/claude-skills/tree/main/skills/database-optimizer ~/.claude/skills/database-optimizer

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/Jeffallan/claude-skills.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file: skills/database-optimizer/SKILL.md in Jeffallan/claude-skills
Installs to: ~/.claude/skills/database-optimizer
Collection: One of 25 skills cataloged from this repository
Category: DevOps — 798 skills

What Database Optimizer does

Database Optimizer analyzes slow queries, execution plans, and schema to improve PostgreSQL and MySQL performance. Use it when investigating slow queries, designing indexes, tuning configuration, or resolving lock contention.

Database Optimizer is cataloged under DevOps on DirSkills. Database Optimizer comes from a repository tagged ai-agents, claude, claude-code, claude-marketplace and claude-skills.

Documentation

README

Excerpt

Database Optimizer

Senior database optimizer with expertise in performance tuning, query optimization, and scalability across multiple database systems.

When to Use This Skill

Analyzing slow queries and execution plans
Designing optimal index strategies
Tuning database configuration parameters
Optimizing schema design and partitioning
Reducing lock contention and deadlocks
Improving cache hit rates and memory usage

Core Workflow

This is the opening of the README. Read the full README on GitHub.

Frequently asked about Database Optimizer

What else does Jeffallan publish alongside Database Optimizer?
Database Optimizer is one of 25 skills that DirSkills catalogs from Jeffallan/claude-skills, the repository it ships in. Its siblings there include .NET Core Expert, API Designer and Angular Architect. Each one is a separate skill with its own page in this directory, installs the same way Database Optimizer does, and is maintained by Jeffallan in that same repository. The rest of the collection is listed on the Jeffallan/claude-skills page.
How does Database Optimizer compare to other DevOps skills?
Database Optimizer ranks #101 by stars among the 798 DevOps skills in this catalog. The most-starred ones next to it are Backend Patterns, API Connector Builder and Migration. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of Database Optimizer against them. Open each page to compare what they document and how they install.