Open Source · Feature-Rich · The All-in-One Admin Tool
The only tool you will ever need for ClickHouse® database.
Self-hosted, cloud, Kubernetes. CHOps connects to all of them from a single interface. Monitor clusters, manage users, debug queries, and investigate incidents without switching tools. The only ClickHouse® database admin tool that DBAs, SREs, and developers all log into.
Built by the ClickHouse® database experts at Quantrail. Tested on every ClickHouse® LTS release. Connect your first cluster in under 5 minutes.
The Problem
One tool instead of a patchwork
Most ClickHouse® database teams stitch together multiple tools for basic administration. CHOps replaces all of that with a single interface.
Without CHOps
- ✕ Multiple tools for ClickHouse® database management
- ✕ Grafana + Prometheus or similar stack for basic monitoring
- ✕ Shell scripts and cron jobs for backups
- ✕ Raw SQL for user, role, and grant management
- ✕ Query profiling with external tools, no evaluation of query metrics by query type
- ✕ No historical playback when incidents happen
- ✕ No centralized audit trail across the team
With CHOps
- ✓ Browser-based SQL editor with AI and autocomplete
- ✓ Built-in monitoring and visualization builder
- ✓ Visual backup management with major cloud providers
- ✓ Visual RBAC with interactive grant trees
- ✓ Flame graphs for query profiling and off-the-shelf query metrics visualization
- ✓ DVR-style playback for incident investigation
- ✓ Remote log viewing and service restart even when nodes are down (Pro)
- ✓ SSO, audit logs, and multi-channel alerting (Pro)
Get Started
Connect your first cluster in under 5 minutes.
CHOps connects over the standard ClickHouse® database HTTP interface. No agents on your database servers. No VPN required. Manage remote clusters across regions from a single browser tab.
Install CHOps
Docker container, standalone binary, or source. Linux and macOS.
Connect to ClickHouse®
Enter host, port, and credentials. Encrypted at rest with AES-256-GCM.
Start managing
Everything works from your browser. Share access with your team.
Works with every ClickHouse® database deployment
CHOps Community (Free)
Everything you need to manage ClickHouse® database
All core features are free and open source under the AGPL license. No artificial limitations.
Query and Explore
- SQL editor with ClickHouse® database-aware autocomplete
- AI SQL generation from plain English
- Query history, bookmarks synced across devices
- Export results as CSV, JSON, or TSV
- Visual EXPLAIN with interactive tree diagrams
Monitor and Observe
- Pre-built dashboards for CPU, memory, disk, merges, replication
- Spot slow queries and kill them with one click
- Query profiler with flame graph visualization
- DVR-style monitoring playback for incident investigation
- Per-second resource timelines
- Server logs in the browser, no SSH required
Dashboards and Charts
- Custom dashboards with drag-and-drop layout
- 12+ chart types including heatmap, sankey, treemap, candlestick
- AI-assisted chart building from natural language
Alerting (Email)
- SQL-based alert rules with per-node evaluation
- Email alerts included out of the box
- Configurable schedules and thresholds
Access Control and RBAC
- 4 app-level roles: superadmin, admin, editor, readonly
- Visual ClickHouse® database RBAC with grant trees
- AES-256-GCM credential encryption at rest
- Argon2id password hashing with automatic session expiry
- Brute-force protection and rate limiting
Backup, Restore, and Indexes
- Guided BACKUP and RESTORE interface
- S3, Google Cloud Storage, Azure Blob support
- Index and projection management
- App data backup for disaster recovery
CHOps Pro
Everything in Community, plus enterprise features for teams that need SSO, multi-channel alerting, automated backups, and compliance.
CHOps Pro Exclusive
Remote Cluster Management
When a ClickHouse® database node goes down, most tools go dark with it. CHOps Pro keeps you in control. View server logs directly from the filesystem, update ClickHouse® configuration files, and start, stop, or restart services remotely. All without SSH access and without installing CHOps on the node itself.
Built For
Built for every team that runs ClickHouse® database
Data Engineers
Monitor cluster health, profile slow queries with flame graphs, and manage table structures. No SSH, no CLI.
Data Analysts
Write queries with AI, build dashboards with 12+ chart types, and export results. No external BI tools required.
DevOps & SRE
Go from zero to production alerts in minutes. DVR playback and flame graphs for incident investigation.
DBAs
Visual grant trees, backup automation, index management, and audit logging. The toolkit that should have existed from day one.
Engineering Managers
Scheduled reports and dashboards delivered to your inbox. No SQL required.
CTOs & Technical Leaders
One tool instead of a patchwork. On-premise deployment with full data sovereignty. AGPL or commercial license.
Industries
Used across industries that rely on ClickHouse® database
Ad-tech & Marketing
Monitor real-time bidding pipelines and campaign analytics
Financial Services
Audit-ready access control, encrypted credentials, compliance reporting
E-commerce & Retail
Real-time inventory, order tracking, and clickstream analytics
IoT & Telemetry
Monitor high-volume sensor data ingestion and query performance
Log Analytics & Observability
Manage ClickHouse® database-backed log storage with alerting
SaaS & Cloud Platforms
Multi-tenant analytics with role-based access and automated reporting
Pricing
Community for individuals. Pro for teams that run ClickHouse® database in production.
Community Edition
$0 forever
AGPL open-source license. Individual operators, small teams, evaluation.
Get Community Edition- SQL editor with AI, history, bookmarks, export
- Cluster monitoring with pre-built dashboards
- Query profiler with flame graphs
- DVR-style monitoring playback
- Custom dashboards with 12+ chart types
- Email alerting with per-node evaluation
- ClickHouse® database RBAC with visual grant trees
- Backup and restore (S3, GCS, Azure)
- Index and projection management
- App data backup and restore
- Server log viewer
- Multi-cluster support (up to 3)
- App-level user management (4 roles)
- Docker, binary, and source deployment
- Community support via GitHub
- AGPL open-source license
Pro Edition
Contact us
Commercial license. Production teams, enterprise, regulated industries.
Book a DemoEverything in Community, plus:
- Remote Cluster Management (view logs, update configs, restart services)
- SSO support
- Unlimited clusters and nodes
- Scheduled email reports (SQL on cron)
- Slack, Teams, Google Chat, PagerDuty alerts
- Scheduled backups with retention policies
- Audit log (50+ actions, PDF export)
- Priority support with SLAs
- Commercial license
Enterprise Add-ons
Need help with your ClickHouse® database infrastructure?
The team behind CHOps also provides ClickHouse® database consultancy, performance tuning, migration services, and managed database operations through Quantrail.
Learn About Quantrail ServicesFAQ
Frequently asked questions
No. The Community edition includes 25+ fully functional features: SQL editor with AI, cluster monitoring, query profiler with flame graphs, DVR playback, custom dashboards with 12+ chart types, email alerting, visual RBAC management, backup and restore, index management, app data backup, and multi-cluster support. Pro adds team-oriented features like SSO, multi-channel alerting, scheduled backups, and audit logging.
CHOps is dual-licensed. The Community edition uses the GNU Affero General Public License (AGPL), approved by both the Open Source Initiative (OSI) and the Free Software Foundation (FSF). You can use it freely for commercial purposes. Organizations that prefer a commercial license without AGPL obligations can use CHOps Pro, which includes a commercial license. Either way, your legal team has a clear path forward.
CHOps encrypts all stored database credentials with AES-256-GCM. User passwords are hashed with Argon2id. Sessions expire automatically after 2 hours of inactivity. Brute-force protection locks accounts after repeated failed login attempts. 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 Cluster Management is a CHOps Pro feature that lets you manage ClickHouse® database nodes even when the database process is unresponsive. A lightweight proprietary binary runs on each ClickHouse® node and communicates with CHOps over encrypted channels. Through this binary, you can view server logs from the logs directory, update ClickHouse® server configuration files, and start, stop, or restart ClickHouse® services. CHOps itself does not need to be installed on the ClickHouse® node.
Pro adds Remote Cluster Management (view logs, update server configs, start/stop/restart ClickHouse® services remotely even when nodes are down), SSO support, unlimited clusters, scheduled email reports, multi-channel alerting (Slack, Teams, Google Chat, PagerDuty), scheduled automated backups with retention policies, audit logging with PDF export, priority support with SLAs, and a commercial license.
Yes. CHOps connects via the HTTP interface, which all ClickHouse® Cloud plans support. All features work with ClickHouse® Cloud except Remote Cluster Management, which requires the CHOps remote agent on your nodes. It also works with Altinity.Cloud, Aiven for ClickHouse®, Kubernetes deployments, and any self-hosted setup.
For the Community edition, no. CHOps connects over the ClickHouse® HTTP interface with nothing installed on your servers. For Remote Cluster Management (Pro), a lightweight proprietary binary runs on your ClickHouse® nodes. This binary communicates with the CHOps application 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. Available for Linux x64 and macOS ARM. Docker images and Docker Compose files are also provided.
The Community edition supports up to 3 ClickHouse® database clusters. CHOps Pro supports unlimited clusters and nodes.
CHOps does not modify your ClickHouse® data unless you explicitly run a query that does so. Database credentials are encrypted with AES-256-GCM. User passwords are hashed with Argon2id. Sessions expire after 2 hours. Brute-force protection locks accounts after failed login attempts.
CHOps currently supports ClickHouse® 26.3 LTS. Other versions should work as well, but some features may not be available on older releases. CHOps connects via 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.
Ready to simplify your ClickHouse® database operations?
Community for individuals. Pro for teams that run ClickHouse® database in production.