Key Information:

• DuckDB is built for simple use of modern database technology and runs on multiple platforms and languages.
• The included CLI has advanced features but is cumbersome for long queries. Third-party UIs are available but not straightforward to use.
• The DuckDB UI is a collaboration between DuckDB Labs and MotherDuck and is available with DuckDB v1.2.1.
• It uses interactive notebooks, shows database and table summaries, has a column explorer, and supports notebooks and more.
• It runs queries locally, has a small footprint in the .duckdb directory, and is implemented as a DuckDB extension.
• It is under active development with expected additions and improvements.
• For help and feedback, file an issue or join the relevant channels.

Important Details:

• Start the UI from the terminal with -ui or a SQL command CALL start_ui().
• The UI shows attached databases, table summaries, and supports notebooks with syntax highlighting and autocomplete.
• The right panel contains the Column Explorer.
• For MotherDuck integration, sign in to persist files and tables.
• The UI extension's code is open source except for the frontend.
• In the update, licensing of frontend code is being reviewed, offline operations are being worked on, and the client-server protocol will be opened up.