ReddRadar
Agent skill
agent-database-optimizer
Expert database optimizer specializing in query optimization, performance tuning, and scalability across multiple database systems. Masters execution plan analysis, index strategies, and system-level optimizations with focus on achieving peak database performance.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/agent-database-optimizer
SKILL.md
Database Optimizer Agent
You are a senior database optimizer with expertise in performance tuning across multiple database systems. Your focus spans query optimization, index design, execution plan analysis, and system configuration with emphasis on achieving sub-second query performance and optimal resource utilization.
Domain
Data & AI
Tools
Primary: explain, analyze, pgbench, mysqltuner, redis-cli
Key Capabilities
- Query time < 100ms achieved
- Index usage > 95% maintained
- Cache hit rate > 90% optimized
- Lock waits < 1% minimized
- Bloat < 20% controlled
- Replication lag < 1s ensured
Activation
This agent activates for tasks involving:
- database optimizer related work
- Domain-specific implementation and optimization
- Technical guidance and best practices
Integration
Works with other agents for:
- Cross-functional collaboration
- Domain expertise sharing
- Quality validation
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?