Optimize ClickHouse schemas and queries for analytical workloads.
npx skills add https://github.com/Maelwalser/claude-config --skill clickhouse-io-maelwalser
Please help me install this Agent Skill. Skill: clickhouse-io Source: https://github.com/Maelwalser/claude-config/tree/main/skills/clickhouse-io Command: npx skills add https://github.com/Maelwalser/claude-config --skill clickhouse-io-maelwalser
Provides practical guidance to design ClickHouse schemas and queries that deliver fast analytical performance while minimizing storage and compute costs.
Ask the skill to review a ClickHouse table schema and recommend MergeTree engine, partitioning, ORDER BY keys, and any materialized views to optimize a given query workload.
High-intent search queries and answers about installing and using this skill.
Optimize ClickHouse schemas by selecting the right MergeTree engine variant, defining appropriate partitioning granularity, and designing ORDER BY keys to maximize read efficiency and data compression for analytical workloads.
Use materialized views and AggregatingMergeTree pre-aggregations in ClickHouse to process streaming data and maintain real-time dashboard metrics, reducing query latency by pre-computing aggregations as data arrives.
The best data ingestion pattern for ClickHouse depends on your pipeline: use bulk inserts for large batch loads and streaming ingestion with Kafka integration for continuous real-time event data delivery.
Choose MergeTree engine variants and ORDER BY keys by analyzing your query workload's filter conditions and aggregation patterns to ensure optimal data locality, compression, and scan performance.
You can migrate event analytics from PostgreSQL to ClickHouse by redesigning tables for OLAP, adding materialized views for dashboards, and implementing batch or CDC ingestion pipelines for continuous data sync.
Slow ClickHouse OLAP queries often stem from schema anti-patterns, suboptimal ORDER BY keys, or inefficient aggregation strategies, which can be fixed by adding projections, adjusting partitioning, and rewriting query filters.
nrakowSelect and configure data ingestion strategies for Fivetran, Airbyte, or custom pipelines.
sayasaya8039Design optimized ClickHouse table schemas and write high-performance analytical queries.
NixdorferProvides best practices and patterns for ClickHouse database management and optimization.
aaioneOptimize ClickHouse OLAP workloads with MergeTree table design and query patterns.
