MooseStack ClickHouse Best Practices

Comprehensive guidance for ClickHouse in MooseStack applications covering data model design, query optimization, and data ingestion. Contains 28 rules across 3 main categories (schema, query, insert), prioritized by impact. Each rule includes MooseStack TypeScript and Python examples.

MooseStack docs: MooseStack Documentation ClickHouse docs: ClickHouse Best Practices

IMPORTANT: How to Apply This Skill

Before answering MooseStack/ClickHouse questions, follow this priority order:

1. Check for applicable rules in the rules/ directory
2. If rules exist: Apply them and cite them in your response using "Per rule-name..."
3. Apply MooseStack patterns: Each rule includes TypeScript and Python examples for data models, OlapTables, and APIs
4. If no rule exists: Use MooseStack or ClickHouse documentation
5. If uncertain: Use web search for current best practices
6. Always cite your source: rule name, "general MooseStack guidance", or URL

Why rules take priority: ClickHouse has specific behaviors (columnar storage, sparse indexes, merge tree mechanics) where general database intuition can be misleading. The rules encode validated guidance with MooseStack-specific patterns for TypeScript and Python.