Can this skill help with data ingestion?

Yes, it includes best practices for batch insertion and streaming patterns to avoid the common mistake of small, frequent individual inserts which degrade ClickHouse performance.

Does it provide patterns for complex data analysis?

Absolutely. It includes ready-to-use SQL patterns for common analytical needs such as cohort analysis, conversion funnels, and retention tracking.

What table engines does this ClickHouse skill support?

This skill provides detailed implementation patterns for MergeTree, ReplacingMergeTree (for deduplication), and AggregatingMergeTree (for pre-calculated metrics).

How does it help with ClickHouse query performance?

It provides specific patterns for efficient filtering using primary keys, partition pruning, and using ClickHouse-specific functions like quantiles and uniqMerge.

Is this skill suitable for real-time data needs?

Yes, it focuses heavily on real-time capabilities using Materialized Views and high-speed aggregation techniques for sub-second query responses on large datasets.

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: affaan-m

byaffaan-m

•

156,032

•

数据库管理

Optimizes analytical workloads with ClickHouse database patterns, query tuning, and high-performance data engineering best practices.

The ClickHouse-io skill equips Claude with specialized knowledge for architecting and managing ClickHouse, the leading open-source OLAP database. It provides comprehensive guidance on selecting the right table engines like MergeTree, implementing efficient batch data ingestion, and writing optimized SQL for complex analytical tasks. From designing materialized views for real-time dashboards to executing retention and funnel analysis on billions of rows, this skill ensures your data infrastructure is built for extreme speed and scalability.

主要功能

01Advanced analytical SQL patterns for cohort, funnel, and time-series analysis

02156,032 GitHub stars

03Specialized schema design for MergeTree, ReplacingMergeTree, and AggregatingMergeTree engines

04Materialized View implementation and system performance monitoring scripts

05High-efficiency data ingestion strategies including batch and streaming insertion

06Query optimization patterns for filtering, aggregations, and window functions

使用场景

01Migrating large-scale analytical workloads from PostgreSQL or MySQL to ClickHouse

02Building real-time analytical dashboards for high-velocity log or event data

03Optimizing data pipelines and ETL processes for high-performance data warehousing

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add affaan-m/everything-claude-code clickhouse-io

For use in Claude.ai and ChatGPT

主要功能

01Advanced analytical SQL patterns for cohort, funnel, and time-series analysis

02156,032 GitHub stars

03Specialized schema design for MergeTree, ReplacingMergeTree, and AggregatingMergeTree engines

04Materialized View implementation and system performance monitoring scripts

05High-efficiency data ingestion strategies including batch and streaming insertion

06Query optimization patterns for filtering, aggregations, and window functions

使用场景

01Migrating large-scale analytical workloads from PostgreSQL or MySQL to ClickHouse

02Building real-time analytical dashboards for high-velocity log or event data

03Optimizing data pipelines and ETL processes for high-performance data warehousing