DuckDB UI
duckdb.org
- Free plan
- Windows
- macOS
- Linux
- Web
- Browser extension
- Self-hosted
What DuckDB UI is
DuckDB UI is a browser-based interface added to a local DuckDB instance by the ui extension. It provides 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()`; it opens in the default browser and is served by an HTTP server embedded in DuckDB, normally at `http://localhost:4213`. Queries run fully locally by default, and queries and data stay on the computer. The native DuckDB process lets the interface use local cores, memory, and files. Connecting to MotherDuck requires explicit opt-in and signing in. The extension is free. Direct use with a read-only database is not supported, and the UI currently does not 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 suits
DuckDB UI suits people who want to explore and query a local DuckDB database through a browser interface. It is not suitable for direct use with a read-only database or on windows_arm64.
Good to know, and what to watch
- Includes a SQL notebook with autocomplete and shortcuts.
- Provides catalog, table, and results exploration.
- Queries and data stay local by default.
- Free to use.
- Direct use with read-only databases is unsupported.
- Does not currently support windows_arm64.
- Configured alternate UI URLs should be trusted.
Plans
Every plan and priceFree local DuckDB UI
Free plan
Getting started
- Install or access DuckDB with the ui extension
- Run `duckdb -ui` or execute `CALL start_ui()`
- Open the interface in the default browser
- Use the local server at http://localhost:4213
- Optionally opt in and sign in to connect MotherDuck
Limits to check
The UI cannot be run directly against a read-only database, and windows_arm64 is unsupported. MotherDuck connectivity is optional but requires explicit opt-in and sign-in.
The verdict
DuckDB UI provides local SQL and data exploration tools in a browser, with an optional MotherDuck connection. Check its read-only database and windows_arm64 limitations, and use trusted alternate UI URLs.
Questions people ask
What does DuckDB UI cost?
The Free local DuckDB UI plan costs nothing.
Where do queries run?
By default, queries execute fully locally through DuckDB, and queries and data remain on the computer.
How do I launch the interface?
Run `duckdb -ui` or call `CALL start_ui()`. The interface opens in the default browser.
Can it connect to MotherDuck?
Yes, but MotherDuck use requires explicit opt-in and signing in to MotherDuck.
Which platforms are supported?
The UI is listed for extension, Linux, macOS, self-hosted, web, and Windows contexts. Windows ARM64 is not supported.
Can I export query results?
Yes. CSV is listed as a result export format.
What the maker publishes
- Browser launch
- Starting the UI opens it in the default browser. source
- Cloud security
- MotherDuck has completed SOC 2 Type II attestation and has been GDPR verified. source
- Data exploration
- The UI includes a catalog browser, table explorer with column-level statistics, and a results viewer with sorting and filtering. source
- Embedded server
- The UI is served by an HTTP server embedded in DuckDB, available by default at http://localhost:4213. source
- Launch options
- You can start the UI with duckdb -ui or CALL start_ui(). source
- Local execution
- By default, queries run fully locally and queries and data never leave the computer. source
- Local resources
- The native DuckDB process lets the UI use all local cores, memory and files. source
- Maintainer
- The UI is built and maintained by MotherDuck. source
- MotherDuck integration
- Using MotherDuck through the UI requires explicit opt-in and signing in to MotherDuck. source
- Notebook features
- The interface includes a SQL notebook with autocomplete and keyboard shortcuts. source
- Platform limitation
- The UI currently does not support windows_arm64. source
- Purpose
- The ui extension adds a user interface for a local DuckDB instance. source
- Read-only limitation
- Running the UI directly on a read-only database is not supported. source
- 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. source
Checked against the maker's pages on 1 Oct 2026.