DuckDB UI
- Android app
- Not listed
- Free plan
- Yes
- Runs on
- Browser extension, Linux, Mac, self-hosted, Web, Windows

Summary
DuckDB UI is a browser-based interface for working with a local DuckDB instance, added through the ui extension. It includes a SQL notebook with autocomplete and keyboard shortcuts, a catalog browser, a table explorer with column-level statistics, and a results viewer with sorting and filtering. Start it with `duckdb -ui` or `CALL start_ui()`; the interface opens in the default browser and is served by an HTTP server embedded in DuckDB, normally at `http://localhost:4213`. By default, queries run locally and the data and queries stay on the computer. The native DuckDB process gives the interface access to local cores, memory, and files. Connecting to MotherDuck requires opting in and signing in. The UI is free. Direct use with a read-only database is not supported, and the UI does not currently support windows_arm64. The local server fetches interface files from ui.duckdb.org, so configured alternate URLs should be trusted because the application can access loaded DuckDB data.
Who it is for
DuckDB UI suits people who want a browser-based way to explore local DuckDB data and run SQL queries. It may also suit users who want to opt in to a MotherDuck connection.
What is good
- Queries run locally by default
- SQL notebook has autocomplete and keyboard shortcuts
- Table explorer shows column-level statistics
- Results viewer supports sorting and filtering
What to know first
- Direct use with read-only databases is unsupported
- windows_arm64 is not supported
- Configured alternate UI URLs should be trusted
Verdict
DuckDB UI offers local SQL and data exploration in a browser, with MotherDuck connection available by explicit opt-in. Check its read-only database and windows_arm64 limitations before choosing it.
DuckDB UI plans and pricing
All plansCompared on database client software
- Free plan
- Yesduckdb.org
Facts
- Purpose
- The ui extension adds a user interface for a local DuckDB instance.duckdb.org · 1 Oct 2026
- Maintainer
- The UI is built and maintained by MotherDuck.duckdb.org · 1 Oct 2026
- Launch options
- You can start the UI with duckdb -ui or CALL start_ui().duckdb.org · 1 Oct 2026
- Browser launch
- Starting the UI opens it in the default browser.duckdb.org · 1 Oct 2026
- Local resources
- The native DuckDB process lets the UI use all local cores, memory and files.duckdb.org · 1 Oct 2026
- Local execution
- By default, queries run fully locally and queries and data never leave the computer.duckdb.org · 1 Oct 2026
- MotherDuck integration
- Using MotherDuck through the UI requires explicit opt-in and signing in to MotherDuck.duckdb.org · 1 Oct 2026
- Notebook features
- The interface includes a SQL notebook with autocomplete and keyboard shortcuts.web.staging.motherduck.com · 1 Oct 2026
- Data exploration
- The UI includes a catalog browser, table explorer with column-level statistics, and a results viewer with sorting and filtering.web.staging.motherduck.com · 1 Oct 2026
- Embedded server
- The UI is served by an HTTP server embedded in DuckDB, available by default at http://localhost:4213.duckdb.org · 1 Oct 2026
- Remote asset security
- The local server fetches UI files from ui.duckdb.org, and configured alternate URLs should be trusted because the application can access loaded DuckDB data.duckdb.org · 1 Oct 2026
- Read-only limitation
- Running the UI directly on a read-only database is not supported.duckdb.org · 1 Oct 2026
- Platform limitation
- The UI currently does not support windows_arm64.duckdb.org · 1 Oct 2026
- Cloud security
- MotherDuck has completed SOC 2 Type II attestation and has been GDPR verified.motherduck.com · 1 Oct 2026
Best DuckDB UI alternatives
See all 20Where it ranks on Everything Xiaomi
- Best Database Client Software in 2026#8 of 48
- Best Spatial Databases in 2026#6 of 32
- Best Embedded Databases in 2026#10 of 31
- Best OLAP Software in 2026#7 of 31
- Best OLAP Databases in 2026#5 of 28
- Best Columnar Databases in 2026#7 of 25
Is DuckDB UI yours?
Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.
Sources
- duckdb.org/docs/current/core_extensions/ui· checked 1 Oct 2026
- web.staging.motherduck.com/videos/how-to-use-the-new-duckdb-ui-fas· checked 1 Oct 2026
- motherduck.com/trust-and-security/· checked 1 Oct 2026




