DB Ops Sop
OpenDCAI/DataMind
Database operations runbook — backup, recovery, performance tuning, troubleshooting.
A skill your agent uses when investigating slow queries, analyzing execution plans, or optimizing database performance.
Install Database Optimizer
$ npx skills add zebbern/claude-code-guide --skill database-optimizer -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install zebbern/claude-code-guide database-optimizer --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/zebbern/claude-code-guide.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/database-optimizer .claude/skills/database-optimizer && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "database-optimizer" agent skill from https://github.com/zebbern/claude-code-guide/tree/main/skills/database-optimizer into .claude/skills/database-optimizer/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimizer", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/zebbern/claude-code-guide/tree/main/skills/database-optimizerType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add zebbern/claude-code-guide --skill database-optimizer -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install zebbern/claude-code-guide database-optimizer --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/zebbern/claude-code-guide.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/database-optimizer .agents/skills/database-optimizer && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "database-optimizer" agent skill from https://github.com/zebbern/claude-code-guide/tree/main/skills/database-optimizer into .agents/skills/database-optimizer/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimizer", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add zebbern/claude-code-guide --skill database-optimizer -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install zebbern/claude-code-guide database-optimizer --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/zebbern/claude-code-guide.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/database-optimizer .cursor/skills/database-optimizer && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "database-optimizer" agent skill from https://github.com/zebbern/claude-code-guide/tree/main/skills/database-optimizer into .cursor/skills/database-optimizer/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimizer", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/zebbern/claude-code-guide.git --path skills/database-optimizer--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add zebbern/claude-code-guide --skill database-optimizer -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install zebbern/claude-code-guide database-optimizer --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/zebbern/claude-code-guide.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/database-optimizer .gemini/skills/database-optimizer && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "database-optimizer" agent skill from https://github.com/zebbern/claude-code-guide/tree/main/skills/database-optimizer into .gemini/skills/database-optimizer/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimizer", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install zebbern/claude-code-guide database-optimizerInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add zebbern/claude-code-guide --skill database-optimizer -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/zebbern/claude-code-guide.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/database-optimizer .github/skills/database-optimizer && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "database-optimizer" agent skill from https://github.com/zebbern/claude-code-guide/tree/main/skills/database-optimizer into .github/skills/database-optimizer/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimizer", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add zebbern/claude-code-guide --skill database-optimizer -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install zebbern/claude-code-guide database-optimizer --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/zebbern/claude-code-guide.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/database-optimizer .opencode/skills/database-optimizer && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "database-optimizer" agent skill from https://github.com/zebbern/claude-code-guide/tree/main/skills/database-optimizer into .opencode/skills/database-optimizer/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-optimizer", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
database-optimizer- GitHub stars
- 4.7k
- Token cost
- ~967 tokens
- SKILL.md length
- 321 words
- Files
- 6 (incl. references)
- Skills in repo
- 46
- Repo updated
- First seen
- Licence
- MIT
At a glance
A skill your agent uses when investigating slow queries, analyzing execution plans, or optimizing database performance.
- Works in 5 steps: Analyze Performance - Review slow… → Identify Bottlenecks - Find inefficient… → Design Solutions - Create index… → …
- Investigating slow queries
- SKILL.md covers Role Definition, When to Use This Skill, Core Workflow and Reference Guide, plus 3 more sections
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Database Optimizer is an agent skill from zebbern/claude-code-guide. 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.
Its SKILL.md is about 970 tokens, which your agent loads only when the skill is triggered. The skill folder holds 6 other files, including reference files (for example `references/index-strategies.md`, `references/monitoring-analysis.md` and `references/mysql-tuning.md`).
It sits in Databases, covering Query optimization. It works with MySQL and PostgreSQL. The repository describes itself as: Claude Code Guide - Setup, Commands, workflows, agents, skills & tips-n-tricks from beginner to power user! The licence is MIT.
When your agent uses it
- Investigating slow queries
- Analyzing execution plans
- Optimizing database performance
Example prompts
- “/database-optimizer”
Workflow steps
5 steps, taken from the first numbered list in SKILL.md.
- Analyze Performance - Review slow queries, execution plans, system metrics
- Identify Bottlenecks - Find inefficient queries, missing indexes, config issues
- Design Solutions - Create index strategies, query rewrites, schema improvements
- Implement Changes - Apply optimizations incrementally with monitoring
- Validate Results - Measure improvements, ensure stability, document changes
What it can do on your machine
Read from SKILL.md and the folder at commit e62775c. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Database Optimizer loads about 967 tokens when it runs, and up to ~14k if it reads all its reference files. Until then it costs about 59 tokens; SKILL.md has 321 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from zebbern/claude-code-guide at commit e62775c, republished under its MIT licence (© zebbern). 321 words, ~967 tokens.
Download SKILL.mdSave it as
.claude/skills/database-optimizer/SKILL.md (or your agent's skills folder). This skill also uses 5 other files; get the full folder from GitHub.- name
- database-optimizer
- description
- 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.
- license
- MIT
- metadata.author
- https://github.com/Jeffallan
- metadata.version
- 1.0.0
- metadata.domain
- infrastructure
- metadata.triggers
- database optimization, slow query, query performance, database tuning, index optimization, execution plan, EXPLAIN ANALYZE, database performance, PostgreSQL…
- metadata.role
- specialist
- metadata.scope
- optimization
- metadata.output-format
- analysis-and-code
- metadata.related-skills
- devops-engineer
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
- Analyze Performance - Review slow queries, execution plans, system metrics
- Identify Bottlenecks - Find inefficient queries, missing indexes, config issues
- Design Solutions - Create index strategies, query rewrites, schema improvements
- Implement Changes - Apply optimizations incrementally with monitoring
- Validate Results - Measure improvements, ensure stability, document changes
Reference Guide
Load detailed guidance based on context:
| Topic | Reference | Load When |
|---|---|---|
| Query Optimization | references/query-optimization.md | Analyzing slow queries, execution plans |
| Index Strategies | references/index-strategies.md | Designing indexes, covering indexes |
| PostgreSQL Tuning | references/postgresql-tuning.md | PostgreSQL-specific optimizations |
| MySQL Tuning | references/mysql-tuning.md | MySQL-specific optimizations |
| Monitoring & Analysis | references/monitoring-analysis.md | Performance metrics, diagnostics |
Constraints
MUST DO
- Analyze EXPLAIN plans before optimizing
- Measure performance before and after changes
- Create indexes strategically (avoid over-indexing)
- Test changes in non-production first
- Document all optimization decisions
- Monitor impact on write performance
- Consider replication lag for distributed systems
MUST NOT DO
- Apply optimizations without measurement
- Create redundant or unused indexes
- Skip execution plan analysis
- Ignore write performance impact
- Make multiple changes simultaneously
- Optimize without understanding query patterns
- Neglect statistics updates (ANALYZE/VACUUM)
Output Templates
When optimizing database performance, provide:
- Performance analysis with baseline metrics
- Identified bottlenecks and root causes
- Optimization strategy with specific changes
- Implementation SQL/config changes
- Validation queries to measure improvement
- Monitoring recommendations
Knowledge Reference
PostgreSQL (pg_stat_statements, EXPLAIN ANALYZE, indexes, VACUUM, partitioning), MySQL (slow query log, EXPLAIN, InnoDB, query cache), query optimization, index design, execution plans, configuration tuning, replication, sharding, caching strategies
© zebbern, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 5 other files (references) in skills/database-optimizer of zebbern/claude-code-guide.
- SKILL.md
- references/index-strategies.md
- references/monitoring-analysis.md
- references/mysql-tuning.md
- references/postgresql-tuning.md
- references/query-optimization.md
Open the folder on GitHubat commit e62775c
Compare with similar skills
Database Optimizer next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Database Optimizer this skillzebbern/claude-code-guide | 4.7k | — | ~967 | Automated safety check: Pass | MIT | |
| DB Ops SopOpenDCAI/DataMind | 423 | — | ~388 | Automated safety check: Pass | Apache-2.0 | |
| Altimate Data Warehouse DelegateAltimateAI/data-engineering-skills | 128 | — | ~1.4k | Automated safety check: Pass | MIT | |
| Database OptimizerJeffallan/claude-skills | 12k | — | ~1.6k | Automated safety check: Pass | MIT | |
| SQL ProJeffallan/claude-skills | 12k | — | ~1.3k | Automated safety check: Pass | MIT | |
| Database OptimizerAratKruglik/claude-laravel | 155 | — | ~1k | Automated safety check: Pass | None |
Similar skills
Altimate Data Warehouse Delegate
AltimateAI/data-engineering-skills
Delegates dbt and warehouse tasks such as lineage, migrations and cost attribution to the altimate-code CLI agent and relays its answer back.
Database Optimizer
Jeffallan/claude-skills
Tunes PostgreSQL and MySQL performance by analyzing slow queries and execution plans, designing indexes, rewriting queries and adjusting configuration, one validated change at a time.
SQL Pro
Jeffallan/claude-skills
Optimizes SQL queries and designs schemas using CTEs, window functions, covering indexes and EXPLAIN ANALYZE, with notes on dialect differences between major databases.
Database Optimizer
AratKruglik/claude-laravel
A skill your agent uses when investigating slow queries, analyzing execution plans, or optimizing database performance.
- Official
SQL Optimization
github/awesome-copilot
Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server…
More from zebbern/claude-code-guide
All 46 skills in this repoCode To Diagram
zebbern/claude-code-guide
Analyze codebases and automatically generate architecture diagrams, flowcharts, and org charts.
Localization Toolkit
zebbern/claude-code-guide
This skill should be used when setting up, auditing, or enforcing internationalization/localization in UI codebases (React/TS, i18next or similar, JSON locales), including installing/configuring the…
Audit Flow
zebbern/claude-code-guide
Interactive system flow tracing across CODE, API, AUTH, DATA, NETWORK layers with SQLite persistence and Mermaid export.
Chart Image
zebbern/claude-code-guide
Generate publication-quality PNG chart images from data, supporting line, bar, area, candlestick, pie, and heatmap charts.
Code Vuln Audit
zebbern/claude-code-guide
Scan code for security issues: dependency vulnerabilities (npm/pip audit), secret leaks (regex and entropy analysis), and OWASP anti-patterns like SQL injection, XSS, or command injection.
Linux Shell Scripting
zebbern/claude-code-guide
This skill should be used when the user asks to "create bash scripts", "automate Linux tasks", "monitor system resources", "backup files", "manage users", or "write production shell scripts".
Related
Works with
Categories
Questions about Database Optimizer
What does Database Optimizer do?
A skill your agent uses when investigating slow queries, analyzing execution plans, or optimizing database performance. Database Optimizer is an agent skill from zebbern/claude-code-guide. Use when investigating slow queries, analyzing execution plans, or optimizing database performance.
When should I use Database Optimizer?
Database Optimizer fits situations like: investigating slow queries; analyzing execution plans; optimizing database performance.
How do I install Database Optimizer in Claude Code?
Run `npx skills add zebbern/claude-code-guide --skill database-optimizer -a claude-code`. Or copy the skill folder (skills/database-optimizer in zebbern/claude-code-guide) into .claude/skills/database-optimizer in your project. Claude Code loads it when a task matches its description.
How do I install Database Optimizer in Codex?
Run `npx skills add zebbern/claude-code-guide --skill database-optimizer -a codex`. Or copy the skill folder (skills/database-optimizer in zebbern/claude-code-guide) into .agents/skills/database-optimizer in your project. Codex loads it when a task matches its description.
Can I use Database Optimizer in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add zebbern/claude-code-guide --skill database-optimizer -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/database-optimizer, .gemini/skills/database-optimizer, .github/skills/database-optimizer and .opencode/skills/database-optimizer in your project.
What does Database Optimizer need to run?
SKILL.md names no scripts, command-line tools or credentials: Database Optimizer is instructions for the agent only.
Does Database Optimizer access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Database Optimizer safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Database Optimizer use?
Database Optimizer is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Database Optimizer use?
About 967 tokens (SKILL.md is roughly 3.9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 13k tokens, read only when the agent opens those files.
What are the alternatives to Database Optimizer?
Skills that share tags, products or a category with Database Optimizer: DB Ops Sop (OpenDCAI/DataMind, 423 stars), Altimate Data Warehouse Delegate (AltimateAI/data-engineering-skills, 128 stars), Database Optimizer (Jeffallan/claude-skills, 12k stars) and SQL Pro (Jeffallan/claude-skills, 12k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Database Optimizer?
zebbern (a GitHub user) maintains it in zebbern/claude-code-guide, which has 4,650 GitHub stars. The repository holds 46 skills in this directory. The repository was last updated on October 8, 2026.
Source: zebbern/claude-code-guide on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.