Blog

Data

MotherDuck Is Now a Certified Destination in Airbyte

MotherDuck is now a certified destination in Airbyte, enabling teams to seamlessly move data into MotherDuck for fast and scalable analytics.

DATA

June 11, 2026

Kushal Chatterjee

Summarize with AI:

If you're using DuckDB and need a reliable way to integrate all your data sources, we've got you covered.

The MotherDuck destination connector in Airbyte is now officially certified. We’re excited about this partnership and future opportunities to integrate Airbyte and MotherDuck.

What is MotherDuck?

MotherDuck is the serverless data warehouse built on DuckDB. Uniquely, MotherDuck uses a hypertenancy architecture: each user, service, or agent gets a dedicated compute instance called a Duckling. Queries run on these isolated instances, ensuring millisecond performance and complete isolation of compute, without resource contention.

MotherDuck is tightly integrated with the DuckDB ecosystem. You can connect instantly using a DuckDB extension, then download data locally to test and develop using the same workflows you’ll deploy to the cloud. With user interfaces from an MCP Server, to Python, to the DuckDB CLI, MotherDuck makes it trivial to query manually or with an agent at the wheel.

What data sources can I sync to MotherDuck?

Any of the 700+ data sources available on Airbyte. Once you've set up the MotherDuck destination, you can pull data from sources like HubSpot, Stripe, Salesforce, GitHub, Slack, and hundreds more into a single queryable destination.

Destination features

The MotherDuck destination implements the Destinations V2 specification. This means your tables are properly typed and automatically deduplicated. That means no raw JSON blobs to deal with downstream.

All sync modes are supported:

Full Refresh (Overwrite)
Full Refresh (Append)
Full Refresh (Overwrite + Deduped)
Incremental Sync (Append)
Incremental Sync (Append + Deduped)

All tables automatically include three system-generated columns: _airbyte_raw_id, _airbyte_extracted_at, and _airbyte_meta. These contain metadata about the sync operation. The connector also supports namespaces, so you can configure where Airbyte writes tables..

How to set it up

Adding the MotherDuck destination takes about two minutes.

Click the Add destination button on your Airbyte instance. Find MotherDuck and click the Add button.

Enter the database where you want your data written. The database path uses the md: prefix. For example, if you want the data in a database named my_database, type md:my_database.

Click the API key field and paste in your MotherDuck access token. Make sure that you do not include the access token in the database path as it may end up in your logs.

Click the Save button and you’re ready to go!

Select the data sources that you would like to sync with MotherDuck and choose the sync schedule for your data.

Who should use this

Teams building with AI

Once your data lands in MotherDuck, it's instantly available to your AI tools and agents. Query in natural language through our MCP Server — from Claude, ChatGPT, or Cursor, no SQL required. And because every user, service, and agent gets its own compute instance, a busy agent firing thousands of queries never slows anyone else down.

Teams with low-latency query needs

MotherDuck's hypertenancy architecture gives every user and service their own dedicated compute instance against shared data, so queries return in milliseconds and no one waits on a shared cluster. Ideal for customer-facing analytics and dashboards that have to feel instant.

Teams that want visualizations built in

No need to bolt on a separate BI tool. Turn your synced data into a Dive — an embeddable data app you can build in minutes and drop straight into your product or share with your team.

What does "certified" mean?

Certified connectors get direct maintenance from Airbyte engineers, are tested and production ready, and have pre-planned version upgrade grace periods.

The MotherDuck connector has been live since late 2024. It has gone through 20+ releases addressing DuckDB version upgrades (now on v1.4.2), special character handling in stream names, and unicode support in database and table names.

Try it out

Set up the MotherDuck destination in Airbyte Cloud or read about all the configuration options in the connector documentation. If you have DuckDB installed locally, MotherDuck offers a free tier for getting started with its cloud platform.

Integrate with 700+ apps using Airbyte

Move data from 700+ sources into warehouses, lakes, and beyond. Set up pipelines in minutes with pre-built connectors and the Connector Builder.

Try it free Talk to sales

About the Author

Kushal Chatterjee

Kushal is Senior Product Marketing Manager at Airbyte

Integrate with 700+ apps using Airbyte

Try Airbyte for free

MotherDuck Is Now a Certified Destination in Airbyte

Integrate with 700+ apps using Airbyte

Integrate with 700+ apps using Airbyte

Related posts