PostHog has developed open-source tool HouseWatch, to monitor and manage ClickHouse clusters. The tool provides end-users with an overview of cluster load and performance, drill-down capabilities into queries, searching through logs and killing running queries with just one click. The tool also provides stats on per-node disk usage, and the ability to run queries directly from the interface. HouseWatch’s vision is to serve the purpose of a pganalyze for the ClickHouse ecosystem, while also including tooling to take action on insights. While it is in beta, the tool could be connected to ClickHouse using a read-only user.
https://github.com/PostHog/HouseWatch