MotherDuck weekly
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.
Pulled the last 12 weeks from motherduck. Up +38% vs. the prior period — growth accelerating in the last four weeks.
Basedash connects to MotherDuck through its PostgreSQL endpoint and queries your DuckDB databases directly.
Read the MotherDuck setup guideFind your Postgres endpoint
In MotherDuck, open Settings > Postgres endpoint and copy the regional host.
Enter the database and token
Add the MotherDuck database name and a service-account or read-scaling access token.
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.
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.
More warehouse sources
See all integrationsWe'll walk through how Basedash works with MotherDuck and answer questions for your exact use case.