Open source+CHOps ProTwo editions, one GUI for ClickHouse®

The universal GUI and admin tool for the ClickHouse® database.

One UI for self-hosted, VM-based, Kubernetes, and managed ClickHouse®.

Run queries, monitor clusters, profile queries, build dashboards, manage access, and back up data from one browser tab. Start free with the open-source core. Run it across your organization with CHOps Pro.

Start freeCommunity. Apache 2.0. Free forever.
Get CHOps ProFor organizations. Licensed per cluster.
Loading demo...
Features
30+
Chart types
15
Export formats
22
Deployment types
4

Works with every ClickHouse® deployment

  • Self-hosted ClickHouse®
  • VM and bare-metal ClickHouse®
  • ClickHouse® on Kubernetes
  • ClickHouse® Cloud
  • Altinity.Cloud®
  • Aiven for ClickHouse®
  • Any deployment with HTTP interface access

The problem

Stop duct-taping your ClickHouse® stack.

Most teams juggle a pile of tools to run one database. CHOps replaces the patchwork with one interface, and reads from system tables, so it barely touches your storage.

Without CHOps

  • Multiple tools for ClickHouse® database management
  • Grafana and Prometheus, or a similar stack, for basic monitoring
  • Shell scripts and scheduled jobs for backups
  • Raw SQL for user, role, and grant management
  • Query profiling with external tools
  • No historical playback when incidents happen
  • No central audit trail across the team

With CHOps

  • Reads from ClickHouse® system tables: deep insight, negligible storage
  • Browser-based SQL editor with schema-aware autocomplete
  • Built-in monitoring, charts, and alerts to every channel
  • Qurioz: AI SQL generation with instant visualizations
  • Visual RBAC with interactive grant trees
  • Flame graphs and query metrics out of the box
  • DVR-style playback for incident investigation
  • Remote log viewing and restart, even when nodes are downPro
  • SSO and a central Audit LogPro

Universal

One admin tool for every ClickHouse® deployment.

ClickHouse® runs everywhere now: on your servers, on VMs, on Kubernetes, and as a managed service. CHOps manages all of them over the standard ClickHouse® HTTP interface. No lock-in to one platform.

Self-hosted and VM

Full control over ClickHouse® on your own servers, bare metal, or VMs. CHOps connects over HTTP with nothing installed on your database nodes.

Kubernetes

Manage ClickHouse® on Kubernetes, including clusters run by the Altinity® Kubernetes Operator for ClickHouse® or the Official ClickHouse® Kubernetes Operator (early access), from the same interface.

Managed ClickHouse®

Point CHOps at ClickHouse® Cloud, Altinity.Cloud®, or Aiven for ClickHouse®. If it speaks the ClickHouse® HTTP interface, CHOps manages it.

One interface, one skill set, one place to look. Bare metal in your data center or ClickHouse® Cloud: your team manages it the same way in CHOps.

Features

One toolkit. Your whole ClickHouse® database, handled.

Query, monitor, profile, visualize, alert, secure, and back up your clusters from one app. Powerful for experts, approachable for everyone.

Everything below is in the free, open-source core, except items marked Pro which are in CHOps Pro.

Query and Explore

  • SQL editor with ClickHouse® aware autocomplete
  • Qurioz AI writes SQL and charts from plain English
  • Comparison mode to run two queries side by side
  • Tables and Parts explorer with engine detection
  • Export to 22 formats: Parquet, Arrow, ORC, and more
  • Query history, bookmarks, and global search

Monitor and Observe

  • Live Cluster Overview of disk, memory, and CPU
  • Pre-built dashboards for the whole cluster
  • Daily Summary node health report at a glance
  • Spot and kill slow queries in one click
  • DVR-style monitoring playback for incidents
  • Server logs in the browser, no SSH needed
  • Scheduled email reports to your inboxPro

Profile and Tune

  • Query profiler with flame graph views
  • Processors Profile as a pipeline diagram
  • Query Metrics with second-by-second timelines
  • Estimate query cost before you run it
  • Memory Allocator jemalloc efficiency insights
  • Visual EXPLAIN, with AST and pipeline graphs

Dashboards and Charts

  • Custom dashboards with drag-and-drop layout
  • 15 chart types including heatmap and sankey
  • Dashboard Filters for parametrized views
  • AI-assisted chart building from plain English
  • Schema Visualizer and Schema Studio for tables
  • Share queries by link; bookmarks are shared with your team

Operate and Stay Ahead

  • SQL alerts per node to email, Slack, Teams, Google Chat, and PagerDuty
  • Alert templates for each new cluster
  • Kubernetes via the Altinity® or official ClickHouse® operator
  • Queues view for S3, Azure, and replication
  • Merges, mutations, DDL queue, and read-only replicas
  • Crash, error, text, and session log explorer
  • Remote Admin when a node is downPro

