Menu
Ranks index candidates by read benefit, write penalty, storage cost, and maintenance risk.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Designs dry-run experiments across query rewrites, indexes, workload twins, and rollout gates.
Produces a board-level briefing for closed-loop autonomous database operations.
Enforces closed-loop dry-run boundaries and blocks autonomous production apply.
Scores whether enough evidence exists to recommend, defer, or escalate an autonomous operator decision.
Compares do-nothing, dry-run-change, rollback, and defer scenarios for an operating objective.
Builds an executive-grade decision evidence packet from runtime signals and confidence checks.
| name | index-roi-simulator |
| description | Ranks index candidates by read benefit, write penalty, storage cost, and maintenance risk. |
Run:
node runtime/runTool.js index_roi_simulator '{"candidates":[{"id":"idx_events_user_email","readBenefitMs":180,"readQps":40,"writePenaltyMs":3,"writeQps":8,"storageMb":512}]}'
Returns ranked candidates, ROI score, break-even signal, and benchmark recommendation.