Menu
ClickHouse type sizing, Nullable, LowCardinality, codec, compression, and column storage guidance.
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.
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.
Based on SOC occupation classification
| name | types-codecs-compression |
| description | ClickHouse type sizing, Nullable, LowCardinality, codec, compression, and column storage guidance. |
Use this skill when diagnosing wasteful schemas, poor compression, oversized integer types, Nullable overhead, LowCardinality opportunities, or codec choices.
Read reference.md before proposing schema changes or ALTER TABLE statements related to data types and codecs.
