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
• Multi-Cluster - Manage multiple ClickHouse clusters from a single UI

2. Features

3. Multi-Cluster Support

ClickLens supports connecting to multiple independent ClickHouse clusters from a single instance. Each cluster is registered in the CLICKHOUSE_CLUSTERS environment variable, and users select which cluster to log into from the login page.

Quick Start (Docker Compose)

cp env.sample .env.local
# Edit .env.local with your cluster definitions
docker compose -f docker-compose.multi-cluster.yml up --build -d

Each cluster entry in CLICKHOUSE_CLUSTERS requires:

Once logged in, every authenticated request is pinned to the selected cluster — queries, monitoring, schema browsing, and access control all operate against that cluster.

4. Documentation

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

AI generated documentation:

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

4. Screenshots

Discovery

SQL Console

Monitoring

Queries

Access Control

Settings

Tables

Logging

Profile

6. License

MIT