Trilogy Studio, open-source browser-based SQL editor and visualizer
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.
SQL-first analytic IDE; similar to Redash/Metabase. Aims to solve reuse/composability at the code layer with modified syntax, Trilogy, that includes a semantic layer directly in the SQL-like language.Status: experiment; feedback and contributions welcome!Built to solve 3 problems I have with SQL as my primary iterative analysis language:1. Adjusting queries/analysis takes a lot of boilerplate. Solve with queries that operate on the semantic layer, not tables. Also eliminates the need for CTEs.2. Sources of truth change all the time. I hate updating reports to reference new tables. Also solved by the semantic layer, since data bindings can be updated without changing dashboards or queries.3. Getting from SQL to visuals is too much work in many tools; make it as streamlined as possible. Surprise - solve with the semantic layer; add in more expressive typing to get better defaults;also use it to wire up automatic drilldowns/cross filtering.Supports: bigquery, duckdb, snowflake.Links [1] https://trilogydata.dev/ (language info)Git links: [Frontend] https://github.com/trilogy-data/trilogy-studio-core [Language] https://github.com/trilogy-data/pytrilogyPreviously: https://news.ycombinator.com/item?id=44106070 (significant UX/feature reworks since) https://news.ycombinator.com/item?id=42231325
HN · launched Nov 9, 2025 · 19 upvotes (top 32%) · 0 views
Niche: database clients and gui tools · 112 launches, 9 in the last 7 days ▲ +13% · Explore this niche →
Category and tags
- Horizontal
- Analytics & BI
- Developer
- Not AI
- Hobby / open-source project
Visit website ↗ Source listing ↗
More like this: all 112 launches in database clients and gui tools →
Could you build this?
Partial Building a browser-based SQL editor UI is straightforward, but developing a custom domain-specific language compiler/transpiler (Trilogy) with a semantic layer requires compiler engineering expertise.
What it would actually take: The frontend can use Monaco Editor, DuckDB-Wasm, and standard charting libraries, but the hard part is the custom DSL compiler. It requires building an AST parser, type checker, semantic graph resolver, and SQL transpiler that can translate semantic Trilogy queries into performant target SQL for various database dialects. This demands specialized knowledge of programming language design, compiler construction, and relational algebra.
Discussion
6 comments analyzed.
Concerns raised: Dashboard load fails with reset operation timeout after 60 seconds, CORS validation failures preventing initial dashboard connection, Static hosting too slow to serve packages in time
Feature requests: Post-deploy validation for serve latency
Competitors
Other products that read as similar to this one : 200 launches clear the similarity bar, closest 8 shown.
Attention rank: #77 of 201 (itself plus its competitors, highest first, normalized so YC and Product Hunt are compared fairly).
Launched 11 days after the earliest competitor.
- Metabase Data Studio · ph · 2026-03-31 · 153 upvotes · similarity 0.45
- Building a SQL analyst agent from scratch · hn · 2026-04-27 · 6 upvotes · similarity 0.45
- Data Studio · hn · 2026-02-17 · 28 upvotes · similarity 0.45
- SLayer, a semantic layer maintained by your agent · hn · 2026-05-11 · 12 upvotes · similarity 0.44
- 0Sql · hn · 2026-10-06 · 7 upvotes · similarity 0.44
- QueryAST Lens · ph · 2026-10-01 · 1 upvotes · similarity 0.44
- Visual Database Schema Designer (Angular 21 and .NET 10) · hn · 2026-01-19 · 6 upvotes · similarity 0.43
- Xsql · hn · 2025-12-16 · 11 upvotes · similarity 0.43
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.