Visual interfaces from third-party developers

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/third-party/gui.md)

## Open-source[​](#open-source "Direct link to Open-source")

### agx[​](#agx "Direct link to agx")

[agx](https://github.com/agnosticeng/agx) is a desktop application built with Tauri and SvelteKit that provides a modern interface for exploring and querying data using ClickHouse's embedded database engine (chdb).

- Leverage ch-db when running the native application.
- Can connect to a Clickhouse instance when running the web instance.
- Monaco editor so you'll feel at home.
- Multiple and evolving data visualizations.

### ch-ui[​](#ch-ui "Direct link to ch-ui")

[ch-ui](https://github.com/caioricciuti/ch-ui) is a simple React.js app interface for ClickHouse databases designed for executing queries and visualizing data. Built with React and the ClickHouse client for web, it offers a sleek and user-friendly UI for easy database interactions.

Features:

- ClickHouse Integration: Easily manage connections and execute queries.
- Responsive Tab Management: Dynamically handle multiple tabs, such as query and table tabs.
- Performance Optimizations: Utilizes Indexed DB for efficient caching and state management.
- Local Data Storage: All data is stored locally in the browser, ensuring no data is sent anywhere else.

### ChartDB[​](#chartdb "Direct link to ChartDB")

[ChartDB](https://chartdb.io) is a free and open-source tool for visualizing and designing database schemas, including ClickHouse, with a single query. Built with React, it provides a seamless and user-friendly experience, requiring no database credentials or signup to get started.

Features:

- Schema Visualization: Instantly import and visualize your ClickHouse schema, including ER diagrams with materialized views and standard views, showing references to tables.
- AI-Powered DDL Export: Generate DDL scripts effortlessly for better schema management and documentation.
- Multi-SQL Dialect Support: Compatible with a range of SQL dialects, making it versatile for various database environments.
- No Signup or Credentials Needed: All functionality is accessible directly in the browser, keeping it frictionless and secure.

[ChartDB Source Code](https://github.com/chartdb/chartdb).

### DataStoria[​](#datastoria "Direct link to DataStoria")

[DataStoria](https://github.com/FrankChen021/datastoria) is an AI-powered web console application that manages multiple ClickHouse clusters in one place.

Features:

- **AI-Powered Intelligence**: Use natural language to explore data, optimize and fix SQL queries, and visualize your data.
- **Official ClickHouse Agent Skills Integration**: Leverage [official best practices](https://github.com/ClickHouse/agent-skills) to ask AI for database optimizations and suggestions.
- **Smart Error Diagnostics**: Pinpoint syntax errors instantly with precise line and column highlighting, and get AI-powered fix suggestions with one click.
- **System Table Inspection**: Dive deep into `system.query_log`, `system.query_views_log`, `system.zookeeper`, `system.ddl_distributed_queue`, `system.part_log`, and `system.processes` with a powerful visualization dashboard and filters to quickly understand your cluster.
- **One-Click Explain**: Instantly understand query execution plans with visual AST and pipeline views.
- **Dependency Graph**: Visualize table relationships and trace data flows through Materialized Views, Distributed tables, and external systems.
- **Cluster Monitoring**: Monitor all nodes with real-time metrics, merge operations, replication status, query performance, and more.
- **Privacy & Security**: All SQL queries run directly from your browser to your ClickHouse server, ensuring complete privacy.

[DataStoria documentation](https://docs.datastoria.app).

### DataPup[​](#datapup "Direct link to DataPup")

[DataPup](https://github.com/DataPupOrg/DataPup) is a modern, AI-assisted, cross-platform database client with native ClickHouse support.

Features:

- AI-powered SQL query assistance with intelligent suggestions
- Native ClickHouse connection support with secure credential handling
- Beautiful, accessible interface with multiple themes (Light, Dark, and colorful variants)
- Advanced query result filtering and exploration
- Cross-platform support (macOS, Windows, Linux)
- Fast and responsive performance
- Open-source and MIT licensed

### Dory[​](#dory "Direct link to Dory")

[Dory](https://github.com/dorylab/dory) AI-native SQL workspace with first-class ClickHouse support, AI built-in.

Features:

- AI Copilot for SQL generation, explanation, and debugging
- Manage and query multiple ClickHouse clusters from a unified workspace
- Schema-aware SQL autocomplete and multi-tab query workspace
- Interactive query result exploration with filtering and visualization
- AI-powered table summaries for understanding datasets
- Direct ClickHouse connections with SSH tunnel support
- Modern developer-friendly interface with light, dark, and theme support
- Cross-platform desktop app (macOS, Windows, Linux), and Docker support
- Open-source and MIT licensed

### ClickHouse Schema Flow Visualizer[​](#clickhouse-schemaflow-visualizer "Direct link to ClickHouse Schema Flow Visualizer")

[ClickHouse Schema Flow Visualizer](https://github.com/FulgerX2007/clickhouse-schemaflow-visualizer) is a powerful open-source web application for visualizing ClickHouse table relationships using Mermaid.js diagrams. Browse databases and tables with an intuitive interface, explore table metadata with optional row counts and size information, and export interactive schema diagrams.

Features:

- Browse ClickHouse databases and tables with an intuitive interface
- Visualize table relationships with Mermaid.js diagrams
- Color-coded icons matching table types for better visualization
- View direction of data flow between tables
- Export diagrams as standalone HTML files
- Toggle metadata visibility (table rows and size information)
- Secure connection to ClickHouse with TLS support
- Responsive web interface for all devices

[ClickHouse Schema Flow Visualizer - source code](https://github.com/FulgerX2007/clickhouse-schemaflow-visualizer)

### Tabix[​](#tabix "Direct link to Tabix")

Web interface for ClickHouse in the [Tabix](https://github.com/tabixio/tabix) project.

Features:

- Works with ClickHouse directly from the browser without the need to install additional software.
- Query editor with syntax highlighting.
- Auto-completion of commands.
- Tools for graphical analysis of query execution.
- Colour scheme options.

[Tabix documentation](https://tabix.io/doc/).

### HouseOps[​](#houseops "Direct link to HouseOps")

[HouseOps](https://github.com/HouseOps/HouseOps) is a UI/IDE for OSX, Linux and Windows.

Features:

- Query builder with syntax highlighting. View the response in a table or JSON view.
- Export query results as CSV or JSON.
- List of processes with descriptions. Write mode. Ability to stop (`KILL`) a process.
- Database graph. Shows all tables and their columns with additional information.
- A quick view of the column size.
- Server configuration.

The following features are planned for development:

- Database management.
- User management.
- Real-time data analysis.
- Cluster monitoring.
- Cluster management.
- Monitoring replicated and Kafka tables.

### LightHouse[​](#lighthouse "Direct link to LightHouse")

[LightHouse](https://github.com/VKCOM/lighthouse) is a lightweight web interface for ClickHouse.

Features:

- Table list with filtering and metadata.
- Table preview with filtering and sorting.
- Read-only query execution.

### Redash[​](#redash "Direct link to Redash")

[Redash](https://github.com/getredash/redash) is a platform for data visualization.

Supports for multiple data sources including ClickHouse, Redash can join results of queries from different data sources into one final dataset.

Features:

- Powerful editor of queries.
- Database explorer.
- Visualization tool that allows you to represent data in different forms.

### Grafana[​](#grafana "Direct link to Grafana")