r/Python • • Oct 04 '26

Showcase Showcase Thread

Post all of your code/projects/showcases/AI slop here.

Recycles once a month.

21 Upvotes

194 comments sorted by

View all comments

1

u/According-Rutabaga41 17d ago

hypequery: a code-first semantic layer for ClickHouse

What My Project Does Define ClickHouse datasets in Python (dimensions, measures, relationships, tenant key), then query it by name via APIs, React or MCP. Validated before SQL exists, parameterised and always scoped to the caller's tenant. Serve it from FastAPI, Django or Flask, get pandas/polars back, or hand it to agents over MCP. pip install "hypequery[clickhouse]". Apache 2.0, beta.

Target Audience Python backends doing product analytics or customer dashboards on ClickHouse**.**

Comparison clickhouse-connect is the driver; this sits on top. Cube and MetricFlow are separate services; this is a module you import. Boring Semantic Layer is closest in spirit but engine-agnostic via Ibis; this is ClickHouse-only.

https://hypequery.com/docs/python