MotherDuck Destination Connector

Replicate data from 300+ sources into MotherDuck with Weld. Fully managed pipelines your agents can query.

Start for free

4.8 on G2

Weld · Data Sources

Weld

MotherDuckLive

ShopifySynced

HubSpotSynced

SalesforceSynced

StripeSyncing

Google AdsQueued

300+ sourcesQueryable over MCP

How it works

Set up in minutes.
No code, no maintenance.

MotherDuck

Destination

Host

account.motherduck.com

Database

analytics_db

Destination

MotherDuck as your warehouse.
Where your agents query.

Use MotherDuck as your central data warehouse with Weld. Connect any of 300+ sources and land clean, structured data in MotherDuck, ready for SQL, dbt models, BI tools, and agents over the Weld MCP server.

Weld MCP server

Ask your agent.
It can reach MotherDuck.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It finds the MotherDuck tables Weld has synced and queries your warehouse.

DiscoverSynced tables, columns and freshness
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCP

What data do we have in MotherDuck, and is it fresh?

Checking what Weld has synced into MotherDuck.

●weld·search_available_references

⎿raw.shopify.*

raw.hubspot.*

raw.salesforce.*

tables, columns and freshness

●weld·get_reference_schema

⎿columns, types and nullability

●weld·run_query

⎿select count(*) from {{raw.shopify.…}}

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from your MotherDuck warehouse

>Ask about your MotherDuck dataMCP

Sources

Replicate any source to MotherDuck.
300+ connectors, set up in minutes.

Resources

Everything you need.
To get started.

MCP server

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

FAQ

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create MotherDuck connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a MotherDuck ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "motherduck",
    "destination_schema_name": "motherduck_data",
    "sync_interval": "0 * * * *"
  }'
▌