What table engines are covered?

The skill provides detailed implementation guides for MergeTree, ReplacingMergeTree, and AggregatingMergeTree engines, explaining when to use each for deduplication or pre-aggregation.

Does it support real-time data ingestion?

Absolutely, the skill covers both bulk insert strategies and streaming patterns using Kafka or custom TypeScript/Node.js ingestion scripts.

How does this skill help with ClickHouse performance?

It provides specific patterns for index selection, partition pruning, and column-oriented query optimization to ensure sub-second response times on billions of rows.

Can it assist with data migration?

Yes, it includes best practices and code patterns for migrating data from traditional RDBMS like PostgreSQL to ClickHouse's column-oriented architecture.

ClickHouse Analytics & Data Engineering

Name: ClickHouse Analytics & Data Engineering
Author: nbossn

bynbossn

0•

데이터베이스 관리

Optimizes ClickHouse database schemas and analytical queries for high-performance OLAP workloads and data engineering.

This skill provides specialized guidance for implementing high-performance analytical systems using ClickHouse. It equips Claude with the expertise to design efficient table schemas using MergeTree engines, write optimized SQL for complex aggregations and window functions, and implement robust data ingestion pipelines. Whether you are migrating from traditional relational databases or building real-time dashboards, this skill ensures best practices in partitioning, indexing, and materialized views to minimize query latency and maximize throughput on massive datasets.

주요 기능

01Advanced analytical query implementation including funnel and cohort analysis

02Schema design for MergeTree and specialized engines

03High-throughput batch and streaming ingestion patterns

040 GitHub stars

05Query optimization using projections and materialized views

06Performance monitoring and system table diagnostics

사용 사례

01Migrating analytical workloads from PostgreSQL or MySQL to ClickHouse

02Designing real-time monitoring dashboards with low-latency requirements

03Building large-scale ETL pipelines for big data analytics

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nbossn/claude-code-base clickhouse-io

For use in Claude.ai and ChatGPT

주요 기능

01Advanced analytical query implementation including funnel and cohort analysis

02Schema design for MergeTree and specialized engines

03High-throughput batch and streaming ingestion patterns

040 GitHub stars

05Query optimization using projections and materialized views

06Performance monitoring and system table diagnostics

사용 사례

01Migrating analytical workloads from PostgreSQL or MySQL to ClickHouse

02Designing real-time monitoring dashboards with low-latency requirements

03Building large-scale ETL pipelines for big data analytics

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nbossn/claude-code-base clickhouse-io

For use in Claude.ai and ChatGPT