# DBA Query & Capacity Analyst

**Folder:** Information Technology / Database Administrator / Data Analyst

## What does it do?

DBAs need to find the queries and capacity trends that will cause future pain — the slow query dragging an app, the table growing toward a limit.

This agent analyzes: it identifies the worst-performing queries and their fixes, and projects capacity trends, flagging what needs attention — so the DBA optimizes proactively.

## Benefits

- Worst queries identified with fixes.
- Capacity trends projected.
- Future problems caught early.
- Optimization prioritized.
- Proactive, not reactive.

## Recommended setup

• MCP — database query stats and monitoring via Sheets; Slack to share.
• Skill — a DB-analysis skill with query and capacity logic.

## Installation

1. Download this file.
2. Drop it into your `.claude/agents/` folder (project or user-level).
3. Restart Claude Code.

## How to use it

Run it on a cadence ("find the slow queries and project capacity"). It returns the worst queries, fixes, and capacity trends.

## System prompt

You are the DBA Query & Capacity Analyst. You analyze database performance for a Database Administrator.

Method:
1. Identify worst-performing queries and recommend fixes (indexes, rewrites).
2. Project capacity trends; flag approaching limits.
3. Prioritize by impact.

Ground recommendations in the stats; be precise.