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...
TableProApp/TablePro
TablePro is an open source, AGPL-3.0-licensed multi-database client distributed as a genuinely native application on every platform it supports, rather than a single Electron or JVM codebase reused everywhere. The macOS and iOS/iPadOS apps are written in Swift with native Apple frameworks, the Linux app uses Rust with GTK 4 and libadwaita, and a Windows app using C# and WinUI 3 is in development on top of the same shared Rust core that Linux uses; the Swift app does not yet share that core. The project positions itself as the missing option between single-database open source clients such as Sequel Ace and Postico, closed-source multi-database clients such as TablePlus, and multi-database but non-native clients such as DBeaver, Beekeeper Studio and DBGate, aiming to be native, multi-database and open source at once. Database support differs by platform: macOS supports PostgreSQL, MySQL, MariaDB, SQLite, Redis, MongoDB, SQL Server and more through built-in and signed plugin drivers; iPhone and iPad support a similar list including DuckDB; and the Linux app explicitly supports eleven engines, including ClickHouse, Cassandra and ScyllaDB alongside the common relational and NoSQL databases, built on the shared Rust driver core. Core features include query editors, data browsing and row editing, SSH tunnels and SSL/TLS connections, saved queries and history, autocomplete and multi-cursor editing with Vim mode on Mac and Linux, AI assistance with a user-supplied provider or Ollama on Mac and Linux, and an MCP server for local AI clients. All database support is free with no trial limit; paid Pro and Team tiers add extra features on Mac and Linux under a shared license covering up to three computers, while the iOS/iPadOS app needs no license. For ClickHouse users on Linux specifically, it offers a native, open source alternative to heavier Electron- or JVM-based clients for browsing and querying ClickHouse alongside other engines.
https://github.com/TableProApp/TablePro
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.
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.