skills.rest
ntk148v
ntk148vCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

altinity-expert-clickhouse-overview

Diagnose ClickHouse deployment health with SQL queries and metric aggregation.

42|7|Updated Dec 26, 2025
Search Tags:#performance#diagnostics#health-check#clickhouse#audits#system-monitoring#database-ops
One-click install
npx skills add https://github.com/ntk148v/clicklens --skill altinity-expert-clickhouse-overview
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: altinity-expert-clickhouse-overview
Source: https://github.com/ntk148v/clicklens/tree/main/.agent/skills/altinity-expert-clickhouse-overview
Command: npx skills add https://github.com/ntk148v/clicklens --skill altinity-expert-clickhouse-overview

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Identifies system health issues and readiness gaps in ClickHouse deployments by collecting key host, version, uptime, memory, disk, and replication metrics for actionable insights.

Core Features & Use Cases

  • System identification queries surface hostname, version, uptime, and OS memory.
  • Resource utilization and disk health checks across RAM, disks, and memory usage.
  • Comprehensive health audits and readiness reviews with module routing recommendations.

Quick Start

Run the system health overview to generate a snapshot for your ClickHouse deployment.

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 perform a health check on my ClickHouse cluster?▼

Perform a ClickHouse health check by running structured SQL diagnostic queries that aggregate hostname, version, uptime, memory, disk, and replication metrics. This surfaces system readiness gaps and resource utilization data to guide remediation.

What metrics are included in a ClickHouse system audit?▼

A ClickHouse system audit includes hostname, version, uptime, OS memory, RAM utilization, disk health, active parts, queries, and replication status. These metrics provide a comprehensive snapshot of deployment readiness.

How can I quickly assess ClickHouse resource utilization for production deployments?▼

Assess ClickHouse resource utilization by executing a health overview that checks RAM, disk usage, and memory consumption. It provides a quick snapshot of server resource allocation and active object counts for production clusters.

Does this health diagnostic approach work for ongoing ClickHouse status reviews?▼

Yes, this approach works for ongoing ClickHouse status reviews and audits. It implements a structured SQL-based health checklist applicable to production clusters for continuous monitoring and quick readiness assessments.

What is the best way to identify replication issues in ClickHouse?▼

Identify ClickHouse replication issues by running diagnostic queries that aggregate replication status metrics. The health checklist surfaces replication state alongside system uptime and active parts to guide targeted remediation.

Related Skills

Explore More Software Engineering Skills→
robomotioniorobomotionio
2

clickhouse

Execute analytical SQL queries and batch transactions against ClickHouse from Robomotion.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-metrics

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

Official
Advanced
micaelmaltamicaelmalta
1

performance

Profile code and record baseline metrics to identify performance bottlenecks.

Community
Intermediate
duyetduyet

clickhouse-monitoring

Monitor ClickHouse clusters through the ClickHouse Monitor dashboard.

Community
Advanced