Awesome ClickHouse › GUI

tabixio/tabix

⭐ 2296 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

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...

OtterMind/Chat2DB

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

beekeeper-studio/beekeeper-studio

Cross-platform SQL editor and database manager for Linux, macOS and Windows, with full ClickHouse support alongside PostgreSQL, MySQL, SQLite and many other databases.

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.

TableProApp/TablePro

Open source native database client for macOS, iOS, Linux and, in development, Windows, supporting ClickHouse among 11 database engines on Linux.

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.