Nicheloom visits: 62,449 all-time · 8,415 in the last 7 days

The opportunity tracker for new startups.

Today: 2,085 launches · Niche of the day: browser-based utility tools · See what launched today →

Strata

an expressive semantic layer that can say no to your LLM

Get picks like this daily. Today's launch numbers, the top launches, AI and tech news, and a daily opportunity pick, straight to your inbox.

Want to reach these readers? Sponsor an issue.

Hello HN, I'm Ajo and I built Strata.I spent 4 years at Netflix solving self service for non-technical business users. I think I cracked it with my unique approach to semantic layer design. The key challenge is balancing expressiveness with ease of use for our non technical colleagues. It just so happens that focus made it work pretty well with LLMs too.Strata is a full stack solution. It includes a semantic layer, dashboards, subscriptions, and google sheets exports. All of it can be done view agent conversation or via MCP.Some key concepts and features: - Names are strict. Only one thing called Revenue can exist in a project. If revenue is mapped to multiple tables, the query grain plus speed will decide table. - Strict naming conventions lends itself to enabling Automatic data blending acrros fact domains. - Partition and Aggregate aware semantic routing. This allows you to load a portion of your data into a faster compute engine like Druid or ClickHose, while keeping full history in trino or something cheaper. The query engine will choose the faster tier if the query can be resolved there. - Complex measures: out of the box support for snapshot, LOD (include/exclude), Compound, and Auto leveling compound measures. - On top of the semantic layer users can create custom calculations that span fact domains. - Another interesting feature is the ability to create cohorts and apply as filter to an entire query or single measure within a query.We are deliberately not building a semantic layer that your BI tools connect to. I think that is a dead end. We have apis, and mcp for anything custom you want to build on top.Try it free on docker: https://strata.do/try/Docs here to get you going: https://strata.do/docs/This is an early beta version. It is NOT open source. However, the free tier includes up to 25 users. You should be able to run it entirely on your machine with docker.I would love to hear your feedback. Especially, those working with Looker and Cube.Thanks for reading!

HN · launched Sep 30, 2026 · 24 upvotes (top 24%) · 3 views

Niche: database and data quality tools · 106 launches, 5 in the last 7 days ▼ -17% · Explore this niche →

Category and tags

  • Horizontal
  • Data infrastructure
  • Developer
  • AI-native
  • Commercial product

Visit website ↗ Source listing ↗

Could you build this?

No Building a governed semantic data layer requires complex database internals, formal relational algebra, query transpilation, and strict constraint verification that cannot be vibe coded.

What it would actually take: A production semantic layer requires building a domain-specific modeling language (or AST parser) that compiles abstract business logic into dialect-specific SQL (e.g., Snowflake, BigQuery, DuckDB) while guaranteeing join safety and metric consistency. It demands deep compiler construction, database query planning expertise, and formal methods to validate LLM queries against schema governance rules before execution.

Discussion

14 comments analyzed.

Competitors mentioned: Looker, MicroStrategy, Snowflake Analyst

Concerns raised: Semantic layers may not actually improve agent performance, Snowflake semantic dialect lacks expressiveness, Broken 404 links on documentation pages

Feature requests: Open source release, Semantic layer as a service API

Competitors

Other products that read as similar to this one : 126 launches clear the similarity bar, closest 8 shown.

Attention rank: #31 of 127 (itself plus its competitors, highest first, normalized so YC and Product Hunt are compared fairly).

Launched 331 days after the earliest competitor.

The niche, labels, vibe code rating and competitor comparison on this page are analysis by Nicheloom. If you use them, please credit nicheloom.com. How you may use our data.