Introduction
Duck-UI overview — a modern web interface for DuckDB
Quick Installation
Docker
docker run --name duck-ui -p 5522:5522 \
ghcr.io/ibero-data/duck-ui:latestAccess at: http://localhost:5522
What is Duck-UI?
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.
Key Features
- No Server Required: DuckDB runs in your browser via WebAssembly
- AI-Powered: Natural language to SQL with local or cloud AI (Duck Brain)
- Import Anything: Load CSV, JSON, Parquet, Arrow files from local storage or URLs
- Folder Access: Mount folders from your computer - persists across browser sessions
- Persistent Storage: Save databases using OPFS for data that persists across sessions
- External Connections: Connect to remote DuckDB servers when needed
- Lightning Fast: Near-native performance thanks to WebAssembly
- Privacy First: All data processing happens client-side
Requirements
- Modern web browser with WebAssembly support:
- Chrome/Edge 88+
- Firefox 79+
- Safari 14+
- Docker (for containerized deployment) or Bun/Node.js 20+ (for building from source)
- No database server needed for local WASM mode
Use Cases
Data Analysis
Analyze CSV, JSON, or Parquet files directly in your browser without uploading to a server:
SELECT product, SUM(sales) as total_sales
FROM read_csv('sales_data.csv')
GROUP BY product
ORDER BY total_sales DESC;Quick Prototyping
Test SQL queries and data transformations without setting up infrastructure:
-- Load data from URL
CREATE TABLE products AS
SELECT * FROM read_parquet('https://example.com/products.parquet');
-- Run analytics
SELECT category, AVG(price) as avg_price
FROM products
GROUP BY category;Learning SQL
Perfect environment for learning SQL with instant feedback and no setup:
- Import sample datasets
- Write queries with autocomplete
- See results immediately
- No database configuration needed
Sponsors
We would like to thank our sponsors for their support:
Ibero Data
iberodata.es — Empowering businesses with data-driven solutions
QXIP
qxip.net — Next-Gen Telecom Observability. R&D Company pioneering Open-Source and Commercial Observability and Telecom Monitoring Technology development.
Support
License
Duck-UI is open source software licensed under Apache 2.0.
