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.
hatarist/clickhouse-cli
The project "hatarist/clickhouse-cli" is an unofficial command-line client designed for the ClickHouse DBMS server. It provides users with a convenient and enhanced interface to interact with ClickHouse databases over the HTTP port. The client supports several useful features such as autocompletion (still a work in progress), syntax highlighting for both queries and data output, multiquery and multiline modes by default, and pager support for data output. It also includes custom commands inspired by PostgreSQL, such as commands to show databases, change the current database, show tables, display table schemas, show current queries, and kill queries by ID. The client is implemented in Python and requires Python 3.7 or higher. It can be installed easily via pip. Users can configure connection options and preferences through a configuration file located at ~/.clickhouse-cli.rc, which allows setting defaults for host, port, user, password, database, and other options like syntax highlighting, output format, and pager usage. The client supports environment variables for connection parameters, allowing flexible configuration. It can read SQL queries from files or standard input, supporting multiquery execution. It also supports inserting data from files into ClickHouse tables. Advanced usage includes setting custom server-side settings and defining user-defined functions (UDFs) through a find-and-replace mechanism on queries before sending them to the server, enabling users to simplify complex query expressions. Overall, this project aims to provide a powerful, user-friendly, and customizable command-line interface for working with ClickHouse databases, enhancing productivity and ease of use for database administrators and developers.
https://github.com/hatarist/clickhouse-cli
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.
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.
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.