DuckDB UI

B
B tier on Database Client SoftwareScore 7.0 · #8 of 48
Android app
Not listed
Free plan
Yes
Runs on
Browser extension, Linux, Mac, self-hosted, Web, Windows
duckdb.org
The DuckDB UI homepage

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 plans
Free local DuckDB UI Free browser-based interface · local SQL notebook · optional MotherDuck connection web.staging.motherduck.com · 1 Oct 2026

Compared 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 20

Where it ranks on Everything Xiaomi

Is DuckDB UI yours?

Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.

Sources