Ready to supercharge your AI agents?

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

Database Optimizer — measured AI agent skill | DecimalAI

zebbern/database-optimizer

NewSkillScoreMaintained

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.

by zebbern

Links this skill to your agents and keeps it current with the author’s updates.

Automatic

Data Engineer pack

decimalai skills pull zebbern-database-optimizer

Get this skill — curl · raw file

curl -fsSL 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 ↗

In productionGlobal

how this skill behaves on real traffic · last 30 days

No production data for this skill yet — usage numbers appear here once agents start running it.

Anonymized aggregate across every org using this skill — proof from real production use, not a demo.

Does this skill help? · Benchmark: with vs. withoutsign in to run this on your agents

22 test cases from the publisher’s eval.yaml · each run twice on gemini-3.6-flash — with the skill injected, then without · last run 5h ago

—+35% tokens0% turns91% of whole cases pass with skill (20/22)

Test case	Without → With	Effect	Δ tokens	Δ turns
case-06	✗→✓	▲ Improved	62%	0%
case-02	✓→✓	＝ Same ✓	32%	0%
case-03	✓→✓	＝ Same ✓	14%	0%
case-04	✓→✓	＝ Same ✓	56%	0%
case-07	✓→✓	＝ Same ✓	29%	0%

Showing 5 of 22 cases

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

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

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

Skill contents

references/

SKILL.md

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

Want to see if zebbern/database-optimizer would activate on your phrasing? Try it before you install — no LLM call, no signup.

Other measured skills in the registry, with their headline benchmark lift.