Does this skill help with data ingestion?

Yes, it covers best practices for bulk inserts and streaming data pipelines to avoid the performance pitfalls of small, frequent individual inserts.

How can I optimize slow analytical queries?

It provides patterns for utilizing indexed columns first, leveraging partition pruning, and using ClickHouse-specific aggregation functions like uniq and quantile for maximum efficiency.

Which table engine does this skill recommend for ClickHouse?

The skill primarily focuses on the MergeTree family (including ReplacingMergeTree and AggregatingMergeTree) as it is the most powerful engine for high-performance production workloads.

How do I monitor ClickHouse performance with this skill?

It provides SQL snippets to query system tables like system.query_log and system.parts to identify slow queries and monitor disk usage.

Can I use this for real-time dashboarding?

Absolutely. It includes specific patterns for creating Materialized Views that perform real-time aggregations as data is ingested.

ClickHouse Optimization & Data Engineering

Name: ClickHouse Optimization & Data Engineering
Author: Infopibe

byInfopibe

•

Database Management

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

This skill provides expert-level guidance for managing ClickHouse, a high-performance column-oriented OLAP database. It helps developers design efficient schemas using the MergeTree engine family, write optimized analytical queries with advanced aggregations, and implement robust data ingestion pipelines. Whether you are migrating from relational databases like PostgreSQL, setting up real-time monitoring dashboards, or troubleshooting slow query performance, this skill offers the specific patterns and best practices needed to handle massive datasets with sub-second latency.

Key Features

01Real-time aggregation implementation using Materialized Views

02High-performance analytical query optimization and window functions

03Bulk and streaming data ingestion patterns for high throughput

041 GitHub stars

05Advanced MergeTree engine selection and table schema design

06Performance monitoring and slow query analysis via system logs

Use Cases

01Building real-time analytics dashboards and time-series data platforms

02Migrating large-scale analytical workloads from PostgreSQL or MySQL to ClickHouse

03Optimizing data engineering pipelines for massive-scale batch and stream processing

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add infopibe/everything-claude-code clickhouse-io

For use in Claude.ai and ChatGPT

Key Features

01Real-time aggregation implementation using Materialized Views

02High-performance analytical query optimization and window functions

03Bulk and streaming data ingestion patterns for high throughput

041 GitHub stars

05Advanced MergeTree engine selection and table schema design

06Performance monitoring and slow query analysis via system logs

Use Cases

01Building real-time analytics dashboards and time-series data platforms

02Migrating large-scale analytical workloads from PostgreSQL or MySQL to ClickHouse

03Optimizing data engineering pipelines for massive-scale batch and stream processing

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add infopibe/everything-claude-code clickhouse-io

For use in Claude.ai and ChatGPT