Skip to main content

​
Open-source

agx is a desktop application built with Tauri and SvelteKit that provides a modern interface for exploring and querying data using ClickHouse’s embedded database engine (chdb).
  • Leverage ch-db when running the native application.
  • Can connect to a ClickHouse instance when running the web instance.
  • Monaco editor so you’ll feel at home.
  • Multiple and evolving data visualizations.
ch-ui is a simple React.js app interface for ClickHouse databases designed for executing queries and visualizing data. Built with React and the ClickHouse client for web, it offers a sleek and user-friendly UI for easy database interactions.Features:
  • ClickHouse Integration: Easily manage connections and execute queries.
  • Responsive Tab Management: Dynamically handle multiple tabs, such as query and table tabs.
  • Performance Optimizations: Utilizes Indexed DB for efficient caching and state management.
  • Local Data Storage: All data is stored locally in the browser, ensuring no data is sent anywhere else.
ChartDB is a free and open-source tool for visualizing and designing database schemas, including ClickHouse, with a single query. Built with React, it provides a seamless and user-friendly experience, requiring no database credentials or signup to get started.Features:
  • Schema Visualization: Instantly import and visualize your ClickHouse schema, including ER diagrams with materialized views and standard views, showing references to tables.
  • AI-Powered DDL Export: Generate DDL scripts effortlessly for better schema management and documentation.
  • Multi-SQL Dialect Support: Compatible with a range of SQL dialects, making it versatile for various database environments.
  • No Signup or Credentials Needed: All functionality is accessible directly in the browser, keeping it frictionless and secure.
ChartDB Source Code.
CHOps is a free, open-source, self-hosted web dashboard for administering and monitoring ClickHouse clusters. It wraps ClickHouse’s HTTP interface in a browser UI for running SQL, inspecting slow queries, configuring alerts, managing backups, and controlling access. It works with ClickHouse deployments reachable over HTTP. CHOps currently supports ClickHouse 26.3 LTS; other recent versions work, though there may be minor feature gaps.Features:
  • SQL editor with autocomplete, EXPLAIN types, export results in 22 formats, query profiler and a query metrics timeline.
  • Cluster overview: live query monitor with kill controls, query analytics and log, table and parts inspection, merges and mutations, distributed DDL queue.
  • Custom dashboards with a chart builder, 10+ chart types, and configurable grid layouts.
  • Monitoring with DVR-style playback for replaying historical metrics frame by frame.
  • SQL-based alert rules with threshold evaluation and email notifications.
  • Access control: ClickHouse user and role management, grant visualization, and settings-profile editing.
  • Backup and restore orchestration to S3-compatible storage, with backup discovery and storage profile management.
  • Index tools: data-skipping index visualization, projection management, and secondary index creation.
  • Exception, error, and text log viewers with calendar heatmaps and filtered search.
  • Deploys as a single self-contained binary, via Docker, or from source.
CHOps Source Code.
LibreDB Studio is a self-hosted, MIT-licensed database IDE that runs in the browser and deploys next to the database: a container, a Helm chart, an OLM operator, or an npm package embedded in another product. The ClickHouse provider talks to the documented HTTP interface on 8123/8443 and carries no driver dependency.Features:
  • SQL editor built on Monaco with schema-aware autocomplete, multi-tab execution, and EXPLAIN rendered as a plan tree.
  • Schema explorer with virtualized result grids, filtering, and CSV/JSON export.
  • Monitoring drawn from the system tables: server overview and part sizes from system.metrics, system.parts and system.disks, finished statements from system.query_log, in-flight statements from system.processes, with a kill control.
  • ClickHouse in the same interface as PostgreSQL, MySQL, Oracle, SQL Server, SQLite, MongoDB, Redis, Couchbase and Apache Druid, so an analytical store and the OLTP database feeding it are one browser tab.
  • OIDC single sign-on, role-based access, and a query audit trail, all in the MIT build.
