clickhouse-materialized-views
Installation
SKILL.md
ClickHouse Materialized Views
Load when creating Materialized Views for real-time aggregation, ETL pipelines, or query optimization.
Prerequisite: Understand MergeTree engine variants in clickhouse-schema-design skill.
Reference Documentation
Search terms: materialized view, MV, real-time aggregation, AggregateFunction, -State, -Merge, SummingMergeTree, pre-aggregation, incremental
Critical Rules
[CRITICAL]
Related skills
More from obsessiondb/clickhouse-plugin
clickhouse-schema-design
15+ schema rules for ClickHouse tables. ALWAYS LOAD when creating or modifying tables. Achieves sub-second queries, 10x compression, and automated data lifecycle.
4clickhouse-query-optimization
20+ optimization rules for ClickHouse queries. Load when writing queries, debugging slow queries, fixing memory errors, or optimizing JOINs. Achieves 10-100x faster queries, 90% less memory usage.
4