
A JOIN runs out of memory or is very slow
Fix a ClickHouse JOIN that runs out of memory or runs slowly. See why hash joins use the right table and how to use join_algorithm, grace_hash and dictionaries.
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.
Works with every ClickHouse® deployment
The problem
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.
Universal
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.
Full control over ClickHouse® on your own servers, bare metal, or VMs. CHOps connects over HTTP with nothing installed on your database nodes.
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.
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
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.
Two editions
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.
For individuals and teams
$0 forever
The full core under the Apache License 2.0. Self-host it, change it, ship it.
For organizations
Per cluster
One license for each cluster, as many clusters as you run. Professional support included.
Everything in Community, plus:
Already a customer? Sign in to the customer portal for downloads and licenses.
Why CHOps Pro
Your team gets the same CHOps it already knows, plus the license, support, and controls that an organization needs.
A clear commercial agreement for your legal and procurement teams. No license questions in production.
Direct support from the engineers who build CHOps. Escalate an incident to people who know the code.
One license for each cluster. Add clusters as you grow, with no source edits and no workarounds.
Pro revenue pays for the open-source core. Every Pro license keeps CHOps free for everyone else.
Remote Admin
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.
Quickstart
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. 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
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.
Run ClickHouse® on bare metal, VMs, or Kubernetes, and manage every cluster from one browser tab.
Monitoring, alerting, backups, RBAC, and flame-graph profiling in one place. No dedicated ClickHouse® specialist required.
The core is Apache 2.0, with no lock-in. Your database stays on your infrastructure, whichever edition you run.
Talk to us
Book a walkthrough, get a quote for your clusters, or ask about support. We reply within 1 business day.
FAQ
Blog
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