Optimize ClickHouse schemas, queries, and data ingestion pipelines.
npx skills add https://github.com/YosefHayim/Template --skill clickhouse-io-yosefhayim
Please help me install this Agent Skill. Skill: clickhouse-io Source: https://github.com/YosefHayim/Template/tree/main/.cursor/skills/clickhouse-io Command: npx skills add https://github.com/YosefHayim/Template --skill clickhouse-io-yosefhayim
This Skill helps users design efficient ClickHouse schemas, write optimized analytical queries, and implement robust data ingestion pipelines for high-performance analytical workloads.
Use the clickhouse-io skill to create an AggregatingMergeTree table for hourly market statistics.
High-intent search queries and answers about installing and using this skill.
Optimize slow ClickHouse queries by selecting appropriate MergeTree engines, applying efficient filtering, and using aggregations or window functions following provided best practices to accelerate analytical workloads.
The best way to design a ClickHouse schema is choosing the right MergeTree engine variant, like ReplacingMergeTree or AggregatingMergeTree, and defining table structures tailored to your specific data patterns.
Set up real-time data aggregation in ClickHouse by implementing materialized views that automatically process and aggregate streaming data, enabling immediate analytical insights for high-performance workloads.
Yes, you can use materialized views for streaming data ingestion in ClickHouse to automatically aggregate incoming data, ensuring your analytical dashboards remain updated with minimal query overhead.
Use the AggregatingMergeTree engine for aggregating data in ClickHouse, as it automatically merges rows with identical sorting keys, storing intermediate aggregation states for efficient analytical queries.
Dashboard performance degrades during high-volume ingestion if table schemas lack proper MergeTree engine configurations or queries use inefficient aggregations, requiring refactoring based on established data engineering patterns.
KuaaMUProvide ClickHouse schema design and query optimization patterns for analytical workloads.
openaiCreate source-backed analytical dashboards with metric definitions and validation.
vinwangDesign ClickHouse schemas, optimize queries, and streamline ingestion.
KimjimanGuide ClickHouse schema design, query optimization, and data ingestion patterns.
