Does this skill support advanced ClickHouse table engines?

Yes, it includes implementation patterns for the MergeTree family, including ReplacingMergeTree for deduplication and AggregatingMergeTree for pre-calculated metrics.

What is the primary focus of the ClickHouse Claude Code skill?

The skill provides domain-specific guidance for ClickHouse, focusing on table architecture, query optimization for high-performance analytics, and efficient data ingestion patterns.

Can this skill help with data ingestion and ETL?

Absolutely. It provides specific patterns for bulk inserts, streaming data pipelines, and Change Data Capture (CDC) workflows to move data from sources like PostgreSQL to ClickHouse.

How does it help with query performance?

It offers best practices for indexing, filtering on partition keys first, using specialized aggregate functions, and monitoring slow queries via system logs.

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: claudiodearaujo

byclaudiodearaujo

Database Management

Optimizes high-performance analytical workloads using specialized ClickHouse query patterns, table engines, and data engineering best practices.

About

This skill equips Claude with deep domain expertise for architecting and optimizing ClickHouse databases for Online Analytical Processing (OLAP). It provides comprehensive patterns for MergeTree table design, advanced query optimization for real-time analytics, and efficient data ingestion strategies including bulk and streaming inserts. It is particularly useful for developers and data engineers building time-series dashboards, performing complex funnel or cohort analysis, and setting up scalable ETL pipelines that require massive data throughput and sub-second query latency.

Key Features

High-performance query optimization including indexing and filtering strategies
Advanced MergeTree engine patterns for deduplication and pre-aggregation
Pre-built templates for Time Series, Funnel, and Cohort analytics
0 GitHub stars
Real-time aggregation patterns using Materialized Views
Efficient bulk and streaming data insertion implementations in TypeScript

Use Cases

Building real-time analytical dashboards for multi-billion row datasets
Implementing reliable CDC pipelines from relational databases to ClickHouse
Optimizing slow SQL queries and improving data compression in ClickHouse clusters

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/sistema-de-narra-o-de-livro-front cc-skill-clickhouse-io

For use in Claude.ai and ChatGPT

Download Skill

GitHub