Vizier
A physical design advisor for DuckDB
Details
- External ID
- 47532746
- Source
- HN
- Company
- —
- Product
- —
- Website domain
- —
- Launched
- March 26, 2026
- Cohort
- —
- Upvotes
- 6
- Upvotes percentile
- 0.2853628536285363
- Tags
- —
- Fetched at
- Sept. 7, 2026, 9:26 p.m.
- Updated at
- Sept. 7, 2026, 9:26 p.m.
Description
Hi,I've made an early version of a physical design advisor (called Vizier) for DuckDB. It can analyze a collection of queries (using a set of heuristics) and recommend changes to the physical design/layout of the database (for example, sort orders, Parquet layouts, indexes, etc.), in order to make those queries run faster.Vizier is implemented as a DuckDB extension in Zig and supports DuckDB version 1.2.0 and newer. The project is very early-stage, but if you're interested in learning more about Vizier or trying it out, you can check out the links below:Project's GitHub repo: https://github.com/CogitatorTech/vizierVizier documentation: https://cogitatortech.github.io/vizier/
Enrichment
- Theme
- database infrastructure and developer tools
- Vertical
- Horizontal
- Function
- Dev tools
- Audience
- Developer
- AI stance
- Not AI
- Project type
- Hobby / open-source project
- Normalized one-liner
- physical design advisor for duckdb
- Manually corrected
- False
Could you build this?
Partial Parsing SQL queries with DuckDB's AST parser to inspect filters and joins is approachable, but designing an accurate cost-model-driven physical layout advisor (optimal sorting, partitioning, and indexing) requires non-trivial database internals knowledge.
What it would actually take: The system must integrate with DuckDB's query parser and planner (via Python or C++ bindings) to extract predicate pushdowns, sort orders, and join keys across a query workload. The difficult part is building a multi-objective cost estimator that balances write amplification/storage footprint against query speedup when proposing Parquet row-group sorting, Z-order curves, or min/max statistics. It requires a database engineer familiar with vectorized query execution and columnar storage layouts.
Discussion
No comments on this launch.
Competitors
Other products that read as similar to this one — 15 launches clear the similarity bar, closest 8 shown.
Attention rank: #13 of 16 (itself plus its competitors, highest first — normalized so YC and Product Hunt are compared fairly).
Launched 137 days after the earliest competitor.
- VisuaLeaf · hn · 2026-04-29 · 9 upvotes · similarity 0.38
- Connect DuckDB to any database that has an ADBC driver · hn · 2026-07-08 · 7 upvotes · similarity 0.37
- Insight O' Mate · ph · 2026-09-16 · 3 upvotes · similarity 0.36
- duckdb-jev · github · 2026-09-17 · 17 upvotes · similarity 0.36
- Data Studio · hn · 2026-02-17 · 28 upvotes · similarity 0.35
- duckdb-plan-lint · github · 2026-09-25 · 15 upvotes · similarity 0.34
- duckdb-extension-audit · github · 2026-09-25 · 20 upvotes · similarity 0.34
- ViziAPI · ph · 2026-09-30 · 2 upvotes · similarity 0.34
Other launches for this product
- No other launches for this product.
Same idea, different domain
Nobody's really built a dev tools tool for Sales yet.