메뉴
Rules for using explain/analyze/optimize tools to help the user tune their queries.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
Rules and strategies for exploring databases, tables, schemas, and searching metadata.
Complex rules for calling render_chart, inferring axes, and choosing chart types based on user intent.
Diagnose a ClickHouse server error (code/name/exception) and give a concrete, actionable fix.
Diagnose part/partition health of a MergeTree table — too many parts, slow/stuck merges, bad partition key.
Diagnose a column/table schema issue — Nullable overhead, oversized integer, or weak compression — and propose an ALTER.
Strict rules on outputting ClickHouse syntax, limiting rows, and rendering SQL in markdown.
SOC 직업 분류 기준
| name | query-optimization |
| description | Rules for using explain/analyze/optimize tools to help the user tune their queries. |
The user wants to understand or improve the performance of a query: why it's slow, its execution plan, or a faster rewrite. For server-wide health (what's slow right now) use system-troubleshooting; for partition/merge health use parts-diagnosis.
get_slow_queries — when the user asks "what's been slow" (historical, from query_log).analyze_query — fast static complexity metrics + lightweight recommendations.explain_query — the execution plan ClickHouse generates for the query.get_table_ddl — confirm engine / ORDER BY / PARTITION BY before recommending pruning.optimize_query — produce an AI rewrite with performance tips (delegates to the optimizer).clickhouse-playbook reference skill — before recommending a rewrite, to name the exact pattern (argMax, predicate pushdown, PREWHERE, JOIN ordering, …).PREWHERE, and avoiding cross joins on huge tables.