What data does the ClickHouse Debug Bundle collect?

It gathers comprehensive data from ClickHouse system tables, including system metrics, query logs, merge statuses, disk usage, and replication health.

How does this help with ClickHouse support tickets?

It standardizes the collection of evidence and server state, providing ClickHouse support teams with the exact logs and metrics they need to resolve issues faster.

Do I need specific permissions to use this skill?

Yes, your database user must have read permissions on the system.* tables to successfully pull diagnostic information.

Can I use this for automated health checks?

Absolutely. The skill includes both Bash and Node.js snippets specifically designed for automated collection of diagnostic artifacts.

ClickHouse Debug & Diagnostics

Name: ClickHouse Debug & Diagnostics
Author: jeremylongshore

byjeremylongshore

•

2,027

•

数据库管理

Collects comprehensive ClickHouse diagnostic data, system metrics, and query logs for performance troubleshooting and support escalation.

The ClickHouse Debug Bundle skill provides a structured approach to diagnosing and resolving ClickHouse database issues. It automates the collection of critical information from system tables, including disk usage, merge pressure, slow query patterns, and replication health. Whether you are investigating a sudden performance drop, preparing a support ticket, or monitoring active mutations, this skill provides the SQL queries, Bash scripts, and Node.js code needed to generate a complete diagnostic artifact quickly and efficiently.

主要功能

01Query performance analysis identifying slow and failed queries

02Replication and mutation status tracking for distributed environments

03Disk usage and table health monitoring for merge pressure detection

04Automated collection of ClickHouse system table snapshots

052,027 GitHub stars

06Ready-to-use Bash and Node.js diagnostic scripts for automation

使用场景

01Auditing query patterns and identifying resource-heavy bottlenecks

02Generating a standardized support bundle for ClickHouse troubleshooting

03Investigating disk space exhaustion or excessive merge parts issues

主要功能

01Query performance analysis identifying slow and failed queries

02Replication and mutation status tracking for distributed environments

03Disk usage and table health monitoring for merge pressure detection

04Automated collection of ClickHouse system table snapshots

052,027 GitHub stars

06Ready-to-use Bash and Node.js diagnostic scripts for automation

使用场景

01Auditing query patterns and identifying resource-heavy bottlenecks

02Generating a standardized support bundle for ClickHouse troubleshooting

03Investigating disk space exhaustion or excessive merge parts issues