OtterMind/Chat2DB
Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.
frectonz/sql-studio
SQL Studio is a versatile and user-friendly SQL database explorer designed to support multiple database systems including SQLite, libSQL, PostgreSQL, MySQL/MariaDB, ClickHouse, and Microsoft SQL Server. It is distributed as a single binary executable that can be run with a simple command, making it highly accessible and easy to use for database management and exploration tasks. The tool offers a range of features to facilitate database interaction, such as an overview page displaying common metadata, a tables page showing detailed metadata for each table, and a queries page that allows users to execute custom SQL queries with rich IntelliSense support. It also supports infinite scrolling for viewing rows, enhancing the user experience when dealing with large datasets. SQL Studio supports connections to local SQLite database files, remote libSQL servers, PostgreSQL servers, MySQL/MariaDB servers, ClickHouse servers (with partial support), and Microsoft SQL Server instances. This broad compatibility makes it a flexible tool for developers and database administrators working with different database technologies. The project provides prebuilt binaries for easy installation on MacOS and Linux via shell scripts, as well as PowerShell scripts for Windows users. Additionally, it offers a Docker image for containerized deployment and supports Nix package management. The user interface is statically embedded within the binary, and contributors are guided to build the UI before running the application from source. The project emphasizes ease of use, with features like rich SQL IntelliSense for writing queries and a clean, intuitive interface with both light and dark themes. SQL Studio is actively maintained, with new features and updates available on its releases page. Overall, SQL Studio is a comprehensive and convenient tool for exploring and managing SQL databases across multiple platforms and database engines, including ClickHouse.
https://github.com/frectonz/sql-studio
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.
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.