t8y2/dbx
DBX is a lightweight, cross-platform desktop and Docker-deployable database client that offers management capabilities for over 40 databases, including ClickHouse, and features a built-in AI assist...
devlive-community/dbm
DBM is an open-source, full-platform database management tool designed to support a wide range of SQL-speaking datastores and data engines, including ClickHouse, Presto, Trino, MySQL, PostgreSQL, Apache Druid, ElasticSearch, and Hologres. It provides a comprehensive suite of features aimed at simplifying database management and query operations for users. The tool supports query history management with pagination and clearing options, enabling users to efficiently track and manage their SQL queries. It allows for selected SQL clause queries and supports terminating running queries to enhance control over database interactions. DBM offers extensive table management capabilities such as deleting tables, retrieving DDL statements, previewing table data, and renaming tables. Column management is equally robust, with features to add, delete, modify, rename columns, and retrieve column information. The platform also supports database-level operations including creating and deleting databases. Users can perform custom queries and manage multiple data sources with functionalities like connection testing and monitoring. The tool includes customization options for appearance and provides monitoring features for processors, connections, and queries, helping users maintain optimal database performance. Additionally, DBM supports data migration, facilitating the transfer of data between different databases or environments. DBM is developed with modern technologies such as Electron and Angular, ensuring a user-friendly interface and cross-platform compatibility. It is actively maintained with continuous integration workflows for testing, releasing, and documentation publishing. The project encourages community contributions and provides extensive documentation in both English and Chinese. Overall, DBM is a versatile and powerful database management system that caters to developers and database administrators who work with multiple database technologies, including ClickHouse, offering a unified platform to manage, query, and monitor their databases efficiently.
https://github.com/devlive-community/dbm
Also in GUI
OtterMind/Chat2DB
Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.
beekeeper-studio/beekeeper-studio
Cross-platform SQL editor and database manager for Linux, macOS and Windows, with full ClickHouse support alongside PostgreSQL, MySQL, SQLite and many other databases.
dbgate/dbgate
DbGate is a cross-platform, open-source database management tool supporting multiple databases including ClickHouse, offering advanced features like visual query design, schema comparison, and data visualization.
TableProApp/TablePro
Open source native database client for macOS, iOS, Linux and, in development, Windows, supporting ClickHouse among 11 database engines on Linux.
TabularisDB/tabularis
Tabularis is an open-source, cross-platform desktop SQL workspace supporting a wide array of databases, including ClickHouse, with built-in AI agent integration and advanced SQL features.
frectonz/sql-studio
SQL Studio is a single binary SQL database explorer supporting multiple databases including SQLite, PostgreSQL, MySQL, ClickHouse, and Microsoft SQL Server, offering rich features like metadata overview, query execution with IntelliSense, and infinite scrolling.
tabixio/tabix
Tabix.io UI is an open-source business intelligence and SQL editor tool designed for efficient interaction with ClickHouse databases.