Secure, Back Up, and Manage

  • Visual ClickHouse® RBAC with grant trees
  • AES-256-GCM credential encryption, 4 roles
  • Guided BACKUP and RESTORE to S3, GCS, Azure
  • Index and projection management
  • App data backup for disaster recovery
  • SSO (OpenID Connect) and Audit LogPro
  • Scheduled backups, retention, and archivalPro

Two editions

Free to start. Built to run your organization.

CHOps Community is the full open-source core. CHOps Pro is the commercial edition for organizations, with a commercial license, professional support, and no cluster limit.

CHOps Community

For individuals and teams

Open source

$0 forever

The full core under the Apache License 2.0. Self-host it, change it, ship it.

  • SQL editor with AI, autocomplete, history, and export
  • Cluster monitoring and pre-built dashboards
  • Query profiler with flame graphs and DVR playback
  • Custom dashboards with 15 chart types
  • SQL alerts to email, Slack, Teams, Google Chat, and PagerDuty
  • Visual RBAC with grant trees
  • Manual BACKUP and RESTORE to S3, GCS, and Azure
  • Kubernetes Insights for the Altinity® and official ClickHouse® operators
  • Up to 3 clusters and 18 nodes (editable in source)
  • Community support on GitHub
  • Apache License 2.0

CHOps Pro

For organizations

Commercial

Per cluster

One license for each cluster, as many clusters as you run. Professional support included.

Everything in Community, plus:

  • Remote Admin through a sidecar
  • SSO with OpenID Connect
  • Audit Log of actions, sign-ins, and refused access
  • Scheduled backups with retention
  • Scheduled Archival to S3-compatible storage
  • Scheduled email reports
  • No cluster limit: one license for each cluster
  • Professional support with SLAs
  • Commercial license

Already a customer? Sign in to the customer portal for downloads and licenses.

Why CHOps Pro

Built for organizations that run ClickHouse® in production.

Your team gets the same CHOps it already knows, plus the license, support, and controls that an organization needs.

Commercial license

A clear commercial agreement for your legal and procurement teams. No license questions in production.

Professional support

Direct support from the engineers who build CHOps. Escalate an incident to people who know the code.

No cluster limit

One license for each cluster. Add clusters as you grow, with no source edits and no workarounds.

Keeps CHOps open

Pro revenue pays for the open-source core. Every Pro license keeps CHOps free for everyone else.

Pro

Remote Admin

Stay in control when a node goes down.

When a ClickHouse® node goes down, most tools go dark with it. CHOps Pro does not. View server logs, update configuration files, and start, stop, or restart services through a sidecar. No SSH. No CHOps install on the node.

  • View logs even when the database process is unresponsive
  • Update server configuration files remotely
  • Start, stop, and restart ClickHouse® services
  • Lightweight sidecar with encrypted communication

Quickstart

Connect your first cluster in under 5 minutes.

CHOps ships as a Docker image on Docker Hub and GitHub Container Registry. Pull it, run it, open your browser. Nothing is installed on your ClickHouse® servers, and no VPN is needed.

  1. 1Install CHOpsDocker container, standalone binary, or source. Linux, macOS, and Windows.
  2. 2Connect to ClickHouse®Enter host, port, and credentials. Encrypted at rest with AES-256-GCM.
  3. 3Start managingEverything works from your browser. Share access with your team.
# 1. Make an encryption secret (keep it; never change it later)
export ENCRYPTION_SECRET=$(openssl rand -hex 32)

# 2. Start CHOps
docker run -d --name chops -p 3000:3000 \
  -e ENCRYPTION_SECRET="$ENCRYPTION_SECRET" \
  -e SUPER_ADMIN_1=admin \
  -e SUPER_ADMIN_1_PASSWORD=change-this-password \
  -e SUPER_ADMIN_1_EMAIL=admin@example.com \
  -v chops-data:/app/data \
  quantrailadmin1/ch-ops:latest

Then open http://localhost:3000 and sign in with the super-admin user you set. Change the placeholder password before you deploy. Keep your ENCRYPTION_SECRET safe and never change it: a new value makes stored passwords unreadable.

Self-hosting

Self-hosting ClickHouse®, made easy.

The ClickHouse® engine is world-class. The tools to run it yourself never were. Teams had two choices: wrestle monitoring, backups, RBAC, and profiling out of system tables and shell scripts, or pay a managed service and give up control of the data and the bill. CHOps is the third option: the ease of managed, on infrastructure you own.

Your servers. Your data. Your rules.

Run ClickHouse® on bare metal, VMs, or Kubernetes, and manage every cluster from one browser tab.

