clickhouse-managed-postgres-rca

Find the query pattern behind managed Postgres slowdowns.

database performance

What it does

Diagnoses performance issues on ClickHouse-managed Postgres and produces an evidence-based recommendation without applying it.

When to use it

Use when a ClickHouse-managed Postgres instance has slowness, high CPU, low throughput, cache thrash, or unexplained performance trouble.

Give it a performance symptom and the ClickHouse Cloud organization and service IDs; it returns a structured RCA and recommended fix.

What you provide

This skill

/tmp/ch-cloud-rca-cache.json

Write

Writes or clears its API cache (irreversible)

/tmp/ch-cloud-openapi.json

Write

Overwrites a temporary OpenAPI file (irreversible)

/tmp/pg-prom.txt

Write

Overwrites a temporary metrics file (irreversible)

ClickHouse Cloud OpenAPI spec

Read

Reads the live OpenAPI spec

cannot be undone: /tmp/ch-cloud-rca-cache.json; /tmp/ch-cloud-openapi.json; /tmp/pg-prom.txt

Requires an existing ClickHouse-managed Postgres instance whose performance is being investigated.

Requires ClickHouse Cloud API access using an API key and secret.