Can I use this for Node.js or TypeScript applications?

Yes, it includes specific code patterns for bulk and streaming data insertion using TypeScript and the ClickHouse client library.

Does it cover real-time data ingestion?

Yes, it includes patterns for Materialized Views for instant aggregation and Change Data Capture (CDC) from sources like PostgreSQL.

How does this skill help with slow queries?

It provides best practices for index-first filtering, efficient aggregation functions like quantiles, and SQL patterns for analyzing the system.query_log to identify bottlenecks.

Which ClickHouse table engines are supported?

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

ClickHouse Optimization & Analytics

Name: ClickHouse Optimization & Analytics
Author: Nixdorfer

byNixdorfer

•

Database Management

Optimizes ClickHouse database performance with advanced table design, query patterns, and real-time analytical workflows.

This skill provides specialized guidance for ClickHouse, a high-performance columnar OLAP database. It helps developers implement best practices for the MergeTree engine family, optimize complex analytical queries, and manage efficient data ingestion. Whether you are building real-time dashboards or processing massive datasets, this skill offers implementation patterns for materialized views, performance monitoring, and advanced analysis like cohort and funnel tracking, ensuring your data engineering is both scalable and cost-effective.

Key Features

01High-performance bulk and streaming data insertion methods

021 GitHub stars

03System-level performance monitoring and slow query analysis

04Advanced MergeTree and AggregatingMergeTree table design

05Materialized view patterns for real-time data aggregation

06Query optimization using primary keys and indexing

Use Cases

01Performing complex time-series, retention, and funnel analysis

02Building real-time analytical dashboards for large-scale event data

03Designing high-throughput ETL and CDC pipelines into ClickHouse

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nixdorfer/claudecodetool clickhouse-io

For use in Claude.ai and ChatGPT

Download Skill