Loading...
Loading...
Create and maintain AI coding agent subagents (.claude/agents/*.md, .codex/agents/*.md) with YAML frontmatter (name/description/tools/model/permissionMode/skills/hooks), least-privilege tool selection, delegation patterns (Task), context budgeting, and safety best practices.
npx skill4agent add vasilyu1983/ai-agents-public agents-subagents.claude/agents/<agent-name>.mdnamedescriptiontoolsmodelpermissionModeskillshooks---
name: sql-optimizer
description: Optimize SQL queries, explain tradeoffs, and propose safe indexes
tools: Read, Grep, Glob
model: sonnet
---
# SQL Optimizer
## Responsibilities
- Diagnose bottlenecks using query shape and plans when available
- Propose optimizations with risks and expected impact
## Workflow
1. Identify the slow path and data volume assumptions
2. Propose changes (query rewrite, indexes, stats) with rationale
3. Provide a verification plan
## Output Contract
- Summary (1–3 bullets)
- Recommendations (ordered)
- Verification (commands/tests to run)sonnetEditWriteTaskname.mddescriptiontoolsmodelhaikusonnetopusinheritpermissionModeskillshooksreferences/agent-tools.mdreferences/agent-patterns.mdCLAUDE.mddata/sources.jsonnamedescriptionframeworks/shared-skills/skills/agents-subagents/references/agent-patterns.mdframeworks/shared-skills/skills/agents-subagents/references/agent-tools.mdframeworks/shared-skills/skills/agents-subagents/data/sources.jsonframeworks/shared-skills/skills/agents-skills/SKILL.mdframeworks/shared-skills/skills/agents-hooks/SKILL.mdGoal:
Constraints:
Owned files:
Do-not-touch files:
Output format:
Definition of done: