ClickLens

A modern, powerful web interface for managing and monitoring ClickHouse databases.

Kooha-2026-01-27-17-05-35.webm

1. Introduction

ClickLens provides a comprehensive suite of tools for developers, analysts, and administrators to interact with their ClickHouse clusters efficiently.

1.1. Why ClickLens?

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

2. Features

Feature	Description
Discover	Kibana-style exploration with time filtering, field selection, and histograms
SQL Console	Multi-tab editor with autocomplete, EXPLAIN, saved queries, and streaming
Table Explorer	Browse schemas with parts, merges, mutations, and DDL views
Monitoring	8 dashboards for metrics, cluster, disks, Keeper, and replication
Query Analytics	Running queries, history, performance analysis, and cache stats
Logging	Server logs, session logs, and crash logs
Access Control	User and role management with feature roles
Settings	View server and session settings

3. Documentation

Full documentation is available at https://ntk148v.github.io/clicklens.

Section	Description
Getting Started	Installation and first login
Features	All features with usage instructions
Architecture	Tech stack, data flow, internals
Deployment	Configuration, Docker, RBAC setup
Contributing	Development setup, code guidelines

AI generated documentation:

• https://zread.ai/ntk148v/clicklens
• https://deepwiki.com/ntk148v/clicklens

4. Screenshots

Discovery

Overview	Filter	Expandable Row

SQL Console

Overview	Run Query	Results

History	Time Range	Table Preview

Monitoring

Overview	Metrics	Async Metrics

Disks	ZooKeeper

Queries

History	History Filter	Running	Analytics

Access Control

Users	Create User	Edit User

Roles	Create Role	Feature Role

Settings

Server Settings	Server Expandable	Session Settings	Session Expandable

Tables

Columns	Parts

Logging

Server Logs	Crash Logs

Profile

User Profile

5. License

MIT