# CHOps - ClickHouse Database Admin Tool

## Summary
CHOps is a self-hosted, open-source administration tool for ClickHouse databases. It provides 30+ features including a SQL editor with AI, cluster monitoring, query profiler with flame graphs, DVR-style incident playback, custom dashboards, alerting, backup management, RBAC, and remote cluster management.

## Editions
- Community Edition: Free, AGPL licensed, 30+ features, supports up to 3 clusters
- Pro Edition: Commercial license, adds SSO, unlimited clusters, multi-channel alerting, scheduled backups, audit logging, remote cluster management, and priority support

## Key Facts
- Website: https://chops.dev
- License: Dual-licensed (AGPL for Community, commercial for Pro)
- Built by: Quantrail
- Platforms: Linux, macOS
- ClickHouse version: Currently supports 26.3 LTS
- Blog: https://chops.dev/blog
- RSS: https://chops.dev/feed.xml
- Changelog: https://chops.dev/changelog

## Unique Selling Point
Remote Cluster Management (Pro): View logs, update configs, and restart ClickHouse services remotely even when database nodes are down.

## Pages
- Home: https://chops.dev
- Features: https://chops.dev/features
- SQL Editor: https://chops.dev/features/sql-editor
- Monitoring: https://chops.dev/features/monitoring
- Dashboards: https://chops.dev/features/dashboards
- Query Profiler: https://chops.dev/features/query-profiler
- Alerting: https://chops.dev/features/alerting
- Backups: https://chops.dev/features/backups
- Access Control: https://chops.dev/features/access-control
- Remote Admin: https://chops.dev/features/remote-admin
- Pricing: https://chops.dev/pricing
- About: https://chops.dev/about
- Changelog: https://chops.dev/changelog
- Blog: https://chops.dev/blog
- Docs: https://chops.dev/docs
- ClickHouse Admin Tool: https://chops.dev/clickhouse-admin-tool
- ClickHouse GUI: https://chops.dev/clickhouse-gui
- ClickHouse Monitoring: https://chops.dev/clickhouse-monitoring
- ClickHouse Dashboard: https://chops.dev/clickhouse-dashboard
- ClickHouse SQL Editor: https://chops.dev/clickhouse-sql-editor
- ClickHouse Backup Tool: https://chops.dev/clickhouse-backup-tool
- ClickHouse Alerting: https://chops.dev/clickhouse-alerting
- ClickHouse Access Control: https://chops.dev/clickhouse-access-control
- ClickHouse Remote Management: https://chops.dev/clickhouse-remote-management
- ClickHouse Consultancy: https://chops.dev/clickhouse-consultancy
- ClickHouse Admin Tools Comparison: https://chops.dev/clickhouse-admin-tools

## Blog Posts
- Introducing CHOps: https://chops.dev/blog/introducing-chops
- Monitoring Best Practices: https://chops.dev/blog/clickhouse-monitoring-best-practices
- Remote Cluster Management: https://chops.dev/blog/remote-cluster-management
- Backup Strategies: https://chops.dev/blog/clickhouse-backup-strategies
- SQL Editor Tips: https://chops.dev/blog/sql-editor-tips
- RBAC Security Guide: https://chops.dev/blog/rbac-security-guide
- DVR Incident Response: https://chops.dev/blog/dvr-incident-response
- Building Dashboards: https://chops.dev/blog/building-dashboards-clickhouse