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:
- Bytebase
- Flyway
- Atlas
- Liquibase
- A simple community tool named
clickhouse-migrations
- Another community tool written in Go