🗄️
DevOpsPython

Database Optimizer

by zebbern

Database Optimizer is a DevOps skill for Claude Code, published by zebbern in claude-code-guide.

4.6K stars459 forkson zebbern/claude-code-guideAdded 2026/08/16Repository updated 2026/08/15
aiai-agentai-agent-toolsanthropic-claudeclaudeclaude-aiclaude-apiclaude-codeclaude-code-communicationclaude-code-guideclaude-code-skillsclaude-commandsclaude-desktopclaude-mcpclaude-sonnetcodemcpmcp-agentsmcp-toolsvscode-extension
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/zebbern/claude-code-guide/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/zebbern/claude-code-guide.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 zebbern/claude-code-guide
Installs to
~/.claude/skills/database-optimizer
Collection
One of 25 skills cataloged from this repository
Category
DevOps798 skills

What Database Optimizer does

Database Optimizer analyzes slow queries, execution plans, and system metrics to find and fix database performance bottlenecks. Use it for index design, query rewrites, configuration tuning, and partitioning strategies.

Database Optimizer is cataloged under DevOps on DirSkills. Database Optimizer comes from a repository tagged ai, ai-agent, ai-agent-tools, anthropic-claude and claude.

Documentation

README

Database Optimizer

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

Role Definition

You are a senior database performance engineer with 10+ years of experience optimizing high-traffic databases. You specialize in PostgreSQL and MySQL optimization, execution plan analysis, strategic indexing, and achieving sub-100ms query performance at scale.

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 zebbern publish alongside Database Optimizer?

    Database Optimizer is one of 25 skills that DirSkills catalogs from zebbern/claude-code-guide, the repository it ships in. Its siblings there include API Fuzzing for Bug Bounty, API Shape Explorer and AWS Penetration Testing. Each one is a separate skill with its own page in this directory, installs the same way Database Optimizer does, and is maintained by zebbern in that same repository. The rest of the collection is listed on the zebbern/claude-code-guide page.

  • How does Database Optimizer compare to other DevOps skills?

    Database Optimizer ranks #173 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.

More from zebbern/claude-code-guide

Database Optimizer is one of 25 skills cataloged on DirSkills from zebbern/claude-code-guide.

See all 25 skills
🛡️
2w ago

API Fuzzing for Bug Bounty

API Fuzzing for Bug Bounty provides techniques for testing REST, SOAP, and GraphQL APIs during bug bounty hunting and penetration testing. Use it to discover vulnerabilities like IDOR, authentication bypass, SQL injection, SSRF, and GraphQL-specific issues.
Quality
4.6K459
🧩
2w ago

API Shape Explorer

API Shape Explorer generates multiple radically different interface designs for a module using parallel sub-agents, then compares them to help you choose the best API shape. Use it when designing APIs, exploring interface options, or comparing module shapes.
AI Engineering
4.6K459
🛡️
2w ago

AWS Penetration Testing

AWS Penetration Testing guides security assessment of Amazon Web Services environments, including IAM enumeration, privilege escalation, SSRF to metadata, S3 bucket exploitation, and Lambda attacks. Use it when asked to pentest AWS or test cloud infrastructure security.
Quality
4.6K459
🔍
2w ago

Academic Paper Reviewer

Academic Paper Reviewer simulates academic peer review across Originality, Methodology, Results, and Writing, providing Major and Minor Revision recommendations with actionable feedback. Use it when asked to review a paper or simulate peer review.
Quality
4.6K459
⚔️
2w ago

Active Directory Attacks

Active Directory Attacks provides techniques for attacking Microsoft Active Directory environments, covering reconnaissance, credential harvesting, Kerberos attacks, lateral movement, and privilege escalation for red team operations and penetration testing.
DevOps
4.6K459
🔍
2w ago

Audit Flow

Audit Flow traces system flows interactively across code, API, auth, data, and network layers with SQLite persistence and Mermaid export. Use it for security audits, compliance documentation, flow tracing, debugging, architecture reviews, or incident post-mortems.
Quality
4.6K459