Summary
This codifies the migration patterns for ClickHouse databases, specifically the rules around sharded versus replicated tables, node roles, and table engines. You'll want this when you're working on a PostHog-style setup or any complex ClickHouse deployment where you need to coordinate migrations across clusters. The key thing it enforces is avoiding the ON CLUSTER clause and always using IF EXISTS guards, which prevents the kind of race conditions that'll wreck distributed database migrations. It's opinionated about structure, which is good because ClickHouse migration footguns are real. The cheat sheet format makes it fast to reference whether you need NodeRole.DATA or NodeRole.INGESTION_SMALL without digging through docs.
Install to Claude Code
npx -y skills add posthog/posthog --skill clickhouse-migrations --agent claude-codeInstalls into .claude/skills of the current project.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.md
Select a file.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
