메뉴
Diagnose server-state issues using running queries, slow-query history, and server info.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
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.
Rules for using explain/analyze/optimize tools to help the user tune their queries.
Diagnose a column/table schema issue — Nullable overhead, oversized integer, or weak compression — and propose an ALTER.
| name | system-troubleshooting |
| description | Diagnose server-state issues using running queries, slow-query history, and server info. |
The user is asking about the live state of the ClickHouse server: it feels slow, queries are stuck, memory looks high, or they want to know what's running now or what ran heavy recently. Do NOT use this to optimize a specific SQL they gave you (use query-optimization), or for storage/schema questions (use schema-diagnosis).
get_server_info — version + uptime context first.get_running_queries — what's executing NOW (elapsed seconds, memory). Use for "stuck"/"slow right now".get_slow_queries — recently FINISHED heavy/slow queries from system.query_log. Use for "what was slow earlier".run_select_query against system.metrics / system.asynchronous_metrics — only when you need a specific live metric value.system-table-reference reference skill — BEFORE writing any raw system.* SELECT, so you use exact column names (e.g. system.errors has last_error_time, not event_time).FORMAT clause.