alibabacloud-cksync-plan — Claude Code skill for ClickHouse migration
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.
no license 145 installs ★ 300 updated 2026-10-23
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a claude-codeWhat alibabacloud-cksync-plan 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.
What it helps with
- 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 for the agent
- 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.
How to install alibabacloud-cksync-plan
1Skills CLI (Vercel)
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a claude-code2Manually: put the files in place
~/.claude/skills/alibabacloud-cksync-plan/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/alibabacloud-cksync-plan/
1Skills CLI (Vercel)
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a codex2Manually: put the files in place
.agents/skills/alibabacloud-cksync-plan/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a cursor2Manually: put the files in place
.cursor/skills/alibabacloud-cksync-plan/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install aliyun/alibabacloud-aiops-skills skills/database/clickhouse/alibabacloud-cksync-plan2Manually: put the files in place
.github/skills/alibabacloud-cksync-plan/SKILL.md1Skills CLI (Vercel)
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a gemini-cli2Platform CLI
gemini skills install https://github.com/aliyun/alibabacloud-aiops-skills --path skills/database/clickhouse/alibabacloud-cksync-planManually: put the files in place
.devin/skills/alibabacloud-cksync-plan/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about alibabacloud-cksync-plan
How do I install alibabacloud-cksync-plan in Claude Code?
Run npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-cksync-plan -a claude-code. The skill file is at ~/.claude/skills/alibabacloud-cksync-plan/SKILL.md.
What does alibabacloud-cksync-plan do?
It gathers source and target ClickHouse cluster details, assesses migration options, and prepares a plan with risks. If details are missing, it still provides a provisional plan with assumptions and follow-up questions.
What table details does the skill need?
It asks for table engines, partition counts, data sizes, and write speeds, along with database names and engines. You can provide the results of SQL queries or use an HTTP connection.