altinity-expert-clickhouse-ingestion
CommunityOptimize ClickHouse INSERT bottlenecks.
Authorntk148v
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Diagnose and optimize ClickHouse INSERT performance and ingestion pipelines to reduce latency and improve throughput in data-heavy deployments.
Core Features & Use Cases
- INSERT performance diagnostics: identify slow inserts, high memory usage, and long-running queries related to data ingestion.
- Batch sizing & part creation analysis: examine batch sizes, number of parts, and merge pressure to tune ingestion pipelines.
- Ingestion bottleneck identification: correlate logs, MV overhead, and IO/memory metrics to guide targeted fixes.
- Use Case: When ingestion slows down during peak loads, run this skill to surface the root causes and recommended optimizations.
Quick Start
Run the diagnostic to surface slow inserts, batching patterns, and ingestion bottlenecks in ClickHouse.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: altinity-expert-clickhouse-ingestion Download link: https://github.com/ntk148v/clicklens/archive/main.zip#altinity-expert-clickhouse-ingestion Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.