What is the primary focus of this ClickHouse skill?

It focuses on high-performance analytical processing (OLAP), providing best practices for schema design, query optimization, and efficient data ingestion.

Which ClickHouse table engines does this skill cover?

It provides patterns for the MergeTree family, including ReplacingMergeTree for deduplication and AggregatingMergeTree for pre-aggregation.

How does it help with query performance?

It provides specific guidance on column-first filtering, efficient aggregation functions like uniq() and quantile(), and the use of Materialized Views for pre-calculation.

Can this skill help with real-time data ingestion?

Yes, it includes patterns for both bulk inserts and streaming data ingestion using Node.js, as well as CDC patterns from sources like PostgreSQL.

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: claudiodearaujo

byclaudiodearaujo

0•

データベース管理

Optimizes ClickHouse database performance through high-performance schema design, analytical query patterns, and efficient data engineering practices.

This skill provides a comprehensive set of ClickHouse-specific patterns and best practices for developers building high-performance analytical systems. It covers critical areas such as table engine selection (MergeTree, ReplacingMergeTree), materialized view implementation for real-time aggregations, and advanced query optimization techniques like column-first filtering and specialized aggregation functions. Whether you're building a real-time analytics dashboard or a complex ETL pipeline, this skill guides Claude in implementing efficient, scalable ClickHouse solutions that leverage the full power of columnar storage.

主な機能

010 GitHub stars

02Real-time data aggregation strategies using Materialized Views and state/merge functions

03Efficient data ingestion patterns for bulk and streaming workloads using Node.js

04High-performance analytical query optimization using ClickHouse-specific functions

05Specialized table engine design patterns for MergeTree, ReplacingMergeTree, and AggregatingMergeTree

06Performance monitoring techniques for query logs and table statistics

ユースケース

01Building scalable ETL/CDC pipelines to sync data from transactional databases to ClickHouse

02Designing high-throughput OLAP schemas for financial or market data analytics

03Implementing real-time conversion funnels and user retention dashboards

主な機能

010 GitHub stars

02Real-time data aggregation strategies using Materialized Views and state/merge functions

03Efficient data ingestion patterns for bulk and streaming workloads using Node.js

04High-performance analytical query optimization using ClickHouse-specific functions

05Specialized table engine design patterns for MergeTree, ReplacingMergeTree, and AggregatingMergeTree

06Performance monitoring techniques for query logs and table statistics

ユースケース

01Building scalable ETL/CDC pipelines to sync data from transactional databases to ClickHouse

02Designing high-throughput OLAP schemas for financial or market data analytics

03Implementing real-time conversion funnels and user retention dashboards