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.
runreveal/pql
The project "pql" by runreveal is a Go library and CLI tool that compiles a pipelined query language inspired by the Kusto Query Language (KQL) into SQL. It is designed to work specifically with the Clickhouse SQL dialect, although the generated SQL is intentionally database agnostic, allowing it to be used with other SQL databases as well. The main goal of the project is to provide a way to write queries in a more readable, pipelined format and then convert them into standard SQL queries. The pipelined query language supports a variety of tabular operators such as as, count, join, let statements (scalar expressions only), project, extend, sort/order, summarize, take/limit, top, and where. It also implements several scalar functions including not, now, isnull, isnotnull, strcat, iff/iif, count, countif, tolower, and toupper. Functions not implemented in pql are passed through to the underlying SQL engine, enabling the use of the full API of the SQL engine. The project provides examples and documentation to help users get started, including a minimal Go code example demonstrating how to compile a pipelined query into SQL. The repository also includes links to a playground and a website for demos and further examples. The project encourages community involvement through a Discord channel and contributions to scalar functions. Overall, pql aims to simplify the process of writing complex SQL queries by allowing users to write in a more intuitive, pipelined query language that is then compiled into efficient SQL, with a focus on compatibility with Clickhouse but adaptable to other SQL dialects.
https://github.com/runreveal/pql
Also in CLI
sqitchers/sqitch
Sqitch is a versatile and framework-agnostic database change management tool supporting multiple database engines including ClickHouse, emphasizing native scripting, dependency resolution, and deployment integrity.
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.
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.