ClickHouse Best Practices (TypeScript, Python)

ClickHouse data modeling best practices extended with MooseStack TypeScript and Python examples. 28 rules across 3 categories (schema, query, insert), prioritized by impact.

MooseStack docs: MooseStack Documentation ClickHouse docs: ClickHouse Best Practices

IMPORTANT: How to Apply This Skill

Two modes — pick the right one for the situation:

Inline mode (default — use this during authoring / optimization)

When the user is actively building or iterating on code, apply rules inline:

1. Identify which 1–2 rules are directly relevant to the current decision (e.g. choosing an ORDER BY, picking a type, deciding on batch size).
2. Read only those rule file(s). Do not pre-emptively read 6+ rules.
3. Apply the rule immediately in the code you're writing; cite the rule name in a brief comment or sentence (e.g. "Per schema-pk-cardinality-order, ORDER BY user_id, event_ts.").
4. Keep moving — continue writing the pipeline, schema, or query. Do NOT stop to emit a "Rules Checked / Findings" audit.