AgentSkillsCN

altinity-expert-clickhouse-replication

诊断 ClickHouse 的复制健康状况、Keeper 连接性、副本延迟以及队列问题。适用于解决复制延迟及只读副本相关问题。

SKILL.md
--- frontmatter
name: altinity-expert-clickhouse-replication
description: Diagnose ClickHouse replication health, Keeper connectivity, replica lag, and queue issues. Use for replication lag and read-only replica problems.

Workflow

Read files below run queries and analyse results:

  • triage.sql
  • queue.sql
  • mutations.sql
  • keeper.sql
  • fetches.sql
  • ddl.sql
  • health.sql

Schema-safe rule

If a query fails with UNKNOWN_IDENTIFIER, run DESCRIBE TABLE system.<table> and drop/adjust only the missing columns.