MotherDuck (Destination)

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy

Loads data into MotherDuck.

Configuration

warehouse:
  kind: motherduck
  motherduck_token: ${MOTHERDUCK_TOKEN}
  database: my_database
  schema: main

Field	Default	Description
motherduck_token	(required)	MotherDuck token
database		Database name
schema		Target schema

CLI

skippr connect warehouse motherduck \
  --motherduck-token "md:..." \
  --database my_database \
  --schema main

Flag	Description
--motherduck-token	(required) MotherDuck token
--database	Database name
--schema	Target schema (default: main)

Authentication

Configure motherduck_token directly when you connect the warehouse or in skippr.yaml.

For security best practices, we strongly advise against storing the token in skippr.yaml. Use environment variable interpolation instead: replace the motherduck_token value with your own ${ENV_VAR} reference.

The relevant part of skippr.yaml looks like this:

warehouse:
  kind: motherduck
  motherduck_token: ${MOTHERDUCK_TOKEN}

Set the env var before running skippr:

macOS / Linux

export MOTHERDUCK_TOKEN="md:..."

Windows PowerShell

$env:MOTHERDUCK_TOKEN = "md:..."

Windows Command Prompt

set MOTHERDUCK_TOKEN=md:...

Permissions or Network Requirements

The token must have write access to the selected MotherDuck database and schema. The machine running skippr also needs outbound network access to MotherDuck.

Troubleshooting

Symptom	Fix
authentication failed	Verify the configured MotherDuck token and confirm it still has access to the selected database.
schema errors	Check the database and schema names and confirm the token can create or write objects there.

CDC Support

MotherDuck supports CDC with exactly-once final-state reconciliation using DuckDB MERGE semantics. Skippr automatically creates _skippr_order_token columns and tombstone tables.

See CDC Destinations -- MotherDuck for details.

Next steps

• Pair this destination with a source from Source Connectors.
• For CDC semantics, see CDC Destinations, CDC Guarantees, and CDC Operations.

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy