query-optimizer

name	query-optimizer
description	Review SQL queries, execution plans, schema usage, and indexes to propose safer faster alternatives. Use when a database query is slow or causing load problems.

Query Optimizer

Overview

Review SQL queries, execution plans, schema usage, and indexes to propose safer faster alternatives.

Core Workflow

1. Inspect the relevant diffs, configs, source files, or artifacts before forming a conclusion.
2. Compare the current state against repo conventions, expected guarantees, and known risk areas.
3. Prioritize the highest-impact gaps, regressions, or improvement opportunities instead of surface-level noise.
4. Recommend the smallest high-leverage changes and the checks that would validate them.

Deliver

• Ranked findings or improvement opportunities with clear evidence.
• The main risks, tradeoffs, or regressions that matter most.
• Validation steps or follow-up edits that would reduce risk.

Guardrails

• Lead with findings, not generic praise or low-value commentary.
• Use repo evidence and surrounding context instead of reviewing in isolation.
• Flag missing validation when a recommendation depends on behavior you could not confirm.
• Prefer repository evidence, command output, and nearby tests over vague intuition.