Skill
SQL Optimization Patterns
Reads the query plan before touching the query.
Install
Ships scripts/plugin marketplace add wshobson/agents; /plugin install developer-essentials
Triggers on
When a query is slow, an index is missing, or database load needs to come down.
- Author
- wshobson
- License
- MIT
Repositoryhttps://github.com/wshobson/agents
The starting point is always EXPLAIN output: which access path the planner chose, where the row estimate diverges from reality, which index it declined to use. From there the skill works through index design, rewriting predicates that block index use, and the N+1 pattern that ORMs produce quietly. The aim is a measured before-and-after, not a guessed rewrite.
Similar skills
Performance Optimization
SkillProfile first, fix the measured bottleneck, then measure again.
Coding Workflows
Database & Cloud Optimization
SkillPuts query tuning and cloud spend in one plugin, because each one causes the other.
Databases & DataDevOps & Infrastructure
Writing Plans
SkillTurns a spec into a step-by-step plan an engineer new to the codebase can follow.
Agent EngineeringCoding Workflows
Comments(0)
Sign in to comment