What is the primary focus of this ClickHouse skill?

It focuses on high-performance analytical processing (OLAP), providing best practices for schema design, query optimization, and efficient data ingestion.

Which ClickHouse table engines does this skill cover?

It provides patterns for the MergeTree family, including ReplacingMergeTree for deduplication and AggregatingMergeTree for pre-aggregation.

How does it help with query performance?

It provides specific guidance on column-first filtering, efficient aggregation functions like uniq() and quantile(), and the use of Materialized Views for pre-calculation.

Can this skill help with real-time data ingestion?

Yes, it includes patterns for both bulk inserts and streaming data ingestion using Node.js, as well as CDC patterns from sources like PostgreSQL.

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: claudiodearaujo

byclaudiodearaujo

Gestión de Bases de Datos

Optimizes ClickHouse database performance through high-performance schema design, analytical query patterns, and efficient data engineering practices.

Acerca de

This skill provides a comprehensive set of ClickHouse-specific patterns and best practices for developers building high-performance analytical systems. It covers critical areas such as table engine selection (MergeTree, ReplacingMergeTree), materialized view implementation for real-time aggregations, and advanced query optimization techniques like column-first filtering and specialized aggregation functions. Whether you're building a real-time analytics dashboard or a complex ETL pipeline, this skill guides Claude in implementing efficient, scalable ClickHouse solutions that leverage the full power of columnar storage.

Características Principales

0 GitHub stars
Real-time data aggregation strategies using Materialized Views and state/merge functions
Efficient data ingestion patterns for bulk and streaming workloads using Node.js
High-performance analytical query optimization using ClickHouse-specific functions
Specialized table engine design patterns for MergeTree, ReplacingMergeTree, and AggregatingMergeTree
Performance monitoring techniques for query logs and table statistics

Casos de Uso

Building scalable ETL/CDC pipelines to sync data from transactional databases to ClickHouse
Designing high-throughput OLAP schemas for financial or market data analytics
Implementing real-time conversion funnels and user retention dashboards

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