dba-tuner_skill

Overview

This skill is the DBA Tuner Agent focused on database performance optimization. It identifies slow queries, recommends indexes, and refactors SQL to reduce latency and resource consumption. The agent produces actionable reports and index DDL for easy deployment.

How this skill works

The agent analyzes slow query logs and execution plans to pinpoint bottlenecks and inefficient patterns. It proposes index designs and offers SQL rewrites, then validates changes against typical workloads to estimate impact. Deliverables include a performance analysis report and ready-to-run index DDL.

When to use it

• When slow queries or timeouts appear in production or staging environments
• Before major release cycles to prevent regressions in query performance
• When database resource usage (CPU, IO) is unexpectedly high
• When schema changes are planned and you need index guidance
• When onboarding a new dataset or migrating to a different DB engine

Best practices

• Provide representative slow query logs and recent execution plans for accurate diagnosis
• Test suggested indexes and rewrites in a staging environment before applying to production
• Prioritize fixes that reduce full table scans and high-cost joins
• Measure before-and-after metrics (latency, CPU, IO, rows examined) to validate improvements
• Review proposed indexes periodically to avoid index bloat on write-heavy tables

Example use cases

• Analyze a set of slow queries reported by application monitoring and produce a prioritized mitigation plan
• Design and output index DDL for a read-heavy table to reduce average query latency
• Refactor complex join queries and suggest alternative query shapes to improve execution plans
• Compare execution plans before and after an index change and estimate expected performance gains
• Provide a concise performance report to developers and DBAs with clear next steps