OtterMind/Chat2DB
Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.
caioricciuti/ch-ui
CH-UI is a modern, feature-rich web interface designed specifically for managing and interacting with ClickHouse databases. It provides users with an intuitive and user-friendly platform to execute queries, manage data, and visualize metrics related to their ClickHouse instances. The project emphasizes seamless integration with ClickHouse, offering advanced SQL editing capabilities such as intelligent autocomplete (IntelliSense), syntax highlighting, query history tracking, and multi-tab query execution, which enhances productivity and ease of use for database administrators and developers. One of the standout features of CH-UI is its dynamic data visualization tools. Users can interact with data tables that support sorting and filtering, customize visualizations, and receive real-time updates, making it easier to analyze and interpret large datasets. The interface is optimized for performance with an IndexedDB-based caching system and efficient state management, ensuring responsiveness even when handling substantial amounts of data. Built entirely with TypeScript, CH-UI benefits from improved code quality and a better developer experience. It also includes custom table management without relying on third-party dependencies, which contributes to its streamlined architecture. The project offers a comprehensive metrics dashboard that monitors query performance, table statistics, system settings, network performance, and resource utilization, providing valuable insights for database optimization and monitoring. The user experience is enhanced by a modern, clean, and responsive UI that supports both dark and light modes and customizable layouts. Deployment is straightforward, with recommended Docker usage and detailed instructions for building from source. Security considerations for production deployment are well-documented, including reverse proxy setup, HTTPS, authentication, and network security best practices. Overall, CH-UI is a powerful tool for anyone working with ClickHouse databases, combining advanced functionality, performance optimization, and a polished user interface to facilitate efficient database management and data analysis.
https://github.com/caioricciuti/ch-ui
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.