Can I use this for high-speed data ingestion?

Yes, it includes TypeScript patterns for both bulk and streaming inserts, which are critical for ClickHouse to avoid the overhead of frequent small inserts.

Does it support real-time data aggregation?

Absolutely. It covers Materialized Views and AggregatingMergeTree patterns specifically designed to pre-aggregate data in real-time as it is ingested.

Is this skill suitable for complex business intelligence analysis?

Yes, it provides ready-to-use SQL templates for advanced time-series analysis, retention tracking, and conversion funnel analysis.

How does this skill help with ClickHouse performance?

It provides specific patterns for MergeTree engines, optimal indexing strategies, and partitioning logic to ensure queries run efficiently even on multi-billion row datasets.

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: ShunmeiCho

byShunmeiCho

0•

データベース管理

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

This skill equips Claude with specialized knowledge for architecting and optimizing ClickHouse databases, the industry standard for high-performance OLAP. It provides production-ready patterns for various MergeTree engine variants, efficient data ingestion strategies using TypeScript, and advanced analytical query structures like funnel and cohort analysis. Whether you are building real-time dashboards or complex ETL pipelines, this skill ensures your ClickHouse implementation follows industry best practices for partitioning, indexing, and materialized views to achieve sub-second query performance on massive datasets.

主な機能

01Advanced analytical query templates for cohort and funnel analysis

02Real-time aggregation strategies using Materialized Views

03Optimized MergeTree and AggregatingMergeTree schema designs

040 GitHub stars

05Query performance monitoring and system log optimization

06High-performance bulk and streaming data insertion patterns

ユースケース

01Building real-time analytics dashboards for high-volume event data

02Optimizing slow analytical queries using advanced indexing and partitioning strategies

03Architecting scalable ETL pipelines from PostgreSQL to ClickHouse

主な機能

01Advanced analytical query templates for cohort and funnel analysis

02Real-time aggregation strategies using Materialized Views

03Optimized MergeTree and AggregatingMergeTree schema designs

040 GitHub stars

05Query performance monitoring and system log optimization

06High-performance bulk and streaming data insertion patterns

ユースケース

01Building real-time analytics dashboards for high-volume event data

02Optimizing slow analytical queries using advanced indexing and partitioning strategies

03Architecting scalable ETL pipelines from PostgreSQL to ClickHouse