Data is better when we see it!
SQL editor, markdown dashboards, live collaboration, and an AI assistant, all in your browser with no server required. Your data never leaves your machine.
Free and open source, Apache-2.0. No account, no server, no card.
Dashboards and live collaboration, still with no server
Write reports as markdown with live SQL inside, filter them with Grafana-style input variables, and share your workspace with someone else's browser directly. Queries they run execute on your machine and stream back to them, peer to peer.
Markdown dashboards
Named SQL blocks, charts, tables and big values, written as a document. Evidence-style.
Input variables
Dropdowns, date ranges and sliders that re-run only the queries that use them.
Live sessions
Share your workspace browser-to-browser: visible cursors, co-edited SQL, shared data, revocable any time.
Share and fork
Send a dashboard as a link that carries source, never data. Guests can fork shared tables into their own engine.
Duck Brain AI
Ask questions in plain language, get SQL. Local WebLLM or your own API keys.
Run it yourself
The open source app, self-hosted in one command.
docker run --name duck-ui -p 5522:5522 \
ghcr.io/caioricciuti/duck-ui:latestAccess at: http://localhost:5522
npm install @duck_ui/embedDocs: Embed SDK Guide
Built for simplicity
Duck-UI is a modern web interface for DuckDB, the fast in-process analytical database. It leverages DuckDB's WebAssembly capabilities to run entirely in your browser, providing a powerful SQL editor and data analysis platform without requiring any server infrastructure.
SQL Editor
Advanced Monaco editor with IntelliSense, syntax highlighting, and query history
Duck Brain AI
Natural language to SQL using local AI (WebLLM/WebGPU) or cloud providers (OpenAI, Claude). Your data stays private
Data Import
Import CSV, JSON, Parquet, and Arrow files directly from your computer or URLs
Data Explorer
Browse databases, tables, and columns with an intuitive interface
OPFS Storage
Persistent databases using Origin Private File System for data that persists across sessions
External Connections
Connect to remote DuckDB servers via HTTP API for shared database access
Fast & Private
All data processing happens in your browser - your data never leaves your machine
Persistent Folder Access
Mount folders from your computer and access files directly. Persists across sessions with one-click import to DuckDB.
User Profiles
Create different profiles for your needs, all is local, no data leaves your machine.
What Duck-UI looks like
A modern web interface for DuckDB, built for data analysts and developers.
SQL Editor
Advanced Monaco editor with IntelliSense, syntax highlighting, multiple tabs, and query history.
Data Explorer
Browse databases, tables, and columns. Import CSV, JSON, Parquet, and Arrow files directly.
Charts & Visualization
Multi-series charts with bar, line, area, pie, donut, and scatter plot types. Export as PNG.
Get started
Installation, features, embed SDK, and troubleshooting guides are all in the docs. Or skip setup entirely and open the app at duckui.com.