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.
azat/chdig
The project "chdig" is a terminal user interface (TUI) tool designed specifically for interacting with and introspecting ClickHouse, a columnar database management system. It provides a convenient and efficient way to dig into various aspects of ClickHouse through a user-friendly TUI, making it easier to monitor, debug, and analyze ClickHouse operations and performance. Chdig offers a top-like interface, similar to the Linux tool "top" or the sysdig tool, allowing users to view real-time system and query information. It supports multiple views that cover a wide range of ClickHouse system tables and logs, including system.processes, system.query_log, system.processors_profile_log, system.merges, system.mutations, system.replicas, and many others. This comprehensive coverage enables users to gain deep insights into query execution, slow queries, processor profiles, replication status, backups, errors, and more. One of the notable features of chdig is its support for flamegraphs, which visually represent CPU, real, and memory usage, helping users identify performance bottlenecks. It also supports cluster mode, allowing users to monitor ClickHouse clusters effectively. The project is in a pre-alpha stage, meaning it is still under active development and subject to changes in features, interface, and usability. It is distributed with pre-built packages for various Linux distributions, macOS, and Windows, and can also be built from source using Rust's cargo tool. Chdig was motivated by the need to simplify the process of exploring ClickHouse's extensive introspection tools, which can be overwhelming and easy to forget. By consolidating these tools into a single TUI, chdig aims to make ClickHouse monitoring and debugging more accessible and efficient. Overall, chdig is a valuable tool for ClickHouse users who want a powerful, interactive, and visual way to understand and manage their ClickHouse instances and clusters.
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.
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.