altinity-expert-clickhouse-expert

Diagnose ClickHouse server health issues by analyzing logs, metrics, and query patterns.

42|7|Updated Dec 26, 2025
One-click install
npx skills add https://github.com/ntk148v/clicklens --skill altinity-expert-clickhouse-expert
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: altinity-expert-clickhouse-expert
Source: https://github.com/ntk148v/clicklens/tree/main/.agent/skills/altinity-expert-clickhouse-expert
Command: npx skills add https://github.com/ntk148v/clicklens --skill altinity-expert-clickhouse-expert

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

ClickHouse performance issues and system health problems can be challenging to diagnose quickly. This Skill provides a modular, extensible framework to collect, route, and correlate health data from ClickHouse logs, metrics, and queries to accelerate root-cause analysis.

Core Features & Use Cases

  • System health overview and modular routing to targeted diagnostics
  • Deep-dive analysis across queries, inserts, merges, memory, storage, and replication
  • Guided RCA workflows and multi-module escalation for incident response

Quick Start

Run a general health check with the system entry module, then drill into specific modules to investigate symptoms.

Frequently Asked Questions about altinity-expert-clickhouse-expert

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

FAQPage Schema
How do I diagnose ClickHouse performance issues like ingestion problems and merge delays?

To diagnose ClickHouse performance issues, you can analyze logs, metrics, and query patterns to identify root causes for ingestion problems, merge delays, and replication lag using a modular routing engine.

What is the best way to perform root-cause analysis for ClickHouse server health?

The best way to perform root-cause analysis for ClickHouse server health is to collect and correlate data across predefined modules like memory, storage, caches, and replication to accelerate incident response.

How do I monitor ClickHouse replication lag and mutations?

You can monitor ClickHouse replication lag and mutations by routing diagnostics to specialized modules that analyze query patterns, text logs, and system metrics to identify system health anomalies.

Can I analyze ClickHouse memory and storage usage to find performance bottlenecks?

Yes, you can analyze ClickHouse memory and storage usage to find performance bottlenecks by running deep-dive diagnostics across dedicated modules for caches, schema, and dictionaries.

What should I do when ClickHouse query performance degrades unexpectedly?

When ClickHouse query performance degrades unexpectedly, run a general health check with the system entry module, then drill into specific modules to investigate symptoms like errors or memory pressure.

Does ClickHouse log analysis help identify merge and mutation delays?

Yes, ClickHouse log analysis helps identify merge and mutation delays by correlating text logs with system metrics and query patterns to pinpoint the root cause of the delays.