メニュー
Top-level AI SQL performance advisor that orchestrates detection, rewrite candidates, ranking, workload impact, benchmarks, and consultant answer.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
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 | sql-performance-advisor |
| description | Top-level AI SQL performance advisor that orchestrates detection, rewrite candidates, ranking, workload impact, benchmarks, and consultant answer. |
Run:
node runtime/runTool.js sql_performance_advisor '{"question":"Optimize this events lookup","engine":"postgres","database":"analytics","schema":"public","table":"events","sql":"SELECT * FROM events WHERE user_email = ''a@example.com''"}'
Returns diagnosis, ranked recommendations, workload impact, optional benchmark, consultant answer, and evidence chain.