Features
Every feature a ClickHouse® database team needs
CHOps provides 30+ features across querying, monitoring, visualization, alerting, backups, access control, and remote administration.
Community Edition (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 results as CSV, JSON, or TSV
Visual EXPLAIN with interactive tree diagrams
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
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
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
Alerting (Email)
SQL-based alert rules evaluated per-node across the cluster
Email alerts included out of the box
Configurable schedules and thresholds
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
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
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 in Community)
CHOps Pro (Commercial License)
Everything in Community, plus:
Remote Cluster Management
ProView 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
SSO & Audit
ProSSO support via any OIDC provider
Audit log with 50+ action types and PDF export
Multi-Channel Alerting
ProSlack channel notifications
Microsoft Teams and Google Chat notifications
PagerDuty incident triggering
Scheduled email reports with HTML formatting
Automated Backups
ProScheduled backups on daily or weekly intervals
Retention policies for automatic cleanup
Scale & Support
ProUnlimited clusters and nodes
Priority support with SLAs
Commercial license