clickhouse-materialized-views
✓10+ patterns for ClickHouse Materialized Views. Load when creating MVs for real-time aggregation, data transformation, or query optimization. Covers SummingMergeTree, AggregatingMergeTree, and common pitfalls.
Installation
SKILL.md
Load when creating Materialized Views for real-time aggregation, ETL pipelines, or query optimization.
Prerequisite: Understand MergeTree engine variants in clickhouse-schema-design skill.
Search terms: materialized view, MV, real-time aggregation, AggregateFunction, -State, -Merge, SummingMergeTree, pre-aggregation, incremental
10+ patterns for ClickHouse Materialized Views. Load when creating MVs for real-time aggregation, data transformation, or query optimization. Covers SummingMergeTree, AggregatingMergeTree, and common pitfalls. Source: obsessiondb/clickhouse-skills.
Facts (cite-ready)
Stable fields and commands for AI/search citations.
- Install command
npx skills add https://github.com/obsessiondb/clickhouse-skills --skill clickhouse-materialized-views- Category
- {}Data Analysis
- Verified
- ✓
- First Seen
- 2026-02-05
- Updated
- 2026-02-18
Quick answers
What is clickhouse-materialized-views?
10+ patterns for ClickHouse Materialized Views. Load when creating MVs for real-time aggregation, data transformation, or query optimization. Covers SummingMergeTree, AggregatingMergeTree, and common pitfalls. Source: obsessiondb/clickhouse-skills.
How do I install clickhouse-materialized-views?
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/obsessiondb/clickhouse-skills --skill clickhouse-materialized-views Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code or Cursor
Where is the source repository?
https://github.com/obsessiondb/clickhouse-skills
Details
- Category
- {}Data Analysis
- Source
- skills.sh
- First Seen
- 2026-02-05