amacneil/dbmate
Dbmate is a lightweight, framework-agnostic database migration tool that supports multiple databases including ClickHouse, enabling consistent schema management across diverse development environments.
sqitchers/sqitch
Sqitch is a comprehensive database change management application designed to support a wide range of database engines including PostgreSQL, YugabyteDB, CockroachDB, SQLite, MySQL, MariaDB, Oracle, Firebird, Vertica, Exasol, Snowflake, and ClickHouse. It distinguishes itself from typical migration tools by being framework-agnostic, allowing developers to manage database changes without being tied to any specific application framework, ORM, or platform. Sqitch uses native scripting for changes, meaning that database changes are implemented as scripts native to the selected database engine, such as SQL scripts for PostgreSQL or Oracle. This approach ensures that changes are executed in the proper order through dependency resolution, which allows changes to declare dependencies on other changes, even across different Sqitch projects. This feature helps maintain deployment integrity and consistency. Sqitch employs a plan file and a Merkle tree pattern similar to Git and Blockchain to ensure deployment integrity, eliminating the need for numbering changes and allowing flexible naming conventions. It supports iterative development by allowing modification of change deployment scripts until the project is tagged and released, facilitating test-driven development and iterative schema evolution. The project provides extensive tutorials for various supported databases and offers multiple installation methods, including building from source, using CPAN, or Docker. Sqitch is licensed under the MIT License, promoting free use and modification. Overall, Sqitch is a powerful, flexible, and reliable tool for managing database schema changes across multiple database platforms, emphasizing integrity, flexibility, and native scripting.
https://github.com/sqitchers/sqitch
Also in CLI
quarylabs/sqruff
sqruff is a fast and customizable SQL formatter and linter supporting multiple SQL dialects including Clickhouse, designed to ensure SQL code quality and consistency across development workflows.
runreveal/pql
pql is a Go library and CLI tool that compiles a pipelined query language inspired by Kusto Query Language into SQL, with specific compatibility for the Clickhouse SQL dialect but designed to be database agnostic.
azat/chdig
Chdig is a terminal user interface tool designed to provide interactive introspection, monitoring, and debugging capabilities for ClickHouse database systems.
hatarist/clickhouse-cli
An unofficial command-line client for the ClickHouse DBMS server offering enhanced features like autocompletion, syntax highlighting, multiquery support, and user-defined functions over HTTP.
Slach/clickhouse-flamegraph
clickhouse-flamegraph is a command-line utility for visualizing ClickHouse system.trace_log data as flamegraphs to analyze query performance and resource usage.