LibreDB Studio ClickHouse provider reference.
DataStoria is an AI-powered web console application that manages multiple ClickHouse clusters in one place.Features:
  • AI-Powered Intelligence: Use natural language to explore data, optimize and fix SQL queries, and visualize your data.
  • Official ClickHouse Agent Skills Integration: Leverage official best practices to ask AI for database optimizations and suggestions.
  • Smart Error Diagnostics: Pinpoint syntax errors instantly with precise line and column highlighting, and get AI-powered fix suggestions with one click.
  • System Table Inspection: Dive deep into system.query_log, system.query_views_log, system.zookeeper, system.ddl_distributed_queue, system.part_log, and system.processes with a powerful visualization dashboard and filters to quickly understand your cluster.
  • One-Click Explain: Instantly understand query execution plans with visual AST and pipeline views.
  • Dependency Graph: Visualize table relationships and trace data flows through Materialized Views, Distributed tables, and external systems.
  • Cluster Monitoring: Monitor all nodes with real-time metrics, merge operations, replication status, query performance, and more.
  • Privacy & Security: All SQL queries run directly from your browser to your ClickHouse server, ensuring complete privacy.
DataStoria documentation.
DataPup is a modern, AI-assisted, cross-platform database client with native ClickHouse support.Features:
  • AI-powered SQL query assistance with intelligent suggestions
  • Native ClickHouse connection support with secure credential handling
  • Beautiful, accessible interface with multiple themes (Light, Dark, and colorful variants)
  • Advanced query result filtering and exploration
  • Cross-platform support (macOS, Windows, Linux)
  • Fast and responsive performance
  • Open-source and MIT licensed
Dory AI-native SQL workspace with first-class ClickHouse support, AI built-in.Features:
  • AI Copilot for SQL generation, explanation, and debugging
  • Manage and query multiple ClickHouse clusters from a unified workspace
  • Schema-aware SQL autocomplete and multi-tab query workspace
  • Interactive query result exploration with filtering and visualization
  • AI-powered table summaries for understanding datasets
  • Direct ClickHouse connections with SSH tunnel support
  • Modern developer-friendly interface with light, dark, and theme support
  • Cross-platform desktop app (macOS, Windows, Linux), and Docker support
  • Open-source and MIT licensed
ClickHouse Schema Flow Visualizer is an open-source web application for visualizing ClickHouse table relationships. It connects to a ClickHouse instance, parses system.tables metadata (engine types, dependencies, materialized view SELECTs), and renders interactive table-level data-flow diagrams alongside column-level relationships with the transformation expression labelled on every edge. Diagrams are laid out with Dagre and rendered as plain inline SVG — no client-side diagramming runtime is loaded.Features:
  • Browse ClickHouse databases and tables with an intuitive sidebar
  • Data Flow view: table-level upstream sources and downstream materialized views
  • Relationships view: column-level mapping with the parsed transformation expression on each edge (e.g. toStartOfHour(scheduled_departure), avgState(delay_minutes))
  • Engine-aware icons and colour coding for MergeTree, Replicated*, Distributed, MaterializedView, and Dictionary
  • Click a column in the Relationships view to highlight its full data path through the pipeline
  • Live sidebar filter and a Ctrl+K / ⌘K command palette to jump to any table, column, or engine
  • Optional metadata overlay showing row counts and on-disk size per table
  • Export the current diagram as a self-contained HTML file
  • TLS connection to ClickHouse, with optional skip-verify and custom CA / client certificates
ClickHouse Schema Flow Visualizer - source code
Web interface for ClickHouse in the Tabix project.Features:
  • Works with ClickHouse directly from the browser without the need to install additional software.
  • Query editor with syntax highlighting.
  • Auto-completion of commands.
  • Tools for graphical analysis of query execution.
  • Colour scheme options.
Tabix documentation.
HouseOps is a UI/IDE for OSX, Linux and Windows.Features:
  • Query builder with syntax highlighting. View the response in a table or JSON view.
  • Export query results as CSV or JSON.
  • List of processes with descriptions. Write mode. Ability to stop (KILL) a process.
  • Database graph. Shows all tables and their columns with additional information.
  • A quick view of the column size.
  • Server configuration.
The following features are planned for development:
  • Database management.
  • User management.
  • Real-time data analysis.
  • Cluster monitoring.
  • Cluster management.
  • Monitoring replicated and Kafka tables.
LightHouse is a lightweight web interface for ClickHouse.Features:
  • Table list with filtering and metadata.
  • Table preview with filtering and sorting.
  • Read-only query execution.
Redash is a platform for data visualization.Supports for multiple data sources including ClickHouse, Redash can join results of queries from different data sources into one final dataset.Features:
  • Powerful editor of queries.
  • Database explorer.
  • Visualization tool that allows you to represent data in different forms.
