Menu
Exact ClickHouse system table and column reference for safe system.* diagnostics.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
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-table-reference |
| description | Exact ClickHouse system table and column reference for safe system.* diagnostics. |
Use this skill before writing raw system.* queries or diagnosing server health, parts, merges, mutations, replicas, errors, query logs, or memory metrics.
Read reference.md to use exact table and column names. Do not guess columns in system.* tables.
