altinity-expert-clickhouse-kafka

Diagnose ClickHouse Kafka engine health and consumer performance across clusters.

16|2|Updated Jan 8, 2026
One-click install
npx skills add https://github.com/Altinity/Skills --skill altinity-expert-clickhouse-kafka
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: altinity-expert-clickhouse-kafka
Source: https://github.com/Altinity/Skills/tree/main/altinity-expert-clickhouse/skills/altinity-expert-clickhouse-kafka
Command: npx skills add https://github.com/Altinity/Skills --skill altinity-expert-clickhouse-kafka

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Diagnose ClickHouse Kafka engine health, consumer status, thread pool capacity, and consumption issues. Use for Kafka lag, consumer errors, and thread starvation.

Core Features & Use Cases

  • Kafka Health Diagnostics: Assess consumer health, partition assignments, and thread pool saturation to identify bottlenecks.
  • Lag & Throughput Analysis: Surface topic/partition lag and consumption speed to guide tuning.
  • Advanced Troubleshooting: Provide guidance for MV impact, rebalance patterns, and broker connection issues with actionable remediation steps.

Quick Start

Run the Kafka health checks against your ClickHouse cluster to surface lag, consumer errors, and thread pool saturation.

Frequently Asked Questions about altinity-expert-clickhouse-kafka

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I diagnose Kafka consumer lag in ClickHouse?

To diagnose Kafka consumer lag in ClickHouse, run health checks that surface topic and partition lag alongside consumption speed. The checks parse rdkafka statistics and assess consumer health to identify throughput bottlenecks.

Why are my ClickHouse Kafka engine consumers not consuming messages?

ClickHouse Kafka engine consumers may stall due to thread pool saturation, consumer errors, or high-rebalance scenarios. Diagnostic checks evaluate thread pool capacity, consumer status, and broker connections to pinpoint the root cause.

How does slow materialized view performance affect ClickHouse Kafka consumption?

Slow materialized views directly impact ClickHouse Kafka consumption by blocking the consumer thread pool and causing lag. Advanced troubleshooting checks identify MV impact and provide actionable remediation steps to restore throughput.

Can I check Kafka thread pool capacity across multiple ClickHouse clusters?

Yes, you can check Kafka thread pool capacity across multiple ClickHouse clusters. The diagnostics assess thread pool saturation and consumer partition assignments cluster-wide to identify capacity bottlenecks.

What is the best way to troubleshoot high rebalance scenarios in ClickHouse Kafka?

The best way to troubleshoot high rebalance scenarios in ClickHouse Kafka is to run advanced checks that analyze rebalance patterns, broker connection issues, and consumer status, surfacing actionable recommendations for stabilization.

Do I need rdkafka_stat enabled to monitor ClickHouse Kafka health?

You do not strictly need rdkafka_stat enabled to monitor ClickHouse Kafka health, but enabling it allows the diagnostics to parse detailed rdkafka statistics for deeper analysis of broker connections and consumer performance.