chmonitorData Explorer
Browse every database, table, column, index, projection, and dependency in your ClickHouse instance without writing SQL.
The Data Explorer is a tree-browser for the entire schema of a ClickHouse host: every database, table, column, index, projection, and dependency, without writing SQL.
| Routes | /explorer |
| Feature id | tables |
| Default access | public |
| Requires auth | No (set CHM_FEATURE_TABLES_ACCESS=authenticated to gate) |
| System tables | system.databases, system.tables, system.columns, system.projection_parts, system.data_skipping_indices, system.dictionaries |
| ClickHouse grants | SELECT on the system tables above |
What it does
Select a database from the sidebar, then a table, to see:
- Column list — name, type, and whether the column is part of the primary key, sorting key, or partition key.
- DDL — the
CREATE TABLEstatement for the selected table. - Indexes — partition key, sorting key, primary key, sampling key, and engine parameters.
- Skip indexes — data-skipping index definitions.
- Projections — defined projections and their storage.
- Dependencies — upstream and downstream objects (views, dictionaries) that reference or are referenced by the table.
- Table metadata — engine, total rows, compressed size.
All queries are read-only. No writes are issued.
Read-only
The explorer cannot create, alter, or drop objects. It only reads from system tables.
Using it
Pick a database
Select a database from the sidebar tree. The list comes from system.databases.
Select a table
Expand the database and choose a table to load its details.
Inspect the schema
Review columns, DDL, indexes, skip indexes, projections, dependencies, and table metadata in the detail panels.
| Page | Route | What it shows | System tables |
|---|---|---|---|
| Data Explorer | /explorer | Database tree; table details: columns, DDL, indexes, projections, skip indexes, dependencies | system.databases, system.tables, system.columns, system.projection_parts, system.data_skipping_indices, system.dictionaries |
Version-dependent panels and behavior
system.data_skipping_indices— available since ClickHouse 20.6. The skip-index panel is hidden on older versions.system.projection_parts— projections were introduced in ClickHouse 21.6. The projections panel is hidden on older versions.- Dependencies — dependency tracking uses the
dependencies_databaseanddependencies_tablearrays insystem.tables. These arrays are populated for materialized views and dictionaries. Direct table references in ad-hoc queries are not tracked. - On clusters with many databases (hundreds), the initial database list query against
system.databasesmay be slow. IncreaseCLICKHOUSE_MAX_EXECUTION_TIMEif needed.
Permissions & access
The Data Explorer shares the tables feature id with all other table pages. Gating or disabling tables affects the explorer too:
CHM_FEATURE_TABLES_ACCESS=authenticated
# Disable entirely
CHM_FEATURE_TABLES_ENABLED=false
# or
CHM_DISABLED_FEATURES=tables# CHM_CONFIG_FILE (TOML)
[features.tables]
access = "authenticated"There is no feature-specific configuration. The global query timeout applies:
CLICKHOUSE_MAX_EXECUTION_TIME=60