OtterMind/Chat2DB
Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.
TabularisDB/tabularis
Tabularis is a feature-rich, open-source desktop SQL workspace designed to provide a comprehensive management and development environment for various databases. It offers native support for PostgreSQL, MySQL/MariaDB, and SQLite, and extends its compatibility to over 12 other databases, including ClickHouse, DuckDB, Redis, and Firestore, through plugins. A notable feature is its integrated MCP (Multi-modal Conversational Platform) server, which enables AI agents like Claude, Cursor, and Devin to interact with database schemas and execute queries directly within the application, promoting AI-assisted development. The workspace provides advanced functionalities such as SQL notebooks, allowing users to combine SQL queries with Markdown cells, define cross-cell variables, and generate charts for in-depth analysis. It also includes a visual EXPLAIN plan for query optimization and a robust SQL editor. For installation, Tabularis supports Windows (via WinGet or direct download), macOS (Homebrew or direct download), and various Linux distributions (Snap, Flatpak, AppImage, AUR). The application's UI is localized in multiple languages, making it accessible to a global audience. Furthermore, Tabularis supports plugin development in any language via JSON-RPC over stdio, offering extensive extensibility beyond its core features. AI text-to-SQL capabilities with local models (Ollama) further enhance its utility for modern data professionals.
https://github.com/TabularisDB/tabularis
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.
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.
caioricciuti/ch-ui
CH-UI is a modern, feature-rich web interface designed for seamless management, querying, and visualization of ClickHouse databases with advanced SQL editing and performance monitoring capabilities.