Which ClickHouse table engines are covered by these patterns?

The skill provides patterns for the MergeTree family, including ReplacingMergeTree for deduplication and AggregatingMergeTree for efficient pre-aggregations.

What is the primary focus of this ClickHouse skill?

The skill focuses on optimizing ClickHouse for high-performance analytical workloads (OLAP), covering schema design, query optimization, and efficient data ingestion techniques.

Can this help with migrating from traditional SQL databases?

Yes, it includes specific guidance for migrating analytical queries and schemas from row-oriented databases like PostgreSQL or MySQL to ClickHouse's column-oriented architecture.

How does this skill improve query performance?

It implements best practices for index selection, partition pruning, materialized views, and ClickHouse-specific aggregation functions to minimize query latency.

Does it include implementation examples for data pipelines?

Yes, it provides TypeScript and SQL patterns for both bulk and streaming data ingestion, as well as Change Data Capture (CDC) workflows.

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: Infopibe

byInfopibe

•

データベース管理

Optimizes analytical workflows using ClickHouse-specific patterns for high-performance data engineering and query execution.

This skill empowers Claude to design and implement robust ClickHouse architectures for high-performance analytical processing. It provides expert guidance on choosing the right MergeTree engines, structuring complex analytical queries with window functions and aggregations, and implementing efficient data ingestion pipelines. Whether you are migrating from a transactional database or building real-time dashboards, this skill ensures best practices for partition pruning, materialized views, and schema design to maximize ClickHouse's column-oriented processing advantages.

主な機能

01Performance monitoring and system health diagnostics

02Advanced MergeTree engine selection and schema design

03Efficient bulk and streaming data ingestion patterns

041 GitHub stars

05Real-time aggregation implementation with Materialized Views

06High-performance analytical query optimization using window functions

ユースケース

01Migrating analytical workloads from PostgreSQL or MySQL to ClickHouse

02Building efficient ETL/ELT pipelines for high-velocity data ingestion

03Designing real-time analytics dashboards for high-volume datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add infopibe/everything-claude-code clickhouse-io

For use in Claude.ai and ChatGPT

主な機能

01Performance monitoring and system health diagnostics

02Advanced MergeTree engine selection and schema design

03Efficient bulk and streaming data ingestion patterns

041 GitHub stars

05Real-time aggregation implementation with Materialized Views

06High-performance analytical query optimization using window functions

ユースケース

01Migrating analytical workloads from PostgreSQL or MySQL to ClickHouse

02Building efficient ETL/ELT pipelines for high-velocity data ingestion

03Designing real-time analytics dashboards for high-volume datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add infopibe/everything-claude-code clickhouse-io

For use in Claude.ai and ChatGPT