OtterMind/Chat2DB
Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.
agnosticeng/agx
The project agx is an AI-powered integrated analytics environment designed as a desktop application that enables users to explore and query data through a modern and interactive interface. It is built using web technologies such as Tauri, SvelteKit, and Plot, providing a native desktop application experience with the performance benefits of web technologies. The application supports two main modes of operation: as a native desktop app using ClickHouse's embedded database engine called chdb, or as a web interface connected to a remote ClickHouse server instance. This flexibility allows users to either work locally with embedded data or connect to a live ClickHouse server for querying and analytics. Key features of agx include an interactive SQL query editor with syntax highlighting, a schema browser for exploring the data structure, and results displayed in a tabular format for easy analysis. The application also supports drag and drop file operations, enhancing usability and data import capabilities. It is cross-platform compatible, running on macOS, Linux, and Windows, making it accessible to a wide range of users. The project structure is well organized, with frontend source code written in SvelteKit and backend source code in Rust using Tauri. Communication between the frontend and backend is handled through Tauri's IPC bridge, ensuring efficient and secure data exchange. Data querying is powered by chdb, the embedded ClickHouse engine, which provides high-performance analytics capabilities. Additionally, the project offers an easy installation script for Agnostic ClickHouse User Defined Functions (UDFs), enhancing the functionality of ClickHouse within the environment. The project is open source under the MIT License, encouraging contributions and modifications. Overall, agx provides a powerful and user-friendly analytics environment leveraging ClickHouse technology for efficient data exploration and querying.
https://github.com/agnosticeng/agx
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.