OtterMind/Chat2DB
Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.
DataflareApp/dataflare
Dataflare is a versatile and user-friendly database manager that streamlines database operations across a wide array of supported platforms. It provides essential functionalities such as managing database connections, viewing and editing data with filtering and sorting capabilities, and a sophisticated SQL editor equipped with real-time saving, syntax highlighting, and auto-complete. The tool is designed to enhance productivity with features like a schema manager for visualizing table structures, a dashboard for data analysis through charts, and data generation for testing purposes. It also incorporates "SQL Preview" to review queries before execution and a "Read-only Mode" for secure data viewing. Furthermore, Dataflare leverages AI to generate SQL queries, explain complex code, and provide intelligent suggestions, significantly boosting efficiency for developers and data professionals. Its quick search function allows rapid navigation to databases, tables, or queries. Dataflare supports an extensive list of databases, prominently featuring ClickHouse, alongside others like BigQuery, MySQL, PostgreSQL, DuckDB, and various cloud services such as Cloudflare D1 and R2. This broad compatibility makes it a powerful tool for environments with diverse data storage needs. Available on macOS, Windows, and Linux, Dataflare offers an accessible solution for managing and interacting with databases, simplifying complex tasks and improving overall data workflow.
https://github.com/DataflareApp/dataflare
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.