Provide ClickHouse pattern templates for schema design and query optimization.
npx skills add https://github.com/shygoly/sapbase --skill clickhouse-io-shygoly
Please help me install this Agent Skill. Skill: clickhouse-io Source: https://github.com/shygoly/sapbase/tree/main/docs/zh-CN/skills/clickhouse-io Command: npx skills add https://github.com/shygoly/sapbase --skill clickhouse-io-shygoly
ClickHouse is a robust OLAP database designed for large-scale analytics. This Skill provides patterns for schema design, query optimization, and data engineering practices to maximize performance on heavy analytic workloads.
To start, design a ClickHouse schema and queries that enable high-throughput analytics across large datasets.
High-intent search queries and answers about installing and using this skill.
Design ClickHouse schemas for OLAP workloads using MergeTree engines, explicit deduplication rules, and pre-aggregation patterns to maximize query performance on large-scale event data.
Optimize ClickHouse queries for real-time dashboards by applying targeted filters, efficient aggregations, window functions, and materialized views to reduce processing overhead on large datasets.
Build scalable ClickHouse data pipelines by implementing ETL and CDC patterns, choosing between batch and streaming ingestion based on your data velocity and analytics requirements.
Use ClickHouse materialized views when you need to pre-aggregate large datasets or accelerate complex analytical queries, reducing latency for real-time dashboards and heavy reporting scenarios.
Yes, these ClickHouse patterns support both streaming and batch ingestion, providing scalable data pipeline templates that enforce best practices for high-throughput analytics across various data velocities.
Dev-Dennis-040Automate ETL/ELT pipeline and lakehouse architecture design for analytics-ready data.
dy9759Design charts, dashboards, and interactive data applications for business analytics.
NixdorferProvides best practices and patterns for ClickHouse database management and optimization.
kouisoOptimize ClickHouse databases with MergeTree engines and query techniques.
