Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Database Optimizer · zebbern | DecimalAI

databy zebbern

Database Optimizer

zebbern/database-optimizer

Source zebbern/claude-code-guide ↗License MIT

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.

SkillScore91Maintained

Automatic

Data Engineer pack

Last verified 8/10/2026

What it changes

Passed 19 of 21 test cases with the skill, and 18 of 21 without it.

Without skill86%

With skill91%

Checks it passed that the model alone missed

Recommends testing database changes in a non-production environment prior to production execution.

1 fixed19 passed either way2 still failing0 broke

Pass-rate lift: +5 pp
Tokens: +35%
Agent turns: 0%
Response time: -2%

Model gemini-3.6-flashMeasured 8/10/2026v120 of 22 cases passed with skill · 21 comparable

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/zebbern-database-optimizer/SKILL.md https://app.decimal.ai/s/zebbern-database-optimizer/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add zebbern-database-optimizer, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/zebbern-database-optimizer/ and pins it in .decimal/skills.lock

decimalai skills add zebbern-database-optimizer

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/zebbern-database-optimizer/SKILL.md https://app.decimal.ai/s/zebbern-database-optimizer/SKILL.md

Raw file: /s/zebbern-database-optimizer/SKILL.md ↗ · machine-readable summary at /s/zebbern-database-optimizer.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

A test case the skill fixed. Same model, same prompt, with and without the skill.

Prompt

We have 5 index changes and 3 PostgreSQL parameter tweaks ready. We want to execute all of them immediately on our production database during Monday morning peak hours to resolve latency. Should we execute this migration script directly on production now?

What was checked, without and with the skill
Checked	Without skill	With skill
Recommends testing database changes in a non-production environment prior to production execution.	Missed	Passed

case-06 · gemini-3.6-flash · 8/10/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md73 lines6 files

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

Track record

Benchmark

19 / 21

test cases passed, vs 18 / 21 without

Adoption

Users: 1
Times used: 15

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

zebbern / claude-code-guide

skills/database-optimizer/SKILL.md

View on GitHub ↗

License MITImported 8/3/2026Version v1Bundled 5 files

Other skills for the same job

Published skills whose descriptions closely match this one, with their headline benchmark lift.

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

Database Optimizer

Role Definition

When to Use This Skill

Core Workflow

Reference Guide

Constraints

MUST DO

Track record

Benchmark

Adoption

SkillSafety

Source

Other skills for the same job

Related skills