菜单
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.