Hi HN,

I built @duck_ui/embed — a set of React components that turn SQL queries into interactive dashboards, powered by DuckDB-WASM running entirely in the browser.

     `npm install @duck_ui/embed @duckdb/duckdb-wasm`

 The idea: pass your data (arrays, CSV, Parquet, JSON, or a fetch callback), write SQL, and get charts, tables, KPIs, and filters — no backend required.

     <DuckUIProvider data={{ sales: { url: "/sales.parquet", format: "parquet" } }}>
       <Dashboard columns={3}>
         <Dashboard.Panel>
           <KPICard sql="SELECT sum(revenue) as value FROM sales" label="Revenue" format="currency" />
         </Dashboard.Panel>
         <Dashboard.Panel span={2}>
           <Chart sql="SELECT month, sum(revenue) FROM sales GROUP BY 1" type="bar" />
         </Dashboard.Panel>
         <Dashboard.Panel span={3}>
           <DataTable sql="SELECT * FROM sales" pageSize={20} sortable />
         </Dashboard.Panel>
       </Dashboard>
     </DuckUIProvider>

What's under the hood:

- DuckDB-WASM boots in the browser, data loads into in-memory tables - SQL queries run against real DuckDB (full SQL support, window functions, CTEs) - Parquet files use HTTP range requests — only fetches needed row groups - FilterBar auto-detects column types and injects WHERE clauses via subquery wrapping - Connection pool (max 4), LRU query cache (100 entries, 5min TTL) - ~95KB bundled (ESM), tree-shakeable

Components: Chart (line/bar/area/scatter/pie), DataTable (paginated, sortable, resizable columns), KPICard (with sparkline + comparison), FilterBar (auto or manual config), Dashboard (responsive grid layout), ExportButton (CSV/JSON).

For connecting to external databases (Postgres, MySQL, etc.), there's a "gateway pattern" — your backend runs the SQL and returns JSON, the embed renders it via a fetch callback.

Built with: React 18+, DuckDB-WASM, uPlot, @tanstack/react-table, Zustand. Apache-2.0 licensed.

Live playground: https://duckui.com/play Docs: https://duckui.com/embed/docs npm: https://www.npmjs.com/package/@duck_ui/embed

This is part of the Duck-UI project (https://github.com/ibero-data/duck-ui), a browser-based SQL IDE for DuckDB with 525+ stars. The embed SDK lets you take the same DuckDB-powered analytics and drop them into any React app.

Would love feedback on the API design and what components/features you'd want next.

Wiretapping scandal: Spyware manufacturer sentenced to prison in Greece

When, where, and how often do individuals recover memories of trauma (2025)

Modernizing terminal command entry for Emacs-style flex search and mouse support

OpenClaw Partners with VirusTotal for Skill Security

Show HN: Unfucked (unf) – a filesystem flight recorder that snapshots every save

Startups Are Sequencing Problems

Show HN: Stop reviewing AI-generated code during a PR, move it in the edit cycle

Block shares soar 24% as company slashes workforce by nearly half

Real-Time Rendering with a Neural Irradiance Volume

Kansas invalidates drivers licenses of trans people

Show HN: JSON Maps – Describe Maps as JSON, Render Them with React and MapLibre

Project Calico 3.30 Hackathon

AGI is an unscientific myth

AI Agent for Financial Analysis

Recent Automattic AI Progress

A tour of Pompeii as it was just before its destruction [video]

I helped Claude prove the Beale Ciphers are a 140 year old hoax

Show HN: Email but for Your OpenClaws

Canadians: Please Help [video]

Show HN: Safari-CLI – Control Safari without an MCP

Layoffs at Block

Show HN: Duck-UI Embed – SQL-Powered React Dashboard Components with DuckDB-WASM

Nepal is 'addicted' to the trade in its own people

Deterministic SRPM conversion – Fedora 40 packages into IRIX-compatible software

Samsara picks Bluetooth LE for network connectivity expansion

Now is the right time to switch to Neovim

A cursed file on macOS (2022)

Morgan Stanley predicts AI won't let you retire early

Show HN: Yaw: terminal, SSH/database connections, AI Chat and optimized AI CLI

From Skill.md to Shell: A Security Audit Guide for AI Agent Skills

Ask HN: Are you running production workloads in Pytorch eager mode?