Skip to content
All data sources
MotherDuck logo

MotherDuck is a serverless analytics platform built on DuckDB. Connect MotherDuck to Basedash to ask questions, build dashboards, and automate reporting with AI.

14-day trial. No credit card required.

Chat/MotherDuck growth
Connected
Show MotherDuck weekly trend over the last 12 weeks, with the prior period as a comparison.

Pulled the last 12 weeks from motherduck. Up +38% vs. the prior period — growth accelerating in the last four weeks.

MotherDuck weekly

94+38%(42)
MotherDuck
68+13%(38)
Prior period
12 weeks
0255075100W1W3W5W7W9W119468
Save it to the Acme Corp dashboard.
Ask a follow-up about MotherDuck…↵

Basedash connects to MotherDuck through its PostgreSQL endpoint and queries your DuckDB databases directly.

Read the MotherDuck setup guide
  1. Find your Postgres endpoint

    In MotherDuck, open Settings > Postgres endpoint and copy the regional host.

  2. Enter the database and token

    Add the MotherDuck database name and a service-account or read-scaling access token.

  3. Connect and sync

    Basedash checks the token, then syncs the database's schema.

Access Basedash needs

  • A service-account or read-scaling access token
  • Access to the one database Basedash should sync

Imagine ChatGPT or Claude, but with full context of your MotherDuck schema and how your team uses it. Basedash answers in plain language, backed by real queries.

Try asking

  • Revenue by region from MotherDuck for the last four quarters.
  • Which MotherDuck tables power our core KPIs, and how fresh are they?
  • Compare weekly active accounts in MotherDuck against last year.
  • Break down MotherDuck orders by product line and channel.

Plain-language queries

Ask follow-ups in natural language. Basedash translates them into SQL against your MotherDuck data.

Knows your business

Basedash learns your KPIs, schemas, and the way your team talks about MotherDuck.

Agentic by default

Runs multiple queries, resolves errors, and keeps iterating until the answer is right.

Keep querying MotherDuck directly, and sync your SaaS tools into a managed warehouse to see how sales, finance, product, and operations actually connect.

  • Queries run in placeBasedash connects to MotherDuck directly and queries your data where it lives. No copies to keep in sync.
  • Scoped credentialsConnect with a dedicated MotherDuck user or key so Basedash only sees the data you grant.
  • SaaS data alongsideSync CRM, billing, and support tools into Basedash Warehouse and analyze them in the same workspace.
Explore the warehouse

Common questions about MotherDuck and Basedash

Which MotherDuck token should I give Basedash?

Use a service-account token or a read-scaling token. A read-scaling token is the better fit because Basedash's queries then don't compete with your other MotherDuck workloads. Limit it to the database Basedash needs and rotate it regularly.

What host does Basedash use for MotherDuck?

Basedash uses your account's regional PostgreSQL endpoint, which you'll find in MotherDuck under Settings > Postgres endpoint. Don't use a MotherDuck API URL. Enter the endpoint as the host, then the exact name of the database you want Basedash to sync.

Why does my MotherDuck connection fail in Basedash?

Check that the host is the regional PostgreSQL endpoint, that the database name exists in your account, and that the token is active, can access that database, and is a service-account or read-scaling token. The connection settings docs explain each error message.

We'll walk through how Basedash works with MotherDuck and answer questions for your exact use case.