OtterMind/Chat2DB
Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.
geek-fun/sqlkit
SqlKit is an open-source desktop database client for macOS, Windows and Linux, published by geek-fun under the Apache 2.0 license. It is built on Tauri with a Rust backend rather than Electron, which keeps the installed application small and its memory footprint low compared with heavyweight clients such as DBeaver, Navicat or DataGrip. The project positions itself as an alternative to those tools for engineers who work across several database engines at once. The client speaks to a wide range of SQL and analytical engines. ClickHouse is supported alongside PostgreSQL, MySQL, MariaDB, Oracle, SQL Server, SQLite, DuckDB, Firebird, DB2, H2, CockroachDB, Snowflake, Redshift, Teradata, Trino, TiDB, OceanBase, OpenGauss, Doris, StarRocks, TimescaleDB and others, so a single window can hold connections to an OLTP database and to a ClickHouse analytics cluster side by side. The usual client features are present: browsing schemas and tables, editing and running SQL, and inspecting result sets. What distinguishes SqlKit from a plain query editor is its agentic layer. Instead of only executing statements typed by hand, the application accepts a request in natural language, then inspects the connected schema, generates the SQL it believes answers the request, runs it and returns the result. The same agent is used to explain and optimize existing queries. The authors describe the design as privacy-first: connections and credentials stay on the local machine, and the language model is reached with the user's own API keys rather than through a vendor-hosted service. SqlKit suits developers, analysts and operators who query ClickHouse from a desktop and want one native client covering the rest of their databases too, with model-assisted query writing available but not mandatory.
https://github.com/geek-fun/sqlkit
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.