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

It focuses on providing best practices and implementation patterns for ClickHouse, a column-oriented DBMS designed for high-performance analytical queries on large datasets.

Can this skill help with data ingestion?

Yes, it includes specialized patterns for bulk inserts, streaming inserts, and ETL pipelines to ensure efficient data loading without impacting database performance.

Does it cover advanced analytical functions?

Absolutely, the skill provides templates for complex time-series analysis, funnel analysis, and cohort analysis using ClickHouse-specific aggregation functions.

How does it help with database performance?

It offers guidance on table partitioning, choosing optimal ordering keys, leveraging materialized views, and monitoring system logs to identify and resolve query bottlenecks.

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: Aventerica89

byAventerica89

0•

데이터베이스 관리

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

This skill equips Claude with specialized knowledge for architecting and optimizing ClickHouse databases, the leading column-oriented OLAP system. It provides ready-to-use patterns for various MergeTree engines, advanced analytical SQL queries—including funnel and cohort analysis—and efficient data ingestion strategies like bulk and streaming inserts. Whether you're building real-time dashboards, complex ETL pipelines, or monitoring system performance, this skill ensures your ClickHouse implementation follows industry best practices for maximum query speed and storage efficiency.

주요 기능

01High-throughput data insertion and ETL/CDC pipeline strategies

020 GitHub stars

03Materialized views for automated real-time data aggregation

04OLAP-specific query optimization and ClickHouse window functions

05Comprehensive performance monitoring and table statistics queries

06Advanced MergeTree engine table design and partitioning patterns

사용 사례

01Optimizing slow SQL queries in existing ClickHouse clusters

02Building real-time analytics dashboards for high-volume event data

03Designing scalable data retention and cohort analysis systems

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add aventerica89/claude-codex clickhouse-io

For use in Claude.ai and ChatGPT

Download Skill