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

Skip to main content

Stacksync

Stacksync helps your teams access and manipulate CRM and ERP data through your existing databases. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams.

How it works with MotherDuck​

Stacksync connects to MotherDuck for two-way sync workflows between MotherDuck and business systems.

Prerequisites​

  • A Stacksync workspace.
  • A MotherDuck access token.
  • Optional: the database name and schema if you do not want to use Stacksync's defaults.

Setup​

  1. In MotherDuck, open Settings > General and create an access token.
  2. Copy the generated token.
  3. In Stacksync, open Connections and select Create new connection.
  4. Search for and select MotherDuck.
  5. Paste the token.
  6. Update the database name or schema if required, then save the connection.

Stacksync MotherDuck connection form with token, database, and schema fields

Authentication and configuration​

  • Use a dedicated MotherDuck token for Stacksync.
  • Configure the database and schema fields when your sync should not use the defaults.
  • Revoke or rotate the token from MotherDuck when the Stacksync connection should no longer have access.

Important notes​

  • Stacksync's guide shows MotherDuck token creation from the web UI. If you use service accounts, create the token under the account that should own the sync access.
  • Test with a small sync before enabling a production two-way sync.

Use cases​

  • Sync operational app data into MotherDuck.
  • Use MotherDuck as a source for downstream business applications.
  • Keep CRM or ERP data in sync with a MotherDuck-backed analytics workflow.

Related content​