Awesome ClickHouseGUI

OtterMind/Chat2DB

⭐ 28115 Java added to this list on 2026-06-01 repository created 2023-06-20

Chat2DB is an AI-powered database client and SQL workspace designed to streamline database interactions for developers, DBAs, analysts, and data teams. It offers intelligent SQL generation, helping users write queries more efficiently with AI assistance. The tool boasts broad database compatibility, supporting over 10 relational and NoSQL databases, including MySQL, PostgreSQL, Oracle, SQLServer, SQLite, MariaDB, and notably, ClickHouse. Beyond standard SQL client functionalities like visual table editing, SQL console, and formatting, Chat2DB differentiates itself with advanced AI capabilities. The 'Pro' version offers intelligent report generation for faster dashboard creation, data structure synchronization, and various data management features such as import/export, migration, and code generation. It also includes Chat2Excel functionality and an intelligent dashboard. Available on Windows, macOS, and Linux, Chat2DB aims to provide a comprehensive solution for managing and interacting with diverse database systems, leveraging AI for enhanced productivity.

https://github.com/OtterMind/Chat2DB

aibichatgptclickhouseclickhouse-clientdatabasedatagripdb2dbeavergpthivemysqlnavicatoraclepostgresqlredisredis-clientsqlservertext2sqlsql clientdatabase managementdata analysisdata warehousing

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.

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.