OtterMind/Chat2DB
Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.
l1xnan/duckling
Duckling is a lightweight desktop application designed for fast and efficient viewing of data stored in CSV and Parquet files as well as various databases. Built using the Tauri framework, Duckling aims to provide users with a quick browsing experience rather than a full-fledged database management system. It supports popular databases such as DuckDB and SQLite, with experimental support for PostgreSQL, MySQL, Clickhouse, and Doris/StarRocks. Notably, for Clickhouse, only the Native Protocol port (usually port 9000) is supported, which is important for users connecting to Clickhouse databases. The application is actively under development and currently considered unstable, indicating ongoing improvements and feature additions. Duckling is cross-platform and can be installed from pre-built releases available on its GitHub page. For Windows users, there is a note about the requirement of Webview2, which can be installed offline if network issues prevent automatic installation. The primary use case for Duckling is to open and browse data folders or DuckDB files quickly, making it a handy tool for data analysts, developers, or anyone needing to inspect data without the overhead of complex database management tools. The interface supports dark and light themes, enhancing usability in different lighting conditions. Overall, Duckling is a practical tool for users who need to rapidly access and view data from multiple sources including files and databases, with a focus on speed and simplicity rather than comprehensive database management features. Its support for Clickhouse, among other databases, makes it relevant for users working with large-scale analytical databases.
https://github.com/l1xnan/duckling
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.