Run it like a pro without hiring one.

Monitoring, alerting, backups, RBAC, and flame-graph profiling in one place. No dedicated ClickHouse® specialist required.

Open source at the core.

The core is Apache 2.0, with no lock-in. Your database stays on your infrastructure, whichever edition you run.

Talk to us

See CHOps Pro on your own clusters.

Book a walkthrough, get a quote for your clusters, or ask about support. We reply within 1 business day.

  • A live demo on a setup like yours
  • A per-cluster quote for your organization
  • Answers on SSO, audit, and Remote Admin

Book a Demo

Tell us about your ClickHouse® database setup and we will schedule a walkthrough.

0/2000 characters (minimum 30)

A copy of your message will be sent to your email address.

FAQ

Frequently asked questions

CHOps Community is the full open-source core under the Apache License 2.0: SQL editor, Qurioz AI, monitoring, query profiler, dashboards, alerting to email, Slack, Microsoft Teams, Google Chat, and PagerDuty, RBAC, and backup and restore. CHOps Pro is the commercial edition for organizations. It adds Remote Admin through a sidecar, SSO with OpenID Connect, an Audit Log, scheduled backups with retention, Scheduled Archival, scheduled email reports, no cluster limit, and professional support.

CHOps Pro is licensed per cluster. You buy one license for each ClickHouse® cluster that CHOps Pro manages, and you can license as many clusters as you need. To get a quote, contact us or go to the customer portal at pro.ch-ops.io.

Use the CHOps customer portal at pro.ch-ops.io. You sign in, buy licenses for your organization, and download the software and your license file from the same place.

No. CHOps Community under Apache 2.0 is the full software, not a trial. It has a default limit of 3 clusters and 18 nodes. Because you have the source, you can raise that limit with a file edit. CHOps Pro has no cluster limit: you license each cluster you run.

Organizations need more than code. Pro gives you a commercial license, professional support, and the features that teams need at scale: SSO, an Audit Log, Remote Admin, and scheduled backups and reports. Pro revenue also funds the open-source core, so every Pro license keeps CHOps free and maintained.

Qurioz, the built-in AI assistant, works with OpenAI, Google Gemini, Anthropic Claude, and Mistral. You supply your own API key. For teams that do not want data to leave their environment, CHOps also supports your own model on a local Ollama server, so AI SQL generation runs entirely on your infrastructure.

CHOps encrypts all stored database credentials with AES-256-GCM. User passwords are hashed with Argon2id. Sessions expire after 2 hours. Brute-force protection locks an account after 5 failed login attempts within 15 minutes. Rate limiting protects the application from abuse. CHOps Pro adds SSO support and a tamper-proof audit log with verified PDF export for compliance.

Remote Admin is a CHOps Pro feature that lets you manage ClickHouse® database nodes even when the database process is unresponsive. A lightweight sidecar runs on each ClickHouse® node and communicates with CHOps over encrypted channels. Through it, you can view server logs, update ClickHouse® server configuration files, and start, stop, or restart ClickHouse® services. CHOps itself does not need to be installed on the ClickHouse® node.

Yes. CHOps connects through the HTTP interface, which all ClickHouse® Cloud plans support. All features work with ClickHouse® Cloud except Remote Admin, which needs the CHOps sidecar on your nodes. CHOps also works with Altinity.Cloud®, Aiven for ClickHouse®, Kubernetes deployments, and any self-hosted setup.

For CHOps Community, no. CHOps connects over the ClickHouse® HTTP interface with nothing installed on your servers. For Remote Admin (Pro), a lightweight sidecar runs on your ClickHouse® nodes. It communicates with CHOps over encrypted channels and enables remote log viewing, config updates, and service management even when the database process is down.

CHOps uses a local SQLite file (typically under 5 MB) for its own configuration: alerts, dashboards, users, and settings. It does not store your ClickHouse® data. You can also back up the CHOps app data itself to S3, GCS, or Azure for disaster recovery.

Yes. CHOps compiles into a standalone executable with no runtime dependencies, for Linux x64, macOS ARM, and Windows x64. Docker images and Docker Compose files are also available.

CHOps is tested on ClickHouse® 26.3 LTS and 26.8 LTS. Older and newer versions should work, but they are not tested. CHOps connects through the HTTP interface, which is stable across versions.

Yes. The team behind CHOps also provides ClickHouse® database consultancy, performance tuning, migration services, and managed database operations through Quantrail.

Run ClickHouse® with confidence.

Start free in two minutes. Move to CHOps Pro when your organization needs SSO, audit, Remote Admin, and support.

Need help beyond the tool? The team behind CHOps also provides ClickHouse® consultancy, performance tuning, migration, and managed operations. Quantrail services