skills.rest
duyet
duyetCOMMUNITY
Explore all skills by this author →
Website𝕏@_duyetGitHub

clickhouse-monitoring

Monitor ClickHouse clusters through the ClickHouse Monitor dashboard.

Updated Mar 13, 2026
Search Tags:#performance#monitoring#database#observability#sql#clickhouse
One-click install
npx skills add https://github.com/duyet/skills --skill clickhouse-monitoring
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: clickhouse-monitoring
Source: https://github.com/duyet/skills/tree/main/clickhouse-monitoring
Command: npx skills add https://github.com/duyet/skills --skill clickhouse-monitoring

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides specialized knowledge for monitoring ClickHouse clusters, enabling users to analyze query performance, manage tables, and understand system metrics.

Core Features & Use Cases

  • Real-time Monitoring: Track active queries, merge operations, and system resource usage.
  • Performance Analysis: Dive deep into query logs, identify bottlenecks, and optimize performance.
  • Table & Schema Management: Browse databases, tables, columns, and understand replication status.
  • Use Case: When a ClickHouse query is running slow, use this Skill to inspect its progress, resource consumption, and identify potential issues in the query plan or table structure.

Quick Start

Use the clickhouse-monitoring skill to view the status of running queries on host 0.

Frequently Asked Questions about clickhouse-monitoring

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

FAQPage Schema
How do I monitor ClickHouse query performance in real-time?▼

Monitor ClickHouse query performance by tracking active queries, analyzing query logs, and observing system resource usage to identify bottlenecks. This enables real-time cluster observability and helps optimize slow-running SQL operations.

What system metrics are available for ClickHouse observability?▼

ClickHouse observability includes system metrics for active queries, merge operations, and system resource consumption. You can observe these metrics to track cluster health, understand replication status, and analyze overall performance.

How do I inspect a slow ClickHouse query and identify bottlenecks?▼

Inspect slow ClickHouse queries by diving deep into query logs and examining resource consumption. This helps identify potential issues in the query plan or table structure, allowing you to optimize performance effectively.

Can I manage ClickHouse tables and view replication status?▼

Yes, you can manage ClickHouse tables by browsing databases, tables, and columns. The Skill also allows you to understand replication status and perform table management alongside merge operation monitoring.

Does ClickHouse monitoring work across different database versions?▼

ClickHouse monitoring covers version compatibility for effective cluster observability. This ensures you can track system metrics, query progress, and table management operations across compatible ClickHouse versions.

Related Skills

Explore More Software Engineering Skills→
alex-quan-001alex-quan-001

o11y-data-export

Automate TiDB Cloud observability data exports to S3 storage.

Community
Intermediate
kevinnguyen271090kevinnguyen271090
15

databases

Design and optimize MongoDB and PostgreSQL databases for schema, queries, and performance.

Community
Intermediate
interflownexinterflownex
2

cloud-sql-postgres-monitor

Analyze PostgreSQL performance on Google Cloud SQL using PromQL and pg_stat_activity.

Community
Advanced
AltinityAltinity
16

altinity-expert-clickhouse-metrics

Monitor ClickHouse metrics, events, and asynchronous metrics via SQL checks.

Official
Advanced