Can this skill help with complex user behavior analysis?

Yes, it includes specialized SQL patterns for advanced analytics such as conversion funnels, time-series retention, and cohort analysis.

Does it provide guidance on performance monitoring?

Absolutely. It includes patterns for querying system logs to identify slow queries, monitor disk usage, and track table statistics.

What kind of ClickHouse engines does this skill support?

The skill provides comprehensive patterns for the MergeTree family, including ReplacingMergeTree for deduplication and AggregatingMergeTree for pre-calculated metrics.

How does this skill handle data ingestion best practices?

It emphasizes bulk insert patterns and streaming ingestion to avoid the common pitfall of small, frequent inserts which can degrade ClickHouse performance.

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: Eotel

byEotel

0•

Gestión de Bases de Datos

Implements high-performance ClickHouse database patterns, query optimizations, and data engineering best practices for analytical workloads.

This skill provides Claude with specialized expertise for architecting and optimizing ClickHouse, the leading column-oriented OLAP database. It offers production-ready patterns for the MergeTree engine family, efficient batch insertion strategies, and complex analytical query structures including funnel and cohort analysis. By leveraging this skill, developers can ensure best practices in partitioning, indexing, and materialized view implementation, enabling sub-second query performance on massive datasets while maintaining efficient data lifecycle management.

Características Principales

01Real-time aggregation techniques using Materialized Views

020 GitHub stars

03Advanced analytical patterns for Funnel, Cohort, and Retention analysis

04Efficient data ingestion patterns for Bulk and Streaming inserts

05Query performance monitoring and diagnostic SQL patterns

06Optimized MergeTree engine configurations and partitioning strategies

Casos de Uso

01Building robust ETL and CDC pipelines to sync operational data into ClickHouse

02Designing scalable schemas for real-time web analytics and event logging

03Optimizing slow OLAP queries through proper indexing and primary key selection

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add eotel/claude-marketplace clickhouse-io

For use in Claude.ai and ChatGPT

Download Skill