Awesome ClickHouseGUI

tabixio/tabix

⭐ 2299 TypeScript repository created 2017-03-07

Tabix.io UI is an open-source, simple business intelligence application and SQL editor tool specifically designed for ClickHouse. It provides a user-friendly interface to interact with ClickHouse databases, enabling users to write and execute SQL queries efficiently. The project emphasizes ease of use by allowing users to open the application directly in a browser without the need for installation, although installation instructions are provided for those who prefer to run it locally. The tool requires a ClickHouse server version 19.x or higher and is optimized for use with Google Chrome, as other browsers have not been tested. The repository includes detailed setup instructions, including NodeJS, npm, and yarn installation, and highlights specific configurations such as disabling Plug'n'Play (PnP) in Yarn to ensure compatibility. Users can run the application locally on port 9000 or build the project into static files for deployment. Licensed under the Apache License 2.0, Tabix.io UI aims to simplify business intelligence workflows by integrating SQL editing capabilities with ClickHouse's powerful analytics engine. The project is maintained by Tabix LLC and features a clean, accessible interface for data querying and visualization tasks.

https://github.com/tabixio/tabix

analyticsapache-licensebibusiness-intelligencebusinessintelligenceclickhousedashboarddata-analysisdata-queryingdata-visualizationgoogle-chromenodejsopen-sourcesql-editorsql-querytabixtabix.iouiweb-applicationyarn

Also in GUI

OtterMind/Chat2DB

Chat2DB is an AI-powered database client and SQL workspace supporting various databases, including ClickHouse, for developers, DBAs, analysts, and data teams.

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.

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.

caioricciuti/ch-ui

CH-UI is a modern, feature-rich web interface designed for seamless management, querying, and visualization of ClickHouse databases with advanced SQL editing and performance monitoring capabilities.