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.
Install
npx skills add ClickHouse/agent-skills --skill clickhouse-managed-postgres-rcanpx skills add ClickHouse/agent-skills --skill clickhouse-managed-postgres-rca -a claude-code -gnpx skills add ClickHouse/agent-skills --skill clickhouse-managed-postgres-rca -a codex -ggemini skills install https://github.com/ClickHouse/agent-skills.git --path skills/clickhouse-managed-postgres-rcagh skill install ClickHouse/agent-skills clickhouse-managed-postgres-rcagit clone --depth 1 https://github.com/ClickHouse/agent-skills /tmp/ClickHouse__agent-skills
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/ClickHouse__agent-skills/skills/clickhouse-managed-postgres-rca ~/.claude/skills/clickhouse-managed-postgres-rca # Claude Code
cp -R /tmp/ClickHouse__agent-skills/skills/clickhouse-managed-postgres-rca ~/.agents/skills/clickhouse-managed-postgres-rca # Codex, Cursor, Gemini CLI, Copilot, OpenCode