Automatic schema migration tools for ClickHouse

Learn about automatic schema migration tools for ClickHouse and how to manage changing database schemas over time.

Automatic schema migration tools for ClickHouse

We often get asked about a good schema migration tool for ClickHouse and what is the best practice to manage database schemas in ClickHouse that might change over time?

There is no standard schema migration tool for ClickHouse, but we have compiled the following list (in no particular order) of automatic schema migration tools with support for ClickHouse that we know:

• Goose
• Sqitch
• Atlas
• Bytebase
• Flyway
• Liquibase
• A simple community tool named clickhouse-migrations (Node.js)
• Another community tool written in Go
• Houseplant
• clickhouse-migrations (Python) — a file-based schema migration runner available as a CLI and Python library, with single-node and cluster (ON CLUSTER / replicated) support