clisma

A ClickHouse migrations CLI with templated SQL and environment-aware configuration. Current stable version is 0.3.1, released as an npm package with a VS Code extension companion. Key differentiators from alternatives like Atlas or clickhouse-migrations include support for Handlebars templates in migration files, multi-statement migration files (no need to split SQL), declarative environment blocks in HCL config, built-in replication-aware tracking table configuration, and TLS/mTLS support for secure connections. It also supports environment variable interpolation, custom variables, and checksum validation.