Visual interfaces from third-party developers

### ClickHouse-Mate[​](#clickmate "Direct link to ClickHouse-Mate")

[ClickHouse-Mate](https://github.com/metrico/clickhouse-mate) is an angular web client + user interface to search and explore data in ClickHouse.

Features:

- ClickHouse SQL Query autocompletion
- Fast Database and Table tree navigation
- Advanced result Filtering and Sorting
- Inline ClickHouse SQL documentation
- Query Presets and History
- 100% browser based, no server/backend

The client is available for instant usage through github pages: <https://metrico.github.io/clickhouse-mate/>

### Uptrace[​](#uptrace "Direct link to Uptrace")

[Uptrace](https://github.com/uptrace/uptrace) is an APM tool that provides distributed tracing and metrics powered by OpenTelemetry and ClickHouse.

Features:

- [OpenTelemetry tracing](https://uptrace.dev/opentelemetry/distributed-tracing.html), metrics, and logs.
- Email/Slack/PagerDuty notifications using AlertManager.
- SQL-like query language to aggregate spans.
- Promql-like language to query metrics.
- Pre-built metrics dashboards.
- Multiple users/projects via YAML config.

### clickhouse-monitoring[​](#clickhouse-monitoring "Direct link to clickhouse-monitoring")

[clickhouse-monitoring](https://github.com/duyet/clickhouse-monitoring) is a simple Next.js dashboard that relies on `system.*` tables to help monitor and provide an overview of your ClickHouse cluster.

Features:

- Query monitor: current queries, query history, query resources (memory, parts read, file\_open, ...), most expensive queries, most used tables or columns, etc.
- Cluster monitor: total memory/CPU usage, distributed queue, global settings, mergetree settings, metrics, etc.
- Tables and parts information: size, row count, compression, part size, etc., at the column level detail.
- Useful tools: Zookeeper data exploration, query EXPLAIN, kill queries, etc.
- Visualization metric charts: queries and resource usage, number of merges/mutation, merge performance, query performance, etc.

### CKibana[​](#ckibana "Direct link to CKibana")

[CKibana](https://github.com/TongchengOpenSource/ckibana) is a lightweight service that allows you to effortlessly search, explore, and visualize ClickHouse data using the native Kibana UI.

Features:

- Translates chart requests from the native Kibana UI into ClickHouse query syntax.
- Supports advanced features such as sampling and caching to enhance query performance.
- Minimizes the learning cost for users after migrating from ElasticSearch to ClickHouse.

### Telescope[​](#telescope "Direct link to Telescope")

[Telescope](https://iamtelescope.net/) is a modern web interface for exploring logs stored in ClickHouse. It provides a user-friendly UI for querying, visualizing, and managing log data with fine-grained access control.

Features:

- Clean, responsive UI with powerful filters and customizable field selection.
- FlyQL syntax for intuitive and expressive log filtering.
- Time-based graph with group-by support, including nested JSON, Map, and Array fields.
- Optional raw SQL `WHERE` query support for advanced filtering (with permission checks).
- Saved Views: persist and share custom UI configurations for queries and layout.
- Role-based access control (RBAC) and GitHub authentication integration.
- No extra agents or components required on the ClickHouse side.

[Telescope Source Code](https://github.com/iamtelescope/telescope) · [Live Demo](https://demo.iamtelescope.net)

### ClickLens[​](#clicklens "Direct link to ClickLens")

[ClickLens](https://ntk148v.github.io/clicklens/) is a modern, powerful, and user-friendly web interface for managing and monitoring ClickHouse databases. It provides a comprehensive suite of tools for developers, analysts, and administrators to interact with their ClickHouse clusters efficiently. ClickHouse is an incredible analytical database, but managing it via CLI or basic tools can be challenging. ClickLens bridges the gap by offering:

- Discover - Flexible, Kibana-like data exploration for any table
- SQL Console - Write, execute, and analyze queries with syntax highlighting and streaming results
- Real-time Monitoring - Keep an eye on your cluster's health, query performance, and resource usage
- Schema Explorer - Navigate databases, tables, columns, parts, and more
- Access Control - Manage users and roles directly from the UI
- Native RBAC - Your UI permissions are derived directly from your ClickHouse grants

[ClickLens Source Code](https://github.com/ntk148v/clicklens)

### CHouse UI[​](#chouse-ui "Direct link to CHouse UI")

[CHouse UI](https://chouse-ui.com) is an open-source ClickHouse web interface built specifically for **teams** and **secure data access**. Unlike traditional clients that require direct database credentials, CHouse UI implements a powerful **Role-Based Access Control (RBAC)** layer, allowing administrators to grant granular permissions without exposing underlying secrets.

Key differentiators include:

- **Enterprise-Grade Security** - Server-side credential encryption, detailed audit logging, and access rules.
- **Team Collaboration** - Define custom roles (e.g., specific table access for Analysts) and share queries securely.
- **AI-Powered Insights** - Integrated LLM support for query optimization and visual explanation.
- **complete Toolkit** - Features a robust SQL editor, monitoring dashboard, schema explorer, and seamless data import/export.

[CHouse UI Source Code](https://github.com/daun-gatal/chouse-ui)

## Commercial[​](#commercial "Direct link to Commercial")

### DataGrip[​](#datagrip "Direct link to DataGrip")

[DataGrip](https://www.jetbrains.com/datagrip/) is a database IDE from JetBrains with dedicated support for ClickHouse. It is also embedded in other IntelliJ-based tools: PyCharm, IntelliJ IDEA, GoLand, PhpStorm and others.

Features:

- Very fast code completion.
- ClickHouse syntax highlighting.
- Support for features specific to ClickHouse, for example, nested columns, table engines.
- Data Editor.
- Refactorings.
- Search and Navigation.

### Yandex DataLens[​](#yandex-datalens "Direct link to Yandex DataLens")

[Yandex DataLens](https://cloud.yandex.ru/services/datalens) is a service of data visualization and analytics.

Features:

- Wide range of available visualizations, from simple bar charts to complex dashboards.
- Dashboards could be made publicly available.
- Support for multiple data sources including ClickHouse.
- Storage for materialized data based on ClickHouse.

DataLens is [available for free](https://cloud.yandex.com/docs/datalens/pricing) for low-load projects, even for commercial use.

- [DataLens documentation](https://cloud.yandex.com/docs/datalens/).
- [Tutorial](https://cloud.yandex.com/docs/solutions/datalens/data-from-ch-visualization) on visualizing data from a ClickHouse database.

### Holistics Software[​](#holistics-software "Direct link to Holistics Software")

[Holistics](https://www.holistics.io/) is a full-stack data platform and business intelligence tool.

Features:

- Automated email, Slack and Google Sheet schedules of reports.
- SQL editor with visualizations, version control, auto-completion, reusable query components and dynamic filters.
- Embedded analytics of reports and dashboards via iframe.
- Data preparation and ETL capabilities.
- SQL data modelling support for relational mapping of data.

### Looker[​](#looker "Direct link to Looker")

[Looker](https://looker.com) is a data platform and business intelligence tool with support for 50+ database dialects including ClickHouse. Looker is available as a SaaS platform and self-hosted. Users can use Looker via the browser to explore data, build visualizations and dashboards, schedule reports, and share their insights with colleagues. Looker provides a rich set of tools to embed these features in other applications, and an API
to integrate data with other applications.

Features: