Schema migration tools for ClickHouse

• golang-migrate tool - see golang-migrate
• liquibase
  • https://github.com/mediarithmics/liquibase-clickhouse
  • https://johntipper.org/how-to-execute-liquibase-changesets-against-clickhouse/
• Flyway - there are a lot of PRs introducing ClickHouse support, maintainer doesn’t merge them (maybe he will change his mind soon), but’s it’s not hard to build flyway from one of those PRs (latest at the top)
  • https://github.com/flyway/flyway/pull/3333 Сlickhouse support
  • https://github.com/flyway/flyway/pull/3134 Сlickhouse support
  • https://github.com/flyway/flyway/pull/3133 Add support clickhouse
  • https://github.com/flyway/flyway/pull/2981 Clickhouse replicated
  • https://github.com/flyway/flyway/pull/2640 Yet another ClickHouse support
  • https://github.com/flyway/flyway/pull/2166 Clickhouse support (#1772)
  • https://github.com/flyway/flyway/pull/1773 Fixed #1772: Add support for ClickHouse (https://clickhouse.yandex/)
• alembic
  • see https://clickhouse-sqlalchemy.readthedocs.io/en/latest/migrations.html
• bytebase
  • https://bytebase.com
• custom tool for ClickHouse for python
  • https://github.com/delium/clickhouse-migrator
  • https://github.com/zifter/clickhouse-migrations
  • https://github.com/trushad0w/clickhouse-migrate
• phpMigrations
  • https://github.com/smi2/phpMigrationsClickhouse
  • https://habrahabr.ru/company/smi2/blog/317682/
• dbmate
  • https://github.com/amacneil/dbmate#clickhouse

know more?

https://clickhouse.com/docs/knowledgebase/schema_migration_tools

Article on migrations in ClickHouse https://posthog.com/blog/async-migrations