Grafana is a platform for monitoring and visualization.“Grafana allows you to query, visualize, alert on and understand your metrics no matter where they are stored. Create, explore, and share dashboards with your team and foster a data-driven culture. Trusted and loved by the community” — grafana.com.ClickHouse data source plugin provides support for ClickHouse as a backend database.
qryn is a polyglot, high-performance observability stack for ClickHouse (formerly cLoki) with native Grafana integrations allowing users to ingest and analyze logs, metrics and telemetry traces from any agent supporting Loki/LogQL, Prometheus/PromQL, OTLP/Tempo, Elastic, InfluxDB and many more.Features:
  • Built-in Explore UI and LogQL CLI for querying, extracting and visualizing data
  • Native Grafana APIs support for querying, processing, ingesting, tracing and alerting without plugins
  • Powerful pipeline to dynamically search, filter and extract data from logs, events, traces and beyond
  • Ingestion and PUSH APIs transparently compatible with LogQL, PromQL, InfluxDB, Elastic and many more
  • Ready to use with Agents such as Promtail, Grafana-Agent, Vector, Logstash, Telegraf and many others
DBeaver - universal desktop database client with ClickHouse support.Features:
  • Query development with syntax highlight and autocompletion.
  • Table list with filters and metadata search.
  • Table data preview.
  • Full-text search.
By default, DBeaver does not connect using a session (the CLI for example does). If you require session support (for example to set settings for your session), edit the driver connection properties and set session_id to a random string (it uses the http connection under the hood). Then you can use any setting from the query window.
clickhouse-cli is an alternative command-line client for ClickHouse, written in Python 3.Features:
  • Autocompletion.
  • Syntax highlighting for the queries and data output.
  • Pager support for the data output.
  • Custom PostgreSQL-like commands.
clickhouse-flamegraph is a specialized tool to visualize the system.trace_log as flamegraph.
cickhouse-plantuml is a script to generate PlantUML diagram of tables’ schemes.
ClickHouse table graph is a simple CLI tool for visualizing dependencies between ClickHouse tables. This tool retrieves connections between tables from system.tables table and builds dependencies flowchart in mermaid format. With this tool you can easily visualize table dependencies and understand the data flow in your ClickHouse database. Thanks to mermaid, the resulting flowchart looks attractive and can be easily added to your markdown documentation.
xeus-clickhouse is a Jupyter kernal for ClickHouse, which supports query CH data using SQL in Jupyter.
MindsDB is an open-source AI layer for databases including ClickHouse that allows you to effortlessly develop, train and deploy state-of-the-art machine learning models. MindsDB Studio(GUI) allows you to train new models from database, interpret predictions made by the model, identify potential data biases, and evaluate and visualize model accuracy using the Explainable AI function to adapt and tune your Machine Learning models faster.
DBM DBM is a visual management tool for ClickHouse!Features:
  • Support query history (pagination, clear all, etc.)
  • Support selected sql clauses query
  • Support terminating query
  • Support table management (metadata, delete, preview)
  • Support database management (delete, create)
  • Support custom query
  • Support multiple data sources management(connection test, monitoring)
  • Support monitor (processor, connection, query)
  • Support migrating data
Bytebase is a web-based, open source schema change and version control tool for teams. It supports various databases including ClickHouse.Features:
  • Schema review between developers and DBAs.
  • Database-as-Code, version control the schema in VCS such GitLab and trigger the deployment upon code commit.
  • Streamlined deployment with per-environment policy.
  • Full migration history.
  • Schema drift detection.
  • Backup and restore.
  • RBAC.
Zeppelin-Interpreter-for-ClickHouse is a Zeppelin interpreter for ClickHouse. Compared with the JDBC interpreter, it can provide better timeout control for long-running queries.
ClickCat is a friendly user interface that lets you search, explore and visualize your ClickHouse Data.Features:
  • An online SQL editor which can run your SQL code without any installing.
  • You can observe all processes and mutations. For those unfinished processes, you can kill them in ui.
  • The Metrics contain Cluster Analysis, Data Analysis, and Query Analysis.
ClickVisual ClickVisual is a lightweight open source log query, analysis and alarm visualization platform.Features:
  • Supports one-click creation of analysis log libraries
  • Supports log collection configuration management
  • Supports user-defined index configuration
  • Supports alarm configuration
  • Support permission granularity to library and table permission configuration
ClickHouse-Mate is an angular web client + user interface to search and explore data in ClickHouse.Features:
  • ClickHouse SQL Query autocompletion
  • Fast Database and Table tree navigation
  • Advanced result Filtering and Sorting
  • Inline ClickHouse SQL documentation
  • Query Presets and History
  • 100% browser based, no server/backend
