Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

DuckDB UI

duckdb.org

  • Free plan
  • Windows
  • macOS
  • Linux
  • Web
  • Browser extension
  • Self-hosted
7.7 Club score Visit duckdb.org

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.

Free local DuckDB UI

Free

Free plan

Getting started

  1. Install or access DuckDB with the ui extension
  2. Run `duckdb -ui` or execute `CALL start_ui()`
  3. Open the interface in the default browser
  4. Use the local server at http://localhost:4213
  5. 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.