Comprehensive guidance for ClickHouse covering schema design, query optimization, and data ingestion. Contains 28 rules across 3 main categories (schema, query, insert), prioritized by impact.
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, ClickHouse-specific guidance.
When performing a formal review of schemas, queries, or data ingestion:
DA UTILIZZARE durante la revisione di schemi, query o configurazioni ClickHouse. Contiene 28 regole che DEVONO essere controllate prima di fornire raccomandazioni. Leggi sempre i file delle regole pertinenti e cita regole specifiche nelle risposte. Fonte: clickhouse/agent-skills.