OtterMind/Chat2DB
Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.
metrico/clickhouse-mate
ClickHouse-Mate is an advanced user interface designed specifically for interacting with ClickHouse, a high-performance columnar database management system. This project provides a comprehensive web client that allows users to efficiently write, execute, and manage ClickHouse SQL queries with enhanced usability features. The interface includes SQL query autocompletion, which helps users write queries faster and with fewer errors by suggesting SQL syntax and table names as they type. It also offers fast navigation through databases and tables via a tree structure, making it easier to explore and manage database schemas. The tool supports advanced filtering and sorting of query results, enabling users to analyze data more effectively within the interface. Inline ClickHouse SQL documentation is integrated, providing users with quick access to relevant information about SQL commands and functions without leaving the interface. Users can save query presets and access their query history, facilitating repeated use of common queries and improving productivity. ClickHouse-Mate supports HTTP and HTTPS connections, allowing secure communication with ClickHouse servers. Importantly, it is a 100% web client application, meaning it runs entirely in the browser without requiring any backend server, ensuring that no data passes through intermediary servers, which enhances security and privacy. The project is open source and licensed under AGPLv3. It is sponsored by qxip/metrico as part of the qryn project. Users can try a live demo online, remix the project on Glitch, download the latest build, or build and run it locally from the source code. This makes ClickHouse-Mate a versatile and accessible tool for developers and data analysts working with ClickHouse databases who need a powerful, user-friendly interface for query management and data exploration.
https://github.com/metrico/clickhouse-mate
Also in GUI
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...
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.
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.
feigeCode/navop
Navop is a native, GPU-accelerated desktop workspace written in Rust that combines a multi-database client with built-in ClickHouse support, SSH, SFTP, terminals, remote desktop, monitoring and AI assistance.
timestored/qstudio
qStudio is a free, cross-platform SQL client and notebook that supports numerous databases including ClickHouse, offering features like query execution, data visualization, and AI-powered SQL assistance.