OtterMind/Chat2DB
Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.
DataPupOrg/DataPup
DataPup is a modern, AI-assisted, cross-platform database client designed to make database management intuitive and enjoyable for developers. It features an accessible and beautiful user interface combined with AI-powered query assistance, making it a tool that developers actually want to use. The project is open-source and licensed under the MIT license, encouraging community contributions and collaboration. Currently, DataPup offers full support for ClickHouse, including optimized query execution, making it a powerful client for this specific database. The project also plans to expand its database support to include PostgreSQL, MySQL (and MariaDB), and SQLite within a short timeframe, broadening its usability across popular database systems. The development environment requires Node.js 18 or higher and supports package managers like npm, yarn, or pnpm. The project provides clear instructions for installing dependencies, running the client in development mode, building for production, and creating distributable packages. This makes it accessible for developers to contribute or customize the client according to their needs. DataPup is built using Electron for cross-platform desktop application capabilities, Radix UI for a polished user interface, and Vite for efficient bundling. The AI assistance feature is powered by LangChain, which enhances the user experience by providing intelligent query support. The project encourages community involvement through a contributing guide and welcomes pull requests. It also invites users to star the repository if they find the tool useful. Overall, DataPup aims to be a comprehensive, user-friendly database client that leverages modern technologies and AI to improve database interaction and management.
https://github.com/DataPupOrg/DataPup
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.