Clickhouse Managed Postgres Rca
作者 ClickHouse2f6ec4b17a81Apache-2.0544 個星標收錄於 2026年10月8日更新於 2026年10月8日儲存庫9 天前更新
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.
僅公開檔案列表。將技能安裝到工作區後即可檢視檔案內容。
| 路徑 | 大小 | 類型 |
|---|---|---|
| AGENTS.md | 31.9 KB | text/markdown |
| metadata.json | 887 B | application/json |
| README.md | 1.3 KB | text/markdown |
| rules/heuristic-full-scan.md | 2.5 KB | text/markdown |
| rules/heuristic-hot-loop.md | 2.5 KB | text/markdown |
| rules/heuristic-write-congestion.md | 3.1 KB | text/markdown |
| rules/openapi-discovery.md | 6 KB | text/markdown |
| rules/output-template.md | 2.6 KB | text/markdown |
| rules/prometheus-scrape.md | 3.5 KB | text/markdown |
| rules/recommend-only.md | 1.5 KB | text/markdown |
| rules/slow-query-patterns-fields.md | 5.4 KB | text/markdown |
| rules/triage.md | 3.1 KB | text/markdown |
| SKILL.md | 4.8 KB | text/markdown |
來源與署名
來源：ClickHouse/agent-skills位於skills/clickhouse-managed-postgres-rca提交2f6ec4b
授權條款： Apache-2.0
內容歸原作者所有。SourceWeft 從公開儲存庫中收錄這些內容。
更多來自 ClickHouse/agent-skills 的技能
Clickhouse Js Node Troubleshooting
ClickHouse
排查並解決 ClickHouse Node.js 客戶端（@clickhouse/client）的常見錯誤與設定問題。
Clickhouse Best Practices
ClickHouse
依據 31 條最佳實務規則審查 ClickHouse 的結構定義、查詢與寫入策略。
Clickhouse Architecture Advisor
ClickHouse
針對特定工作負載指導 ClickHouse 架構決策，並將每項建議標註為官方、推導或經驗。
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
使用 chdb DataStore 作為 pandas 的替代方案，以 ClickHouse 為底層查詢、合併與彙總表格資料。
更多DevOps & Cloud技能
M5 Onboard
anthropics
透過 USB 偵測 M5Stack ESP32 開發板，燒錄 UIFlow 2.0 韌體並安裝 MicroPython 應用程式套件。
Runbook
anthropics
為重複性任務建立或更新逐步操作手冊，包含疑難排解、回復與升級流程。
Incident Response
anthropics
引導事故回應流程：嚴重程度分級、狀態更新、緩解追蹤，以及無責事後檢討。
Deploy Checklist
anthropics
產生部署前就緒檢查清單，涵蓋部署前、部署、部署後與回復觸發條件。
Spanner Basics
指導 Google Cloud Spanner 的執行個體與資料庫管理、結構定義設計、查詢與效能診斷。
Secops Cases
透過 MCP 工具管理 Google Security Operations SOAR 案件的完整生命週期。