All skills
indexing-query-optimization
FoundationJIT onlytask-agent/review-agent: use when predicates, sorting, cardinality, query plans, pagination, indexes, or write cost change; skip when no query/index decision exists.
- Group
- Data & middleware
- Supported roles
- MainAnalysisTaskReview
- Source
- SKILL.md
Use when
Trigger signals that make this skill the right owner
- optimize indexes query plans pagination filters sorting and read paths
Do not use when
Anti-triggers — as binding as the triggers above
- no task-local indexing query optimization decision is required
Required inputs
What must be supplied before this skill can decide anything
- current task contract
- selected primary Professional Skill
- task-local trigger evidence
Output contract
What this skill owes the next role
- query optimization decision with beneficiary query, plan and distribution evidence, index or query rationale, pagination semantics, write and lifecycle cost, rollout comparison, proof limits, and residual owners
Escalation signals
When this skill must hand the decision back
- Slow queries degrade reliability and can trigger costly production incidents
Loaded by
This skill never owns a task. These professionals may pull it in as Layer 3.
Targeted references
Each reference carries its own load condition. None of them enter context by default.
| Reference | Load when | Do not load when | Required by |
|---|---|---|---|
| benchmarks-and-patterns.mdbenchmark-pattern | Index type, pagination, plan, or write-cost choices compete. | No material query plan or access pattern changes. | TaskReview |
| checklist.mddecision-checklist | Optimization affects selectivity, ordering, writes, builds, or N-plus-one behavior. | The query has no measurable resource or latency risk. | TaskReview |
| evidence-patterns.mdevidence-pattern | Optimization claims need current plans, volumes, and benchmark results. | No plan or capacity claim is being approved. | TaskReview |