skills.rest
Altinity
AltinityOFFICIAL
Explore all skills by this author →
WebsiteGitHub

altinity-expert-clickhouse-overview

Aggregate ClickHouse health data by executing predefined SQL system queries.

16|2|Updated Jan 8, 2026
Search Tags:#performance#monitoring#reporting#health#clickhouse#db-analysis#system-queries
One-click install
npx skills add https://github.com/Altinity/Skills --skill altinity-expert-clickhouse-overview-altinity
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: altinity-expert-clickhouse-overview
Source: https://github.com/Altinity/Skills/tree/main/altinity-expert-clickhouse/skills/altinity-expert-clickhouse-overview
Command: npx skills add https://github.com/Altinity/Skills --skill altinity-expert-clickhouse-overview-altinity

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a rapid overview of ClickHouse server health by running a curated set of checks that surface critical issues and health indicators.

Core Features & Use Cases

  • Predefined SQL checks to assess memory usage, disk health, replication status, active queries, and system logs.
  • Consolidated health summary with actionable insights and routing suggestions for remediation.
  • Use Case: quickly verify cluster health before maintenance windows or after deployment to ensure no obvious bottlenecks or failures.

Quick Start

Run the health overview of your ClickHouse server using the built-in checks.

Frequently Asked Questions about altinity-expert-clickhouse-overview

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

FAQPage Schema
How do I check ClickHouse server health and performance issues?▼

Check ClickHouse health by running predefined system queries that analyze memory usage, disk space, replication status, active queries, logs, and DDL queue to produce a consolidated risk summary.

What is the best way to monitor ClickHouse cluster health before maintenance?▼

Monitor ClickHouse cluster health by executing curated SQL checks against system tables to surface critical bottlenecks, ensuring no obvious failures exist before deployment or maintenance windows.

Does this ClickHouse health check work for both single-node and cluster deployments?▼

Yes, this ClickHouse health check is applicable to both single-node and cluster deployments, aggregating system table data to compute risk severities across your environment.

Can I use predefined SQL templates to analyze ClickHouse memory and disk usage?▼

Yes, you can use included SQL templates from checks.sql and metrics.sql to query system tables and analyze ClickHouse memory usage, disk health, and replication status.

How do I detect ClickHouse replication issues and DDL queue bottlenecks?▼

Detect ClickHouse replication issues and DDL queue bottlenecks by running predefined system queries that read system tables to compute risk severities and surface critical health indicators.

Why does my ClickHouse server show high memory usage during active queries?▼

High ClickHouse memory usage during active queries is surfaced by running predefined system checks that analyze memory, active queries, and system logs to identify potential health risks.

Related Skills

Explore More Data & Analytics Skills→
AltinityAltinity
16

altinity-expert-clickhouse-replication

Diagnose ClickHouse replication health with SQL scripts against system tables.

Official
Intermediate
acmelemeacmeleme

notification-routing

Route agent notifications by type to dedicated team channels.

Official
Intermediate
duyetduyet

clickhouse-monitoring

Monitor ClickHouse clusters through the ClickHouse Monitor dashboard.

Community
Advanced
IldarMinaevIldarMinaev
1

postgresql-troubleshooting-sql

Run SQL scripts to diagnose PostgreSQL health, replication, storage, and query performance.

Community
Advanced