← All skills

clickhouse-managed-postgres-rca

95 / 100 · Low risk

Fine to try.

By ClickHouse/agent-skills (GitHub) · coding · 565 stars · scanned at commit d3b2b5b

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.

Works with any agent that supports SKILL.md skills.

What this skill can do

Install

Paste this into your terminal. It downloads exactly the version we scanned, not whatever is newest.

if [ -e ~/.agents/skills/'clickhouse-managed-postgres-rca' ] || [ -L ~/.agents/skills/'clickhouse-managed-postgres-rca' ]; then echo 'A skill folder named clickhouse-managed-postgres-rca already exists — not replacing it' >&2; false; else d=$(mktemp -d) && git clone --quiet --filter=blob:none --no-checkout 'https://github.com/ClickHouse/agent-skills' "$d" && git -C "$d" checkout --quiet 'd3b2b5ba43a8b80c2d08858b68d53edc701b5ace' -- 'skills/clickhouse-managed-postgres-rca' && mkdir -p ~/.agents/skills && cp -R "$d"/'skills/clickhouse-managed-postgres-rca' ~/.agents/skills/'clickhouse-managed-postgres-rca' && rm -rf "$d"; fi

Codex reads ~/.agents/skills directly. For Claude Code, Cursor, Copilot, Gemini CLI, Antigravity or OpenCode, also link it. For Claude Code: ln -s ~/.agents/skills/'clickhouse-managed-postgres-rca' ~/.claude/skills/'clickhouse-managed-postgres-rca' (other agents: ~/.cursor/skills, ~/.copilot/skills, ~/.gemini/skills, ~/.gemini/config/skills, ~/.config/opencode/skills). Or install through the finder skill, which does both.

Badge for your README

The badge for ClickHouse/agent-skills shows the score of its lowest-scoring skill.

[![SkillTrust](https://zalavijaysinh.github.io/skilltrust/badges/ClickHouse/agent-skills.svg)](https://zalavijaysinh.github.io/skilltrust/repos/ClickHouse/agent-skills/)

Score history