chmonitor
Features

Settings

View all ClickHouse server settings with non-default values highlighted, plus MergeTree and Replicated MergeTree engine settings.

Audit ClickHouse configuration without SQL — see every server setting with non-default values highlighted, plus MergeTree and Replicated MergeTree engine settings.

Prop

Type

What it does

The Settings section has two distinct purposes.

  • ClickHouse server settings (at /settings) queries system.settings to list all server-level configuration values. The table highlights values that have been changed from their defaults, making it easy to audit non-default configuration. Use it to spot unexpected overrides or verify that a setting change took effect.
  • MergeTree settings (at /mergetree-settings) queries system.merge_tree_settings to show engine-specific settings for MergeTree tables. The Replicated MergeTree settings page (at /replicated-merge-tree-settings) queries system.replicated_merge_tree_settings.

Two kinds of settings

This section covers ClickHouse server settings (read-only, from system tables). chmonitor also has an application-level settings page where operators configure the dashboard itself — connection details, theme preferences, and feature toggles. See the Settings reference for that.

Pages

PageRouteWhat it showsSystem tables
Settings/settingsAll server settings; highlights non-defaultssystem.settings
MergeTree Settings/mergetree-settingsMergeTree engine settings and valuessystem.merge_tree_settings
Replicated MergeTree Settings/replicated-merge-tree-settingsReplicated MergeTree settings; flags changed-from-defaultsystem.replicated_merge_tree_settings

Using it

  • Open /settings to review all server settings; non-default values are highlighted so you can spot unexpected overrides or confirm a change took effect.
  • Open /mergetree-settings to inspect MergeTree engine settings, and /replicated-merge-tree-settings for Replicated MergeTree settings with changed-from-default values flagged.
  • To change a setting, use ClickHouse SQL (SET, ALTER TABLE ... MODIFY SETTING) or edit the server config — these pages are read-only.

Permissions & access

All three pages share the settings feature id.

Recommended if settings values are sensitive:

CHM_FEATURE_SETTINGS_ACCESS=authenticated
CHM_FEATURE_SETTINGS_ENABLED=false
[features.settings]
enabled = true
access = "authenticated"

Configuration

No feature-specific environment variables. The pages are read-only — chmonitor never writes to ClickHouse settings.

Notes & limitations

  • system.settings reflects the settings in effect for the connection user, not global defaults. User-level overrides via profiles can differ from server defaults.
  • system.merge_tree_settings and system.replicated_merge_tree_settings are available on all recent ClickHouse versions (23.x+). On older versions they may be absent, in which case the page shows an empty state.
  • These pages are read-only. To change a setting, use ClickHouse SQL (SET, ALTER TABLE ... MODIFY SETTING) or edit the server config.

Settings reference

Every dashboard configuration setting in one place.

Feature permissions

Gate or disable features per section.

ClickHouse system.settings

Upstream reference for server settings.

ClickHouse system.merge_tree_settings

Upstream reference for MergeTree settings.

User Connections (Server Storage)

Save personal ClickHouse connections to the server so they sync across devices when signed in with Clerk — encrypted at rest with AES-256-GCM.

AI Agent

The AI Agent turns natural language into ClickHouse insights using read-only tools, expert skills, and plan-and-verify reasoning.

On this page

What it doesPagesUsing itPermissions & accessConfigurationNotes & limitationsRelated