Connect to DuckDB
To connect to a DuckDB database:
- Click the connection selector button
- Then click “Add connection”
![Add connection button](/_app/immutable/assets/add-connection.BkYFhzl9.png)
Next, click the “DuckDB” button:
![Select new connection type](/_app/immutable/assets/add-connection-duckdb.C1KDeHbi.png)
Then, fill in your connection details. Afterwards, click “Save”:
![New connection form](/_app/immutable/assets/form-duckdb.DkVTYfps.png)
- Name: An arbitrary name to identify the connection in DB Pilot.
- Database: The path to your database file.
Create a New Database
To create a new DuckDB database, go through the same flow as above but enter a new path (where there is no existing file) in the “Database” form field.
Connect to MotherDuck
To connect to a MotherDuck instance:
- Go through the same flow as above but enter a value starting with
md:
into the “Database” form field. - Click “Save”, then wait for the MotherDuck confirmation page to open in your web browser. This may take a while the first time you connect to MotherDuck. This is due to the MotherDuck extension being downloaded and installed by DuckDB.
- Once the page is open, click “Confirm”.
- Then return to DB Pilot.