Features

Every feature a ClickHouse® database team needs, for every cluster

CHOps is a universal GUI and admin tool for the ClickHouse® database. It brings querying, monitoring, visualization, alerting, backups, access control, and remote administration into one interface that works across self-hosted, VM, Kubernetes, and managed ClickHouse®.

Below is the full feature set, grouped into the free open-source edition and CHOps Pro. You can see exactly what each part does before you install anything. Every feature reads from the standard ClickHouse® interfaces, with no agents on your database nodes, so the same tools apply whether a cluster runs on bare metal, on Kubernetes with the Altinity® or official ClickHouse® Kubernetes Operator, or on a managed service like ClickHouse® Cloud, Altinity® Cloud, or Aiven for ClickHouse®.

CHOps (Free, AGPL)

SQL Editor with AI

AI SQL generation from plain English
ClickHouse® database-aware syntax highlighting and autocomplete
Query history with recent queries saved and searchable
Bookmarks synced across devices
Export to 20+ formats including Parquet, Arrow, and ORC
Visual EXPLAIN with interactive tree diagrams
Learn more →

Cluster Monitoring

Cluster overview with disk, memory, CPU, uptime, version
Query inspector to view and kill running queries
Table sizes, part counts, compression ratios
Merge and mutation tracking with progress
Searchable server logs with severity filtering
DDL queue and replica status monitoring
Learn more →

Query Profiler & DVR Playback

Flame graph visualization for slow query analysis
Per-second query metrics timeline by query type
DVR-style monitoring playback with media controls
Drill into failed queries and error logs at any point in time
Learn more →

Dashboards & Charts

Custom dashboards with drag-and-drop chart layout
12+ chart types: bar, line, pie, heatmap, sankey, treemap, candlestick, and more
AI-assisted chart building from natural language
Learn more →

Alerting (Email)

SQL-based alert rules evaluated per-node across the cluster
Email alerts included out of the box
Configurable schedules and thresholds
Learn more →

Access Control & RBAC

App-level roles: superadmin, admin, editor, readonly
Visual ClickHouse® database RBAC with interactive grant trees
AES-256-GCM credential encryption at rest
Argon2id password hashing with automatic session expiry
Brute-force protection and rate limiting
Learn more →

Backup, Restore & Indexes

Guided BACKUP and RESTORE interface
S3, Google Cloud Storage, Azure Blob storage profiles
Index and projection management
App data backup for disaster recovery
Learn more →

Deployment

Official Docker image with Docker Compose
Single executable for Linux and macOS
Production guide with Caddy (HTTPS) and systemd
Multi-cluster support (up to 3 clusters / 18 nodes, editable in source)
Learn more →

CHOps Pro (Commercial License)

Everything in CHOps, plus:

Remote Cluster Management

Pro
View server logs even when the database process is down
Update ClickHouse® server configuration files remotely
Start, stop, and restart ClickHouse® services
Lightweight agent with encrypted communication
Learn more →

SSO & Audit

Pro
SSO support via any OIDC provider
Audit log with 50+ action types and PDF export
Learn more →

Multi-Channel Alerting

Pro
Slack channel notifications
Microsoft Teams and Google Chat notifications
PagerDuty incident triggering
Scheduled email reports with HTML formatting
Learn more →

Automated Backups

Pro
Scheduled backups on daily or weekly intervals
Retention policies for automatic cleanup
Learn more →

Scale & Support

Pro
Higher cluster and node limits, set by license key
Priority support with SLAs
Commercial license
Learn more →
Get CHOpsorBook a Demo for Pro