clickhouse-managed-postgres-rca
MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance. Provides an evidence-based RCA workflow…
What it does
- Prometheus metrics — operation postgresInstancePrometheusGet
- Slow Query Patterns — operation slowQueryPatternsGetList
- Query plans / EXPLAIN output.
- Per-table scan-type counters (seqscan / idxscan).
- Autovacuum or last-ANALYZE timestamps.
- postgresInstancePrometheusGet (Prometheus tag)
- slowQueryPatternsGetList (Postgres tag)
Requirements & configuration
- using a ClickHouse Cloud API key/secret pair):
- Both endpoints require an organizationId and a serviceId as
- You're after gauges (current values) that don't need a delta:
- on its own. These don't need rate-of-change.
Configuration: AGENTS
Derived from the skill's own SKILL.md documentation · extracted 2026-07-23
MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance. Provides an evidence-based RCA workflow that scrapes the Prometheus endpoint for system signal, pulls per-digest evidence from the Slow Query Patterns API, and recommends (does not apply) a fix.
Source
Repository: https://github.com/clickhouse/agent-skills
clickhouse-managed-postgres-rca FAQ
What does the clickhouse-managed-postgres-rca skill do?
MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance. Provides an evidence-based RCA workflow that scrapes the Prometheus endpoint for system signal, pulls per-digest evidence from the Slow Query Patterns API, and recommends (does not apply) a fix. Prometheus metrics — operation postgresInstancePrometheusGet Slow Query Patterns — operation slowQueryPatternsGetList
What does clickhouse-managed-postgres-rca require?
using a ClickHouse Cloud API key/secret pair): Both endpoints require an organizationId and a serviceId as You're after gauges (current values) that don't need a delta: on its own. These don't need rate-of-change. Configuration keys: AGENTS.
How do I install clickhouse-managed-postgres-rca?
Run: npx -y skills add https://github.com/clickhouse/agent-skills --skill clickhouse-managed-postgres-rca --agent claude-code — the source lives at github.com/clickhouse/agent-skills.
Maintain clickhouse-managed-postgres-rca?
Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.
[clickhouse-managed-postgres-rca on getagentictools](https://getagentictools.com/skills/clickhouse-agent-skills-clickhouse-managed-postgres-rca?ref=badge) npx agentictools info skills/clickhouse-agent-skills-clickhouse-managed-postgres-rca The second line is the CLI lookup for this page — handy in READMEs and docs.
