What are the best practices for data insertion recommended by this skill?

The skill emphasizes bulk insertion and streaming over individual inserts to avoid performance degradation and ensure the system handles high-frequency data correctly.

How does this skill help with ClickHouse query performance?

It provides specific patterns for indexing, sorting keys, and utilizing ClickHouse-specific aggregate functions like quantiles and uniq to minimize latency on large datasets.

Does it support different ClickHouse engines?

It covers specialized engines including MergeTree for general use, ReplacingMergeTree for deduplication, and AggregatingMergeTree for efficient pre-aggregation.

Can it help with data migration to ClickHouse?

Yes, it includes patterns for ETL pipelines and Change Data Capture (CDC) to efficiently move data from sources like PostgreSQL into ClickHouse using batching.

ClickHouse Analytics & Optimization

Name: ClickHouse Analytics & Optimization
Author: unju-ai

byunju-ai

0•

データベース管理

Implements high-performance ClickHouse database patterns, query optimizations, and data engineering best practices for large-scale analytical workloads.

This skill provides specialized guidance for working with ClickHouse, the open-source column-oriented OLAP database. It assists developers in designing efficient table schemas using various MergeTree engines, writing optimized SQL for fast filtering and aggregation, and managing large-scale data ingestion through batching and streaming. Whether building real-time dashboards, performing complex cohort analysis, or setting up ETL pipelines, this skill ensures best practices for performance, storage efficiency, and system monitoring within the ClickHouse ecosystem.

主な機能

01Advanced table schema design using MergeTree and AggregatingMergeTree engines

02Performance monitoring and system diagnostic query templates

03Implementation of Materialized Views for real-time data aggregation

04Query optimization patterns for high-speed filtering and window functions

050 GitHub stars

06Efficient data ingestion strategies including bulk inserts and streaming patterns

ユースケース

01Scaling data pipelines from transactional databases to high-performance OLAP storage

02Building real-time analytical dashboards with sub-second query latency

03Implementing complex time-series and user behavior analysis such as funnels and cohorts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add unju-ai/ecc clickhouse-io

For use in Claude.ai and ChatGPT