HouseWatch, open source pganalyze for ClickHouse
Hey all! Yakko from PostHog here. We manage a few large ClickHouse clusters and found ourselves using a lot of different tools internally to monitor and manage them. We also realized that there was no proper UI available for easily digging into query performance and deriving actionable insights, so we built HouseWatch. HouseWatch is meant to cover some of the functionality that pganalyze does for Postgres, but also covers some cluster management aspects that we felt were very tied together, given optimizing ClickHouse performance often requires system tuning and data migrations. It was…
In plain words
HouseWatch is an open-source monitoring and management tool for ClickHouse clusters. It provides a user interface for analyzing query performance and deriving actionable insights, similar to pganalyze for Postgres, while also handling cluster management tasks like system tuning and data migrations. Built by PostHog and available as beta software, it deploys easily via Docker Compose and is designed for teams running ClickHouse in production environments.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
Hey all! Yakko from PostHog here. We manage a few large ClickHouse clusters and found ourselves using a lot of different tools internally to monitor and manage them. We also realized that there was no proper UI available for easily digging into query performance and deriving actionable insights, so we built HouseWatch. HouseWatch is meant to cover some of the functionality that pganalyze does for Postgres, but also covers some cluster management aspects that we felt were very tied together, given optimizing ClickHouse performance often requires system tuning and data migrations. It was initially built at a hackathon but we've spent a couple of weeks on it since and decided to launch it as Beta. Deploying is super simple with docker-compose. We hope this is useful to others running ClickHouse in production!
Does the same job
all alternatives →
- PA
WaveHouse – Supabase for ClickHouse17d ago · wavehouse.dev · ▲20While building an IoT telemetry solution, we ran into hurdles with Clickhouse. For one, you can't insert quickly AND durably into Clickhouse without setting up something like Kafka, which gets complicated for quick projects wanting to make use of Clickhouse's powerful features. Then, trying to actually query Clickhouse and show data in a UI required a whole backend API to handle auth and permissions. We figured that all these parts together – fast, durable ingest, row-level and column-level security and roles, and realtime streaming – were a lot of scaffolding to have to rebuild for every…
- TTThe TypeScript Semantic Layer for ClickHouseJun 2026 · github.com · ▲8
I've built a type-safe semantic layer in code, for ClickHouse. If you're building analytics off ClickHouse in TypeScript, I would love your feedback. With hypequery there is no platform to adopt, no YAML sprawl. It runs where your app runs. Key features: - Define metrics once, reuse them everywhere: Declare dimensions and measures in one place and then pull from the same source of truth. - Compiles to ClickHouse SQL: No service, no proxy, no extra runtime to deploy. It's a library that generates SQL and runs where your app runs. - Multi-tenancy & Authentication ready: Cross-tenant queries…
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 2d ago · opentrailpaper.com
Launched alongside, June 2023
the whole month →- NI
Heya HN, I've been working on a reddit-like platform as my primary side project for the last few years. Doing a (very) soft launch today, mainly because I want to use it to encourage discussion of alternatives. How non.io works: 1. Free to browse, paid to interact. 2. Minimum subscription is $2 (though you can choose more). I take $1 to run the servers, everything left gets split evenly between everything you upvote that month. It's a simple model, but I hope it's a better one than the freemium model we've been relying on for the last few years. Fundamentally I feel like any ad-supported…
Commerce · 2023 · non.io
Typefully 2.0▲931Effortlessly publish on Twitter and LinkedIn, now with AI
Growth · 2023 · typefully.com
SlashPage▲760Create websites in seconds to build your first 1K community
Growth · 2023 · slashpage.com
