Introducing Flights: agent-native data pipelines in MotherDuckJoin the livestream

Skip to main content

DuckDB UI

DuckDB UI is a local SQL interface for DuckDB. You can use it with MotherDuck when you want a lightweight SQL workspace backed by the DuckDB CLI and an md: connection.

How it works with MotherDuck​

  1. Install and start DuckDB UI from a DuckDB environment that can authenticate to MotherDuck.
  2. Store your MotherDuck token in the motherduck_token environment variable or use another supported MotherDuck authentication method.
  3. Connect to MotherDuck with an md: database path and validate the session with a small query.

Example​

ATTACH 'md:' AS motherduck;
SELECT current_database();

Related content​