Show HN: The TypeScript Semantic Layer for ClickHouse

lureilly11 pts0 comments

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.

clickhouse runs layer typescript semantic type

Related Articles