How do I install the Altinity Expert Clickhouse Metrics skill?

Run npx skillmds@latest add altinity/altinity-expert-clickhouse-metrics in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Altinity Expert Clickhouse Metrics safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Altinity Expert Clickhouse Metrics?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Altinity Expert Clickhouse Metrics free to use?

Yes. Installing skills from SkillMD is free. This skill is licensed under Apache-2.

Who published Altinity Expert Clickhouse Metrics?

altinity (@altinity) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Altinity Expert Clickhouse Metrics by altinity

Name: Altinity Expert Clickhouse Metrics
Author: altinity

File contents

Real-Time Metrics Monitoring

Real-time monitoring of ClickHouse metrics, events, and asynchronous metrics.

Diagnostics

Run all queries from checks.sql in this skill's directory and analyze the results.

Ad-Hoc Query Guidelines

Key Tables

system.metrics - Current gauge values
system.events - Cumulative counters since restart
system.asynchronous_metrics - System-level metrics
system.metric_log - Historical metrics
system.asynchronous_metric_log - Historical async metrics

Useful Patterns

-- Find metrics by pattern
select * from system.metrics where metric like '%pattern%'
select * from system.asynchronous_metrics where metric like '%pattern%'
select * from system.events where event like '%pattern%'

Cross-Module Triggers

Finding	Load Module	Reason
High memory metrics	`altinity-expert-clickhouse-memory`	Memory analysis
High replica delay	`altinity-expert-clickhouse-replication`	Replication issues
High parts count	`altinity-expert-clickhouse-merges`	Merge backlog
High load average	`altinity-expert-clickhouse-reporting`	Query analysis
High connections	`altinity-expert-clickhouse-reporting`	Connection analysis

Monitoring Recommendations

Key Metrics to Alert On

Metric	Warning	Critical
`ReadonlyReplica`	-	> 0
`Query`	> 75% max	> 90% max
`MemoryResident`	> 80% RAM	> 90% RAM
`MaxPartCountForPartition`	> parts_to_delay	> parts_to_throw
`ReplicasMaxAbsoluteDelay`	> 5 min	> 1 hour
`LoadAverage1`	> CPU count	> 2x CPU count

Prometheus/Grafana Export

ClickHouse exposes metrics at :9363/metrics in Prometheus format when enabled.

---name: altinity-expert-clickhouse-metricsdescription: Real-time monitoring of ClickHouse metrics, events, and asynchronous metrics. Use for load average, connections, queue monitoring, and resource saturation.license: Apache-2.0---# Real-Time Metrics MonitoringReal-time monitoring of ClickHouse metrics, events, and asynchronous metrics.---## DiagnosticsRun all queries from `checks.sql` in this skill's directory and analyze the results.---## Ad-Hoc Query Guidelines### Key Tables- `system.metrics` - Current gauge values- `system.events` - Cumulative counters since restart- `system.asynchronous_metrics` - System-level metrics- `system.metric_log` - Historical metrics- `system.asynchronous_metric_log` - Historical async metrics### Useful Patterns```sql-- Find metrics by patternselect * from system.metrics where metric like '%pattern%'select * from system.asynchronous_metrics where metric like '%pattern%'select * from system.events where event like '%pattern%'```---## Cross-Module Triggers| Finding | Load Module | Reason ||---------|-------------|--------|| High memory metrics | `altinity-expert-clickhouse-memory` | Memory analysis || High replica delay | `altinity-expert-clickhouse-replication` | Replication issues || High parts count | `altinity-expert-clickhouse-merges` | Merge backlog || High load average | `altinity-expert-clickhouse-reporting` | Query analysis || High connections | `altinity-expert-clickhouse-reporting` | Connection analysis |---## Monitoring Recommendations### Key Metrics to Alert On| Metric | Warning | Critical ||--------|---------|----------|| `ReadonlyReplica` | - | > 0 || `Query` | > 75% max | > 90% max || `MemoryResident` | > 80% RAM | > 90% RAM || `MaxPartCountForPartition` | > parts_to_delay | > parts_to_throw || `ReplicasMaxAbsoluteDelay` | > 5 min | > 1 hour || `LoadAverage1` | > CPU count | > 2x CPU count |### Prometheus/Grafana ExportClickHouse exposes metrics at `:9363/metrics` in Prometheus format when enabled.

Frequently asked questions

Altinity Expert Clickhouse Metrics