Provide ClickHouse SQL patterns and table designs for analytics workflows.
npx skills add https://github.com/songkg7/dotfiles --skill clickhouse-io-songkg7
Please help me install this Agent Skill. Skill: clickhouse-io Source: https://github.com/songkg7/dotfiles/tree/main/dot_claude/skills/clickhouse-io Command: npx skills add https://github.com/songkg7/dotfiles --skill clickhouse-io-songkg7
This skill provides proven ClickHouse data design and query patterns to accelerate high-performance analytics, enabling teams to build scalable analytical pipelines with confidence.
Deploy or connect to a ClickHouse instance, review the included patterns, and implement a simple MergeTree-based table with a materialized view to observe real-time aggregates.
High-intent search queries and answers about installing and using this skill.
ClickHouse table design patterns like MergeTree, ReplacingMergeTree, and AggregatingMergeTree optimize storage, deduplication, and pre-aggregation for time-series analytics. These patterns enable fast aggregations and efficient columnar storage for high-performance workflows.
Optimize ClickHouse queries for large-scale BI dashboards by using efficient filtering, aggregations, window functions, and stateful functions. Materialized views provide real-time aggregations and efficient query patterns to accelerate dashboard performance.
Materialized views in ClickHouse work by automatically maintaining real-time aggregations as new data arrives. They provide efficient query patterns for dashboards, enabling fast analytics without reprocessing the entire dataset on each query.
Handle high-throughput data ingestion in ClickHouse using bulk and streaming insert patterns. These data ingestion patterns support high-throughput workflows, enabling teams to build scalable analytical pipelines for clickstream analytics and large-scale workloads.
Yes, SQL knowledge is required to use ClickHouse for analytics pipelines. The skill assumes a ClickHouse environment and SQL expertise, delivering SQL snippets, table design examples, and ETL-friendly pipeline templates for robust analytics.
Use AggregatingMergeTree in ClickHouse for pre-aggregation to optimize fast analytics, and ReplacingMergeTree for data deduplication. Both MergeTree patterns optimize storage but serve distinct purposes in scalable analytical pipeline design.
xu-xiangDesign ClickHouse tables and optimize queries with MergeTree family patterns.
deepan-alveApply ClickHouse MergeTree patterns and query optimizations for analytics workloads.
LiamVDB1Provide ClickHouse schema design, query optimization, and ingestion patterns.
sumeetonline90Optimize ClickHouse schemas, queries, and data ingestion for OLAP workloads.
