Skip to main content

​
MotherDuck Integration

MotherDuck integration enables Annie to query your cloud analytics data using DuckDB SQL, explore database schemas, and correlate analytics findings with infrastructure events during incident investigations.

​
Setup Guide

  1. Go to the Anyshift integrations page
  2. Navigate to the Analytics section
  3. Click Connect MotherDuck
  4. Enter a Name for your token (e.g., “Production MotherDuck”)
  5. Provide your MotherDuck API Token
  6. Click Save MotherDuck token
Anyshift validates the token against MotherDuck’s API on save. If validation fails, check that your token is correct and has not expired.

​
MotherDuck API Token

  1. Sign in to app.motherduck.com
  2. Go to Settings > Access Tokens
  3. Create a new access token (read-only is sufficient for Annie)
  4. Copy the token and paste it into the Anyshift integration form

​
How It Works

Once connected, Annie can query your MotherDuck databases during investigations and chat sessions. Annie’s AI agent can:
  • List and explore databases — discover available databases, tables, columns, and shares
  • Run SQL queries — execute read-only DuckDB SQL against your cloud data
  • Search the catalog — fuzzy-search across databases, tables, and columns to find relevant data
  • Discover external connections — identify configured S3 buckets, Azure storage, and other data sources accessible through MotherDuck

​
Data Annie Can Access

Annie queries your MotherDuck account using DuckDB SQL. This includes:
  • MotherDuck databases — your own databases and shared datasets
  • Attached storage — S3 buckets, Azure Blob Storage, or GCS buckets connected via DuckDB secrets
  • Sample data — MotherDuck’s shared sample datasets (NYC taxi, Hacker News, etc.)
Annie uses read-only queries by default and always applies LIMIT clauses to avoid returning excessive data.

​
Security

  • Your MotherDuck token is encrypted at rest using AWS KMS
  • The token is never exposed to the AI agent — it is resolved at request time by the agent gateway
  • Annie uses read-only queries and cannot modify or delete data

​
Troubleshooting

​
”Invalid MotherDuck Token”

  • Verify your token at app.motherduck.com > Settings > Access Tokens
  • Ensure the token has not expired or been revoked
  • Read-scaling tokens and access tokens are both supported

​
”MotherDuck MCP unreachable”

  • MotherDuck’s MCP endpoint may be temporarily unavailable
  • Check MotherDuck status for outages
  • Retry after a few minutes

​
Annie doesn’t use MotherDuck tools

  • Verify the integration shows Active status on the integrations page