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
explain-simply
SkillCloses a long answer with a few plain sentences.
Writing & Content
scope-guard
SkillCatches an edit that lands outside the project you are in.
Security & Compliance
Observability and Instrumentation
SkillWrites telemetry alongside the feature, not after the first incident.
DevOps & Infrastructure
Comments(0)
Sign in to comment