Schema migration tools for ClickHouse®

• atlas
  • https://atlasgo.io/guides/clickhouse
• golang-migrate tool - see golang-migrate
• liquibase
  • https://github.com/mediarithmics/liquibase-clickhouse
  • https://johntipper.org/how-to-execute-liquibase-changesets-against-clickhouse/
• HousePlant
  • New CLI migration tool (Dec2024) for ClickHouse developed by June
  • Documentation https://houseplant.readthedocs.io/en/latest/index.html
  • Github https://github.com/juneHQ/houseplant
• Flyway
  • Official community supported plugin git https://github.com/flyway/flyway-community-db-support
  • Old pull requests (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