Skip to main content
This guide explains how to connect SYNQ to your MotherDuck account securely.We need this information so we can collect relevant metadata about your DuckDB tables for monitoring and data quality testing.To be able to finish this guide, you’ll need the following:
→ Access to your MotherDuck workspace and API token⏱️ Estimated time to finish: 5 minutes.

​
Data we collect

For automated data anomaly testing, SYNQ collects the following from your MotherDuck instance:
  • Table names and metadata
  • Number of rows in each table
  • Timestamp of the last data update
SYNQ doesn’t access or store your raw data — only metadata needed to assess freshness, volume, and stability.

​
Setup MotherDuck Access

​
1. Get your MotherDuck account name

  1. Go to app.motherduck.com and log in.
  2. Click your profile icon in the top-right corner.
  3. In the dropdown, you’ll see your organization name and email.
    Your account name is typically your organization name (e.g. acme-corp) and often matches the prefix of your default database — for example, acme-corp.db.
You’ll need this account name when filling in the MotherDuck account field in SYNQ.

​
2. Generate a MotherDuck API token

  1. While logged in to app.motherduck.com, click your profile icon again and choose Account settings.
  2. Navigate to the API Tokens tab.
  3. Click Generate new token, give it a name (e.g. synq-integration), and choose an expiry period.
  4. Copy the generated token immediately — you won’t be able to see it again once you leave the page.
  5. Paste it into the MotherDuck API token field in SYNQ.
Alternatively, if you’re using the CLI, you can generate a token via: 
motherduck auth token
⌘I