메뉴
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.