hypequery for Python is here: datasets for ClickHouse, served from FastAPI, Django, or Flask. Read the launch post →
npmdownloads / month
Open sourceApache 2.0

The analytics layer for ClickHouse

Define your metrics once, in the codebase you already have. Dashboards, APIs, and AI agents all answer from that one definition. Run it in your own backend, or on hypequery cloud.

Get started

Give your agents numbers you can trust.

Read why Uber, Cloudflare, and Instacart each built their own analytics layer on ClickHouse. hypequery gives you that layer as code you own.

One model behind every answer

Your dashboards, APIs and agents like Claude all query the same model, with the same tenant rules.

ClickHouse Cloud, chDB, or self-hosted
Published v1 · orders, customers, refunds, events

APIs

Every dataset is an authenticated endpoint with OpenAPI, for any frontend, mobile app or service.

POST /api/analytics/datasets/orders/query
{
  "dimensions": ["country"],
  "measures": ["revenue"],
  "filters": [{ "field": "month",
    "operator": "eq", "value": "2026-09" }]
}
200 OKapplication/json
{ "data": [
  { "country": "GB", "revenue": "64000.00" },
  { "country": "US", "revenue": "48000.00" },
  { "country": "DE", "revenue": "16000.00" }
] }
Read more

Embedded analytics

Ship embedded analytics with typed React hooks and your own components.

Revenue
$128,000USD
1 Sep30 Sep
By country
GB
$64,000
US
$48,000
DE
$16,000
Read more

AI agents

Connect Claude, ChatGPT, or your favourite model over MCP. They only see what you publish.

claude
Claude Code
hypequery MCP connected
~/northwind-app
>
? for shortcuts
Read more

Embedded chat

Coming soon

Let your customers ask questions about their own data, inside your app. Chat answers from the same model as your dashboards, APIs and agents: the same question gets the same number everywhere.

Northwind Analytics
Ask about your data…

Runs where your app runs

hypequery is a library, not another service to deploy. Mount it in the framework you already use, in TypeScript or Python. Same datasets, same endpoints, same tenant rules.

Built for production from day one

Tenant isolation, joins, access control, and caching are part of the model, so every tool gets them for free.

01

Keep customers isolated

Every query is scoped to the signed-in customer. No tenant context? The query is rejected.

Explore tenant isolation
02

Encode your business logic

Ratios, period comparisons, and named segments. Bucket by day, week, or month, in any timezone.

Explore calculations
03

Connect your business data

Declare relationships once. hypequery writes the joins.

Explore relationships
04

Control what's queryable

Publish only the fields you choose. Agent tools reject anything else.

Explore query controls
05

Review changes like code

Every change is a diff you can read, whether AI or a person made it.

Explore model definitions
06

Fast, without leaking

Repeated questions are cached, with separate cache entries for every tenant.

Explore caching

Go live in minutes with hypequery cloud

Cloud turns your model into a hosted API and MCP server the moment you publish. Update the model in one click, and roll it back just as fast.

Ask in plain English. Every answer comes from your published measures, scoped to the tenant, with the query one click away.

analytics/Publishedv42/Chatanswers from Published v42Connect
Which countries drove revenue growth in September?
Queried orders.revenue by countrySep vs Aug 2026
Scoped to tenantorg_id = acme

Revenue grew $59,853 (+4.5%) to $1,401,930. The United States drove over half of it, and Japan was the only country to dip.

Revenue change by countrySep vs Aug
United States+$31,240
Germany+$14,105
United Kingdom+$9,870
France+$6,412
Japan−$1,774
Answered from Published v42orders.revenueorders.countryView query

Ship your analytics layer today

Start open source in your own backend. A hosted option, hypequery cloud, is coming soon.

Get started

Get early access to hypequery cloud.

Cloud hosts the same model you run in your backend, with a managed API and MCP server, versions, and rollback. We're letting teams in a few at a time. Join the waitlist and we'll reach out when your project can go live.

How do you want to build your analytics layer? (Optional)
What features do you most need? (Optional)

Pick as many as you like.

Only your email is required. All other questions are optional.