# alibabacloud-cksync-plan

The alibabacloud-cksync-plan skill gathers cluster details and drafts a ClickHouse migration plan based on versions, read-only limits, and risks. Use it when moving data or changing cluster layout.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 145 installs · ★ 300 repo stars
- Author: aliyun
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/aliyun/alibabacloud-aiops-skills/tree/HEAD/skills/database/clickhouse/alibabacloud-cksync-plan/SKILL.md
- Updated: 2026-10-23
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/alibabacloud-cksync-plan

## What it does

The skill compares migration approaches for ClickHouse clusters, including `cksync`, `BACKUP/RESTORE`, `INSERT FROM REMOTE`, and double-write strategies. It asks about the source and target cluster types, the source version, and the acceptable read-only window. Horizontal scaling and availability-zone changes are also covered.

Before recommending a method, it requires database and table details: engines, partition counts, data sizes, and write speeds. You can supply results from SQL queries or connect over HTTP with an endpoint, port, and credentials. A method cannot be selected responsibly until the table metadata is collected; handle the password securely.

The skill produces one migration plan with risks and next steps. When details are incomplete, it still gives a provisional plan with assumptions, open questions, and a confidence level. `BACKUP/RESTORE` requires ClickHouse version `22.8` or later, while incremental `cksync` migration requires a target version of at least `20.8`.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/alibabacloud-cksync-plan/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/alibabacloud-cksync-plan/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/alibabacloud-cksync-plan/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/alibabacloud-cksync-plan/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install aliyun/alibabacloud-aiops-skills skills/database/clickhouse/alibabacloud-cksync-plan
```

2. **Manually: put the files in place**
- File: `.github/skills/alibabacloud-cksync-plan/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/aliyun/alibabacloud-aiops-skills --path skills/database/clickhouse/alibabacloud-cksync-plan
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/alibabacloud-cksync-plan/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/aliyun/alibabacloud-aiops-skills/tree/HEAD/skills/database/clickhouse/alibabacloud-cksync-plan/SKILL.md

## When to use it
- choose a migration approach between ClickHouse clusters
- check version and table-engine constraints before migration
- account for an allowed read-only window when selecting a method
- plan horizontal scaling or an availability-zone change
- record migration risks and information still needed

## Example prompts
- Draft a plan for moving our ClickHouse data to Alibaba Cloud, and ask me for the details needed to choose a method.
- Compare migration options using the cluster version and our allowed read-only window.
- Create a provisional migration plan and list its assumptions and open questions.

## Similar
- [clickhouse-cloud-management](https://affpapa.org/en/nevibecode/skills/clickhouse-cloud-management.md) — skill · 126 installs
- [clickhouse-best-practices](https://affpapa.org/en/nevibecode/skills/clickhouse-best-practices.md) — skill · 23400 installs
- [clickhouse-js-node-troubleshooting](https://affpapa.org/en/nevibecode/skills/clickhouse-js-node-troubleshooting.md) — skill · 7900 installs
- [clickhouse-architect](https://affpapa.org/en/nevibecode/skills/clickhouse-architect.md) — skill · 157 installs
- [clickhouse-query](https://affpapa.org/en/nevibecode/skills/clickhouse-query.md) — skill · ★ 7327 repo stars
- [DB Connect MCP](https://affpapa.org/en/nevibecode/mcp/db-connect-mcp.md) — MCP server · ★ 6 repo stars

From the same set: [aliyun/alibabacloud-aiops-skills](https://affpapa.org/en/nevibecode/by/aliyun/alibabacloud-aiops-skills.md) — 66 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
