Menu
Diagnose a ClickHouse server error (code/name/exception) and give a concrete, actionable fix.
Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.
Basé sur la classification professionnelle SOC
| name | error-diagnosis |
| description | Diagnose a ClickHouse server error (code/name/exception) and give a concrete, actionable fix. |
The user reports or pastes a ClickHouse error and wants to know what it means, why it's happening, and how to fix it. Investigate read-only, then give a concrete solution — not generic advice.
run_select_query against system.errors — confirm the error and its count/last message: SELECT name, code, value, last_error_time, last_error_message FROM system.errors WHERE name = '<NAME>' OR code = <CODE> ORDER BY last_error_time DESC. (Never ORDER BY event_time — no such column.)run_select_query to find the underlying cause, matched to the error family:
system.parts (GROUP BY partition), system.merges, system.mutations.system.metrics / system.asynchronous_metrics, and get_slow_queries for the offending query shape.system.replicas (absolute_delay, is_readonly, queue_size).system.disks (free_space).get_server_info — version context if the error is version-specific.system-table-reference reference skill — BEFORE any raw system.* SELECT (exact column names).clickhouse-playbook reference skill — when the fix implies a query/schema change.system.query_log scans.FORMAT clause. A human applies any fix.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 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.
Strict rules on outputting ClickHouse syntax, limiting rows, and rendering SQL in markdown.