Clickhouse Managed Postgres Rca
by ClickHouse2f6ec4b17a81Apache-2.0544 starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated 9 days ago
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.
Add to a SourceWeft workspace
- Open the skill in your dashboard and add it to a workspace.
- Enable it for the chats that should use it.
This skill is instructions only: it ships no scripts to execute.
Add to SourceWeftYou will be asked to sign in first, then taken straight to this skill.
Ask your agent to install it
Paste this prompt into Claude Code, Codex, Cursor or another agent that can run commands — or into SourceWeft chat. The agent reads this skill's install guide, shows you its source, license and scripts, and installs it with the SourceWeft CLI once you agree.
Read https://sourceweft.com/skills/gh-clickhouse-agent-skills-clickhouse-managed-postgres-rca/install.md and install the skill it describes. Before installing, show me its source, license and whether it ships scripts, and wait for my OK. Ask me before changing anything else on my machine.Install it yourself from a terminal
For Claude Code, Codex, Cursor and other local agents. The SourceWeft CLI fetches the skill from its source repository at the commit scanned here, and verifies every file against the hashes recorded when the skill was scanned. If anything differs, nothing is written.
npx @sourceweft/cli skills install gh-clickhouse-agent-skills-clickhouse-managed-postgres-rcaAdd --agent claude-code, codex, cursor or universal to choose which agent gets it (Claude Code by default).
Upstream installer — not verified by SourceWeft
The open-source skills installer fetches the same pinned commit, but does not check the files against the hashes SourceWeft recorded.
npx skills add https://github.com/ClickHouse/agent-skills/tree/2f6ec4b17a81a435dd116f9ac19d7b45d44dbd61/skills/clickhouse-managed-postgres-rcaSource and attribution
Source:ClickHouse/agent-skillsinskills/clickhouse-managed-postgres-rcaat commit2f6ec4b
License: Apache-2.0
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from ClickHouse/agent-skills
Clickhouse Js Node Troubleshooting
ClickHouse
Troubleshoots common errors and configuration issues with the ClickHouse Node.js client (@clickhouse/client).
Clickhouse Best Practices
ClickHouse
Reviews ClickHouse schemas, queries, and ingestion strategies against 31 documented best-practice rules.
Clickhouse Architecture Advisor
ClickHouse
Guides ClickHouse architecture decisions for specific workloads, labeling each recommendation as official, derived, or field.
Chdb Sql
ClickHouse
Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) without setting up a server. Provides chDB — embedded ClickHouse SQL in Python with 1000+ functions, Session for stateful multi-step pipelines, parametrized queries, and cross-source joins via `s3()`, `mysql()`, `postgresql()`, `iceberg()`, `deltaLake()`, `remoteSecure()` table functions. TRIGGER when: user wants SQL on parquet/csv/files or across remote analytical sources; uses ClickHouse SQL features (window functions, windowFunnel, geoToH3, JSON path ops, Session, parametrized queries); imports `chdb` or calls `chdb.query()`. SKIP this skill for pandas-style DataFrame method-chaining (use chdb-datastore instead) or ClickHouse server administration.
Chdb Datastore
ClickHouse
Use chdb DataStore as a drop-in, ClickHouse-backed replacement for pandas to query, join and aggregate tabular data.
More in DevOps & Cloud
M5 Onboard
anthropics
Provisions M5Stack ESP32 boards by detecting them on USB, flashing UIFlow 2.0 firmware, and installing a MicroPython app bundle.
Spanner Basics
Guides Google Cloud Spanner administration, schema design, querying and performance diagnosis.
Secops Cases
Manages Google Security Operations SOAR cases across their lifecycle via MCP tools.
Managed Airflow Migrations
Guides migration of Apache Airflow DAGs to Airflow 2.11.1 or Airflow 3 in Managed Service for Apache Airflow.
Managed Airflow Dag Troubleshooting
Guides deterministic troubleshooting of failed Managed Service for Apache Airflow DAG runs and task instances using gcloud commands.
Iam Helper For Privileged Access Management
Guides Google Cloud Privileged Access Manager entitlement CRUD, temporary access requests, and grant approval workflows.