The client is available for instant usage through github pages: https://metrico.github.io/clickhouse-mate/
Uptrace is an APM tool that provides distributed tracing and metrics powered by OpenTelemetry and ClickHouse.Features:
  • OpenTelemetry tracing, metrics, and logs.
  • Email/Slack/PagerDuty notifications using AlertManager.
  • SQL-like query language to aggregate spans.
  • Promql-like language to query metrics.
  • Pre-built metrics dashboards.
  • Multiple users/projects via YAML config.
clickhouse-monitoring is a simple Next.js dashboard that relies on system.* tables to help monitor and provide an overview of your ClickHouse cluster.Features:
  • Query monitor: current queries, query history, query resources (memory, parts read, file_open, …), most expensive queries, most used tables or columns, etc.
  • Cluster monitor: total memory/CPU usage, distributed queue, global settings, mergetree settings, metrics, etc.
  • Tables and parts information: size, row count, compression, part size, etc., at the column level detail.
  • Useful tools: Zookeeper data exploration, query EXPLAIN, kill queries, etc.
  • Visualization metric charts: queries and resource usage, number of merges/mutation, merge performance, query performance, etc.
CKibana is a lightweight service that allows you to effortlessly search, explore, and visualize ClickHouse data using the native Kibana UI.Features:
  • Translates chart requests from the native Kibana UI into ClickHouse query syntax.
  • Supports advanced features such as sampling and caching to enhance query performance.
  • Minimizes the learning cost for users after migrating from ElasticSearch to ClickHouse.
Telescope is a modern web interface for exploring logs stored in ClickHouse. It provides a user-friendly UI for querying, visualizing, and managing log data with fine-grained access control.Features:
  • Clean, responsive UI with powerful filters and customizable field selection.
  • FlyQL syntax for intuitive and expressive log filtering.
  • Time-based graph with group-by support, including nested JSON, Map, and Array fields.
  • Optional raw SQL WHERE query support for advanced filtering (with permission checks).
  • Saved Views: persist and share custom UI configurations for queries and layout.
  • Role-based access control (RBAC) and GitHub authentication integration.
  • No extra agents or components required on the ClickHouse side.
Telescope Source Code · Live Demo
ClickLens is a modern, powerful, and user-friendly web interface for managing and monitoring ClickHouse databases. It 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
ClickLens Source Code
CHouse UI is an open-source, self-hosted ClickHouse web interface built for teams running ClickHouse in production. Most tools nail one piece — a query workspace, a dashboard, an AI assistant, a cluster monitor; CHouse UI is the combination: a team access layer paired with multi-cluster fleet monitoring and an autonomous, read-only AI SRE. Unlike clients that need direct database credentials, it stores them encrypted server-side and gates access with its own Role-Based Access Control (RBAC) layer, so the browser never sees a ClickHouse password.Features:
  • Team access & security - App-level RBAC (predefined + custom roles, granular per-database/table data-access rules), audit logging with real session context, and AES-256-GCM encrypted server-side credentials.
  • Multi-cluster fleet - Watch every configured cluster in one pane (status, memory, active queries, exceptions, trend sparklines), each card polling independently, backed by a backend snapshot poller.
  • Chouse AI — Fleet Doctor - An autonomous, read-only AI SRE: it scans the fleet with a guarded system.*-only SELECT tool (ClickHouse readonly=1), pins root causes, and writes a structured report with a heavy-query deep-dive and suggested rewrites. It never mutates the cluster.
  • AI in the monitoring tabs - “Optimize with Chouse AI” on a Query Logs row (rewrite + before→after EXPLAIN estimate + open in the SQL workspace), plus one-click “Diagnose” on a system.errors row or a part-log entry.
  • Threshold alerts - Node memory %, per-query memory, and long-running-query rules delivered to Slack and email — with an autonomous root-cause analysis attached on breach.
  • Full workspace - Monaco SQL editor, schema explorer, live-query view with kill support, ClickHouse-native monitoring (memory breakdown, parts/merges, replica lag, latency percentiles), and data import/export.
Open-source (Apache 2.0), on-prem first — every feature ships in the box, with no paid tier.CHouse UI Source Code
clickhouse-flow is an open-source tool for visualizing data flows and dependencies between ClickHouse tables, views, and materialized views.Features:
  • Automatically builds a schema graph from ClickHouse metadata.
  • Visualizes data flows through materialized views.
  • Interactive UI for exploring schema structure.
  • Export diagrams as PDF or SVG for documentation and sharing.
  • Docker-based deployment for quick setup in development environments.
