Kooha-2026-01-27-17-05-35.webm
ClickLens 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
| 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 |
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 |
| Overview | Filter | Expandable Row |
|---|---|---|
 |
 |
 |
| Overview | Run Query | Results |
|---|---|---|
 |
 |
 |
| History | Time Range | Table Preview |
|---|---|---|
 |
 |
 |
| Overview | Metrics | Async Metrics |
|---|---|---|
 |
 |
 |
| Disks | ZooKeeper |
|---|---|
 |
 |
| History | History Filter | Running | Analytics |
|---|---|---|---|
 |
 |
 |
 |
| Users | Create User | Edit User |
|---|---|---|
 |
 |
 |
| Roles | Create Role | Feature Role |
|---|---|---|
 |
 |
 |
| Server Settings | Server Expandable | Session Settings | Session Expandable |
|---|---|---|---|
 |
 |
 |
 |
| Columns | Parts |
|---|---|
 |
 |
| Server Logs | Crash Logs |
|---|---|
 |
 |
| User Profile |
|---|
 |