How does this skill help with ClickHouse performance?

It provides patterns for efficient indexing, partition pruning, and the use of column-specific data types like LowCardinality to minimize disk I/O and maximize query speed.

Does it provide guidance on data ingestion?

Absolutely. It covers the crucial 'batching' requirement for ClickHouse, providing TypeScript and SQL examples for bulk and streaming inserts to avoid performance degradation.

Can this skill help migrate from MySQL or PostgreSQL?

Yes, it includes ETL and CDC (Change Data Capture) patterns designed to sync data from relational sources into ClickHouse for analytical processing.

Can I use this for real-time data aggregation?

Yes, the skill includes detailed patterns for using Materialized Views and AggregatingMergeTree to maintain real-time metrics with minimal query overhead.

What ClickHouse engines are supported?

It focuses on the most powerful engines including MergeTree, ReplacingMergeTree (for deduplication), and AggregatingMergeTree (for pre-aggregations).

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: saar120

bysaar120

0•

データベース管理

Optimizes ClickHouse database schemas and queries for high-performance analytical workloads and efficient data engineering.

This skill empowers Claude with specialized knowledge for ClickHouse, a leading OLAP database system. It provides comprehensive guidance on designing schemas with various MergeTree engines, writing optimized analytical queries using window functions and specific aggregations, and implementing high-throughput data ingestion patterns. Whether you are migrating from traditional RDBMS like PostgreSQL or building real-time dashboards, this skill ensures your implementation follows performance best practices for partition pruning, materialized views, and column-based storage optimization.

主な機能

01Comprehensive query profiling and system monitoring utilities

02Real-time aggregation implementation using Materialized Views

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

04Performance-tuned analytical query patterns including window functions and quantiles

050 GitHub stars

06Efficient data ingestion patterns for batch and streaming pipelines

ユースケース

01Optimizing slow-running analytical queries through better indexing and partition strategies

02Migrating and transforming data from relational databases to ClickHouse for analytics

03Designing high-performance OLAP schemas for large-scale time-series and event data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add saar120/skillgate-registry clickhouse-io

For use in Claude.ai and ChatGPT

主な機能

01Comprehensive query profiling and system monitoring utilities

02Real-time aggregation implementation using Materialized Views

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

04Performance-tuned analytical query patterns including window functions and quantiles

050 GitHub stars

06Efficient data ingestion patterns for batch and streaming pipelines

ユースケース

01Optimizing slow-running analytical queries through better indexing and partition strategies

02Migrating and transforming data from relational databases to ClickHouse for analytics

03Designing high-performance OLAP schemas for large-scale time-series and event data