Beekeeper Studio is a free, open-source SQL editor and database manager with support for ClickHouse.Features:
  • Modern SQL editor with autocomplete and multi-tab query execution.
  • Schema browser for tables, views, and columns.
  • Save and organize favorite queries.
  • Cross-platform desktop app (Windows, macOS, Linux), plus a self-hosted/web edition.
Beekeeper Studio and ClickHouse guide · GitHub

​
Commercial

ADQM Notebook is a notebook-style SQL workspace included in the Enterprise edition of Arenadata QuickMarts (ADQM), the column-oriented DBMS built on ClickHouse by Arenadata. It extends the built-in ClickHouse web interface with multi-cell notebooks, interactive results, query plan analysis, and a cluster-wide schema browser, and is available out of the box at /notebook on the HTTP port (8123) of an ADQM host, next to /play, or through Chproxy.Features:
  • SQL and Markdown cells, up to five statements per cell, and memory, time, and thread limits per notebook or cell.
  • SQL editor with syntax highlighting, autocompletion, {{variable}} substitution, and Beautify SQL.
  • Results as a sortable, searchable grid with per-column NULL share, unique count, and value range.
  • Line, area, and bar charts; downloads as CSV, TSV, JSON, JSONLines, or Parquet.
  • Estimated and actual query plans, EXPLAIN PIPELINE and logical views, and findings with suggested fixes.
  • Query statistics from system.query_log with a per-node breakdown; run history for the last five runs.
  • Databases panel for the local host or the whole cluster with column statistics and ready-made queries.
  • Dependency graph of tables, views, materialized views, dictionaries, and projections.
  • Live view of running queries with a KILL button.
  • Access through Chproxy as a single entry point to the cluster, with queries balanced across all hosts.
  • Auto-save, JSON export and import, notebook storage on the ClickHouse server, and sharing by link.
ProbeDeck is an iOS and iPadOS client for monitoring and querying ClickHouse.Features:
  • ProbeDeck shows running queries, replicas, parts, merges, mutations, disks, and server metrics.
  • You can stop queries with KILL QUERY and mutations with KILL MUTATION.
  • You can browse schemas and data or run SQL in the editor.
  • ProbeDeck connects over HTTP(S) through the device network or an SSH tunnel.
  • ProbeDeck stores credentials in the iOS Keychain and supports a read-only mode for each connection.
  • The app includes an offline demo with bundled data.
Free users can monitor a server and run read-only SQL. They can save one connection. ProbeDeck Pro adds kill controls, writes, DDL, and unlimited saved connections.See Connect ProbeDeck to ClickHouse for connection instructions.
DataGrip is a database IDE from JetBrains with dedicated support for ClickHouse. It is also embedded in other IntelliJ-based tools: PyCharm, IntelliJ IDEA, GoLand, PhpStorm and others.Features:
  • Very fast code completion.
  • ClickHouse syntax highlighting.
  • Support for features specific to ClickHouse, for example, nested columns, table engines.
  • Data Editor.
  • Refactorings.
  • Search and Navigation.
Yandex DataLens is a service of data visualization and analytics.Features:
  • Wide range of available visualizations, from simple bar charts to complex dashboards.
  • Dashboards could be made publicly available.
  • Support for multiple data sources including ClickHouse.
  • Storage for materialized data based on ClickHouse.
DataLens is available for free for low-load projects, even for commercial use.
Holistics is a full-stack data platform and business intelligence tool.Features:
  • Automated email, Slack and Google Sheet schedules of reports.
  • SQL editor with visualizations, version control, auto-completion, reusable query components and dynamic filters.
  • Embedded analytics of reports and dashboards via iframe.
  • Data preparation and ETL capabilities.
  • SQL data modelling support for relational mapping of data.
Looker is a data platform and business intelligence tool with support for 50+ database dialects including ClickHouse. Looker is available as a SaaS platform and self-hosted. Users can use Looker via the browser to explore data, build visualizations and dashboards, schedule reports, and share their insights with colleagues. Looker provides a rich set of tools to embed these features in other applications, and an API to integrate data with other applications.Features:
  • Easy and agile development using LookML, a language which supports curated Data Modeling to support report writers and end-users.
  • Powerful workflow integration via Looker’s Data Actions.
