OtterMind/Chat2DB
Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.
t8y2/dbx
DBX is a versatile and lightweight database client designed for managing a wide array of database systems. Built with Rust and Tauri, it provides a cross-platform solution (desktop and Docker self-hosting) with a small footprint, typically around 15MB. The client supports an extensive list of database technologies, including popular relational databases like MySQL, PostgreSQL, SQLite, SQL Server, Oracle, and analytical databases such as ClickHouse, DuckDB, TiDB, Doris, SelectDB, StarRocks, and Redshift. It also caters to NoSQL databases like MongoDB, Redis, and Elasticsearch, alongside various Chinese domestic databases like DM, OceanBase, openGauss, GaussDB, KWDB, KingBase, and TDengine. Key features of DBX include a comprehensive GUI for database management, query execution, data browsing, and schema introspection. The integration of an AI assistant aims to enhance user productivity by assisting with query generation, optimization, or other database-related tasks. Its lightweight nature ensures minimal system resource consumption, making it an efficient tool for developers and database administrators who need to interact with multiple database environments without the overhead of heavy clients. The project emphasizes ease of deployment and broad compatibility, positioning itself as a go-to solution for diverse database management needs.
Also in GUI
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.
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.