Does this skill cover data ingestion strategies?

Yes, it includes detailed patterns for both batch and streaming data insertion, emphasizing high-efficiency methods that avoid common performance bottlenecks.

How does this skill help with real-time data processing?

It provides guidance on using Materialized Views combined with AggregatingMergeTree engines to perform real-time data aggregation as data is inserted.

What is the primary focus of the clickhouse-io skill?

It provides specialized patterns and best practices for designing, querying, and managing ClickHouse databases specifically for high-performance analytical (OLAP) workloads.

Can I use this for query performance tuning?

Absolutely. It contains specific patterns for index-aware filtering, efficient join alternatives, and using system logs to identify and fix slow queries.

ClickHouse Analytics & Data Engineering

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

byaffaan-m

•

112,917

•

データベース管理

Optimizes ClickHouse database performance with advanced table design patterns, query optimization, and real-time analytical workflows.

This skill provides a comprehensive set of patterns and best practices for leveraging ClickHouse as a high-performance OLAP database. It guides users through complex table engine selection including MergeTree, ReplacingMergeTree, and AggregatingMergeTree, while offering specialized strategies for efficient batch data insertion and real-time materialized views. Whether you are building time-series dashboards, performing cohort analysis, or setting up robust ETL pipelines, this skill ensures your ClickHouse implementation follows industry-standard patterns for maximum scalability and query speed.

主な機能

01Optimized analytical query structures using ClickHouse-specific aggregate functions

02Advanced MergeTree engine patterns for data deduplication and pre-aggregation

03High-performance batch and streaming data insertion techniques for Node.js

04112,917 GitHub stars

05System monitoring patterns for tracking query duration and resource usage

06Real-time analytics implementation via Materialized Views and state functions

ユースケース

01Building high-concurrency real-time analytics dashboards for massive datasets

02Implementing efficient ETL and CDC pipelines from transactional databases to ClickHouse

03Performing complex time-series, funnel, and cohort analysis for user behavior tracking

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

主な機能

01Optimized analytical query structures using ClickHouse-specific aggregate functions

02Advanced MergeTree engine patterns for data deduplication and pre-aggregation

03High-performance batch and streaming data insertion techniques for Node.js

04112,917 GitHub stars

05System monitoring patterns for tracking query duration and resource usage

06Real-time analytics implementation via Materialized Views and state functions

ユースケース

01Building high-concurrency real-time analytics dashboards for massive datasets

02Implementing efficient ETL and CDC pipelines from transactional databases to ClickHouse

03Performing complex time-series, funnel, and cohort analysis for user behavior tracking