wtf is ch-ops?

CHOps is a web based dashboard for managing and watching over ClickHouse database clusters. ClickHouse is a type of database built for fast analytics on large amounts of data, and people normally interact with it through a command line tool or a raw HTTP API. CHOps puts a visual interface in front of that, so instead of typing commands you can click through pages to run SQL, watch slow queries, set up alerts, manage backups, and control who has access. The dashboard is organized into ten sections reachable from a sidebar, along with a global search that jumps straight to any page or feature. These sections cover cluster health and live query monitoring, a full SQL editor with autocomplete and query explain plans, custom chart dashboards, index and log viewers, alerting rules with email notifications, user and role management, and backup and restore to S3 compatible storage. There is also a built in AI assistant, called Qurioz, that turns plain English questions into ClickHouse SQL. CHOps itself stores its own settings, such as alerts, dashboards, and user accounts, in a small local SQLite file, and does not touch your actual ClickHouse data unless you run a query yourself. It is built with Bun, a JavaScript runtime, using a React frontend and an Express backend, and can be compiled into a single self contained file that runs with no other dependencies. The easiest way to try it is downloading a ready made binary from the releases page, though it can also be run from source or through Docker with a provided Compose file. Getting it running from source involves installing Bun, pointing it at a reachable ClickHouse server, filling in four required settings such as an admin username, password, and a random session secret, then running a one time database setup command before starting the app. It is released under the AGPL v3 license, a copyleft license that generally requires anyone offering a modified version as a network service to share their source code as well. It has 22 stars so far.