Does it provide guidance on data ingestion?

Absolutely. It includes best practices for batch insertions and streaming data to prevent the 'too many parts' error and ensure optimal write performance.

What type of ClickHouse engines does this skill cover?

It focuses primarily on the MergeTree family, including ReplacingMergeTree for deduplication and AggregatingMergeTree for pre-calculated metrics, which are essential for high-performance OLAP.

How does it help with complex data analysis?

The skill includes specialized SQL patterns for advanced analytics such as funnel analysis, monthly user cohorts, and complex time-series aggregations.

Can this skill help with database migration?

Yes, it provides specific strategies and code patterns for migrating analytical workloads from row-based databases like PostgreSQL or MySQL to the column-oriented architecture of ClickHouse.

ClickHouse Analytics & DB Patterns

Name: ClickHouse Analytics & DB Patterns
Author: saar120

bysaar120

0•

数据库管理

Optimizes ClickHouse database performance with specialized patterns for high-performance analytical workloads and data engineering.

This skill provides Claude with deep expertise in ClickHouse, the leading column-oriented OLAP database. It enables Claude to assist with complex table schema designs using the MergeTree engine family, advanced SQL query optimization, and efficient batch data insertion patterns. Whether you are migrating from traditional RDBMS like PostgreSQL or building real-time dashboards for multi-terabyte datasets, this skill ensures best practices for partitioning, sorting keys, and high-concurrency analytical queries are followed to achieve sub-second latency.

主要功能

01SQL Query Optimization including Partition Pruning and Projections

02Advanced Table Schema Design (MergeTree, ReplacingMergeTree, AggregatingMergeTree)

03Real-Time Analytical Query Patterns (Funnel, Cohort, and Time-series)

040 GitHub stars

05High-Performance Batch and Streaming Data Ingestion Patterns

06Performance Monitoring and Materialized View Implementation

使用场景

01Optimizing slow-running SQL queries using ClickHouse-specific aggregate functions and windowing.

02Designing scalable ClickHouse schemas for multi-terabyte analytical environments.

03Migrating analytical workloads from PostgreSQL or MySQL to ClickHouse for better performance.

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

主要功能

01SQL Query Optimization including Partition Pruning and Projections

02Advanced Table Schema Design (MergeTree, ReplacingMergeTree, AggregatingMergeTree)

03Real-Time Analytical Query Patterns (Funnel, Cohort, and Time-series)

040 GitHub stars

05High-Performance Batch and Streaming Data Ingestion Patterns

06Performance Monitoring and Materialized View Implementation

使用场景

01Optimizing slow-running SQL queries using ClickHouse-specific aggregate functions and windowing.

02Designing scalable ClickHouse schemas for multi-terabyte analytical environments.

03Migrating analytical workloads from PostgreSQL or MySQL to ClickHouse for better performance.

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