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 案例的整个生命周期。