Clickhouse Managed Postgres Rca

When your ClickHouse-managed Postgres instance starts crawling, this skill runs a six-step diagnostic workflow that hits two Beta APIs: Prometheus for system gauges like cache hit ratio and active connections, and the Slow Query Patterns endpoint for per-digest latency and IO stats. It triangulates evidence using three built-in heuristics (full scan, N+1 loop, write congestion), then writes up a root cause report with a recommended fix but won't touch your database. The workflow is strict about not hardcoding field names since both APIs are still Beta, so it fetches the OpenAPI spec fresh every session. Nice safety rails for an observability layer that's still moving.

skills.sh installs: 6.8K
GitHub stars: 565
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add clickhouse/agent-skills --skill clickhouse-managed-postgres-rca --agent claude-code

Installs into .claude/skills of the current project.

Files

ClickHouse Managed Postgres RCA

When to use

Trigger whenever a user reports slowness, high CPU, low throughput, cache thrash, or any unexplained pain on a ClickHouse-managed Postgres instance.

What you have access to

Two APIs on https://api.clickhouse.cloud (HTTP Basic auth using a ClickHouse Cloud API key/secret pair):

Prometheus metrics — operation postgresInstancePrometheusGet under the Prometheus tag. Returns Prometheus exposition format. System and workload metrics for one Postgres service.
Slow Query Patterns — operation slowQueryPatternsGetList under the Postgres tag. Returns per-digest latency, IO, and call statistics for normalized query patterns. Beta.

Both endpoints require an organizationId and a serviceId as path parameters. The user must supply both, plus the API key/secret pair.