Which ClickHouse table engines are covered?

The skill provides detailed patterns for the most critical engines, including MergeTree, ReplacingMergeTree, and AggregatingMergeTree.

What is the primary focus of the ClickHouse Analytics skill?

It provides specialized guidance and implementation patterns for building high-performance analytical workloads using ClickHouse, focusing on schema design and query optimization.

Can I use this for real-time monitoring?

Absolutely. It covers the use of Materialized Views for real-time aggregations and provides queries for monitoring system performance and slow logs.

Does this skill help with data ingestion?

Yes, it includes specific patterns for both bulk inserts and streaming data ingestion using TypeScript and native ClickHouse SQL commands.

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: claudiodearaujo

byclaudiodearaujo

データベース管理

Optimizes ClickHouse database performance through high-performance schema design, query optimization, and advanced analytical patterns.

概要

This skill empowers developers to leverage ClickHouse's full potential for OLAP workloads by providing specialized patterns for table design, efficient data insertion, and real-time aggregations. It includes comprehensive guidance on MergeTree engines, materialized views for streaming analytics, and performance monitoring techniques to ensure sub-second query execution on massive datasets. Whether you are building real-time dashboards or complex data pipelines, this skill provides the domain-specific best practices needed for high-scale data engineering.

主な機能

Advanced analytics patterns including Funnel and Cohort analysis
Bulk and streaming data insertion strategies
High-performance MergeTree table design patterns
Optimized SQL query patterns for OLAP workloads
0 GitHub stars
Real-time aggregation via Materialized Views

ユースケース

Optimizing slow analytical queries using ClickHouse-specific functions
Building real-time analytics dashboards with sub-second latency
Designing scalable data engineering pipelines for massive datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/izacenter cc-skill-clickhouse-io

For use in Claude.ai and ChatGPT

Download Skill

GitHub

概要