How to configure ClickHouse in Looker.
SeekTable is a self-service BI tool for data exploration and operational reporting. It is available both as a cloud service and a self-hosted version. Reports from SeekTable may be embedded into any web-app.Features:
  • Business users-friendly reports builder.
  • Powerful report parameters for SQL filtering and report-specific query customizations.
  • Can connect to ClickHouse both with a native TCP/IP endpoint and a HTTP(S) interface (2 different drivers).
  • It is possible to use all power of ClickHouse SQL dialect in dimensions/measures definitions.
  • Web API for automated reports generation.
  • Supports reports development flow with account data backup/restore; data models (cubes) / reports configuration is a human-readable XML and can be stored under version control system.
SeekTable is free for personal/individual usage.How to configure ClickHouse connection in SeekTable.
Chadmin is a simple UI where you can visualize your currently running queries on your ClickHouse cluster and info about them and kill them if you want.
TABLUM.IO — an online query and analytics tool for ETL and visualization. It allows connecting to ClickHouse, query data via a versatile SQL console as well as to load data from static files and 3rd party services. TABLUM.IO can visualize data results as charts and tables.Features:
  • ETL: data loading from popular databases, local and remote files, API invocations.
  • Versatile SQL console with syntax highlight and visual query builder.
  • Data visualization as charts and tables.
  • Data materialization and sub-queries.
  • Data reporting to Slack, Telegram or email.
  • Data pipelining via proprietary API.
  • Data export in JSON, CSV, SQL, HTML formats.
  • Web-based interface.
TABLUM.IO can be run as a self-hosted solution (as a docker image) or in the cloud.Learn more about the product at TABLUM.IO
CKMAN is a tool for managing and monitoring ClickHouse clusters!Features:
  • Rapid and convenient automated deployment of clusters through a browser interface
  • Clusters can be scaled or scaled
  • Load balance the data of the cluster
  • Upgrade the cluster online
  • Modify the cluster configuration on the page
  • Provides cluster node monitoring and zookeeper monitoring
  • Monitor the status of tables and partitions, and monitor slow SQL statements
  • Provides an easy-to-use SQL execution page
1bench is a native desktop GUI for multiple databases with first-class ClickHouse support — spanning server overview, schema management, vector search, and large result-set browsing.Features:
  • Server overview on connect — version, uptime, running queries, active merges, parts and storage sizes, replica status, clusters and nodes at a glance.
  • Visual query builder (column pickers, filters, sort, limit) alongside a Monaco SQL editor with syntax highlighting and query history per connection.
  • Visual CREATE TABLE wizard supporting MergeTree variants, ORDER BY, PARTITION BY, SETTINGS, and Nullable() auto-wrapping.
  • Native ClickHouse type handling — Nullable, Array, LowCardinality, nested objects.
  • Vector search support — Array(Float32) embedding columns rendered as compact vector cells, 2D embedding visualization, and Find Similar via cosineDistance.
  • Inline data editing in result tables with batched save, plus CSV/JSON/SQL export and import using ClickHouse’s native formats.
  • Connection options: HTTP/HTTPS, SSH tunnel for private clusters behind a firewall, optional read-only mode for safe production browsing.
  • Works with ClickHouse Cloud and self-hosted.
ADQM Control (Arenadata QuickMarts Control) is an observability platform for ClickHouse clusters deployed as Arenadata QuickMarts (ADQM), the column-oriented DBMS built on ClickHouse by Arenadata. It combines host metrics from Prometheus with data about hosts, tables, and queries collected from the cluster to show how tables grow, how queries behave, and where hosts are under pressure, across one or many ADQM clusters. ADQM Control is deployed as a separate cluster with Arenadata Cluster Manager (ADCM) and stores collected data in PostgreSQL.Features:
  • Heat map of host states for the selected ADQM cluster.
  • Related alerts grouped into incidents by time, with adjustable sensitivity.
  • Table size, rows, and request counts over time, with skew and imbalance metrics across hosts.
  • Per-column compressed and uncompressed size, compression savings, and codec, with graphs.
  • Complete query history with status, exception codes, duration, memory, and rows and bytes read and written.
  • Query filters by text, table, user, host, duration, status, and exception-code presets.
  • Query graphs by duration, user, and kind; per-host load graphs with anomaly detection.
  • Threshold alerts on host resources that explain the problem and recommend a fix.
Last modified on September 8, 2026