Show HN: The TypeScript Semantic Layer for ClickHouse

A developer released hypequery, a type-safe semantic layer for ClickHouse that compiles to SQL and runs as a library without additional infrastructure. The tool allows defining metrics once and reusing them across dashboards and APIs, with built-in multi-tenancy and LLM integration via an MCP server.

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 are blocked at the query layer, helpers to plug into your existing auth. - Agent-native: A dataset is a declared set of dimensions and measures, so it doubles as an allowlist. Includes an MCP server to hand an LLM a typed catalog to query. - Runtime HTTP entry point: serve exposes any dataset as an endpoint, so the same type-safe definitions back your dashboards and your API. Comments URL: https://news.ycombinator.com/item?id=48696675 https://news.ycombinator.com/item?id=48696675 Points: 2 Comments: 0