Find your next open-source project

Search by name, purpose, or keyword — or paste a GitHub repository URL
All skills

clickhouse-migrations

Write a ClickHouse migration that places tables on the correct cluster and passes schema checks.

When to use it

You have a new table or schema change to ship and need to pick the right node role and keep HCL in sync.

For example

You say

Use clickhouse-migrations to add a migration for a new sharded events rollup table, and tell me which cluster it belongs on.

You get
  • Migration file
  • Node role choice
  • HCL layer update

How it works

  • Migration PRs must contain only migration files, SQL definitions, and related tests.
  • Cloud-only tables still need a local schema entry in schema.py.
  • Dropping a column is a two-step process started by the ClickHouse team.

Before installing

Checking live dev, prod-us and prod-eu clusters requires the ClickHouse MCP (Housekeeper) setup.