clickhouse-debug-bundle

Featured

Collect ClickHouse diagnostic data — system tables, query logs, merge status, and server metrics for support tickets and troubleshooting. Use when investigating persistent issues, preparing debug artifacts, or collecting evidence for ClickHouse support. Trigger: "clickhouse debug", "clickhouse diagnostics", "clickhouse support bundle", "collect clickhouse logs", "clickhouse system tables".

AI & Automation 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# ClickHouse Debug Bundle ## Overview Collect comprehensive diagnostic data from ClickHouse system tables for troubleshooting performance issues, merge problems, or support escalation. ## Prerequisites - Access to ClickHouse with `system.*` table read permissions - `curl` or `clickhouse-client` available ## Instructions ### Step 1: Server Health Overview ```sql -- Server version and uptime SELECT version() AS version, uptime() AS uptime_seconds, formatReadableTimeDelta(uptime()) AS uptime_human, currentDatabase() AS current_db; -- Global metrics snapshot SELECT metric, value, description FROM system.metrics WHERE metric IN ( 'Query', 'Merge', 'PartMutation', 'ReplicatedFetch', 'TCPConnection', 'HTTPConnection', 'MemoryTracking', 'BackgroundMergesAndMutationsPoolTask' ); ``` ### Step 2: Disk and Table Health ```sql -- Disk usage by table (top 20) SELECT database, table, formatReadableSize(sum(bytes_on_disk)) AS disk_size, sum(rows) AS total_rows, count() AS active_parts, max(modification_time) AS last_modified FROM system.parts WHERE active GROUP BY database, table ORDER BY sum(bytes_on_disk) DESC LIMIT 20; -- Tables with too many parts (merge pressure) SELECT database, table, count() AS parts FROM system.parts WHERE active GROUP BY database, table HAVING parts > 100 ORDER BY pa...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category