MotherDuck MCP connector
The MotherDuck connector lets Claude, ChatGPT, Cursor and the Elaichi Agent query your MotherDuck databases, browse tables and shares, and work with dives and flights, with every query running inside the signed-in person's own access.
-
How it connects. Connects over OAuth. The credential goes into a vault nobody reads back.
-
One address. https://api.elaichi.ai/mcp, the same for every user.
-
Their own access. An agent never gets more than the person it acts for.
39 tools
How to connect
How to connect MotherDuck to Claude, ChatGPT or Cursor
Two steps, about a minute.
In Elaichi
Connect MotherDuck once
-
Open Connections, choose Add connection, and pick MotherDuck.
-
Optionally set Share with to give a team access, then press Connect.
-
Approve it in MotherDuck. MotherDuck's own window opens. Whoever approves it decides what this connection can reach.
The credential is vaulted. Nobody reads it back, not even the AI.
Add connection
Choose a connector.
In your AI client
Point it at one endpoint
Everyone in the organization uses the same address, and each person only ever reaches what their own account allows.
MotherDuck MCP connector for Claude
-
1
Open Customize, then Connectors.
-
2
Press Add.
-
3
Name it, paste the MCP server URL, then Continue.
https://api.elaichi.ai/mcp -
4
Sign in and approve.
On Team and Enterprise, an Owner adds it once. Everyone else turns it on for themselves.
MotherDuck MCP connector for ChatGPT
-
1
Open Plugins, then press the + button.
-
2
Name it and paste the endpoint into Server URL.
https://api.elaichi.ai/mcp -
3
Leave Authentication on OAuth, then tick the risk acknowledgement.
-
4
Press Create, then sign in and approve.
Works on the web today. The plugin directory lives at chatgpt.com/plugins.
MotherDuck MCP connector for Cursor
-
1
Open
~/.cursor/mcp.json. -
2
Add the endpoint under
mcpServers.https://api.elaichi.ai/mcp -
3
Reload Cursor, then sign in and approve.
~/.cursor/mcp.json
{
"mcpServers": {
"elaichi": {
"url": "https://api.elaichi.ai/mcp"
}
}
}
Set up per machine, so repeat it on each computer you work from.
Connect MotherDuck to any MCP client
-
1
Add the endpoint as a remote MCP server.
https://api.elaichi.ai/mcp -
2
Sign in and approve.
{
"mcpServers": {
"elaichi": {
"url": "https://api.elaichi.ai/mcp"
}
}
}
The Elaichi Agent already has these tools, with nothing to set up.
Use cases
What teams do with MotherDuck through Elaichi
Every one of these runs inside the access the person already has, and lands in the same audit log.
-
Analytics
Answer a metrics question without writing SQL
Ask for last quarter's revenue by region and the agent finds the right table in MotherDuck, runs the query and explains the result in plain language.
-
Finance
Check month-end numbers against the warehouse
Pull totals from the billing and orders tables in MotherDuck and compare them with the close spreadsheet before anyone signs off.
-
Sales
Pull pipeline figures from the sales database
Get open pipeline by owner and stage straight from MotherDuck ahead of the Monday forecast call, without waiting on a data request.
-
Marketing
Measure a campaign from the events tables
Ask how many signups came from last week's campaign and the agent queries the events and attribution tables in MotherDuck for you.
-
Data
Find the right table before building anything
Search the MotherDuck catalog for a column or view, see what each one holds, and ask the docs how a feature works instead of guessing.
-
Operations
Save a recurring check as a dive
Turn a weekly inventory or SLA query into a saved dive in MotherDuck, update it as the question changes, and share the results with the team.
Try asking
- “Which tables in the sales database were updated this week?”
- “Show me last month's revenue by region from the orders table.”
- “Save this churn analysis as a dive and share it with Finance.”
Compare
Elaichi vs Zapier MCP vs Composio for MotherDuck
All three can connect MotherDuck to an AI assistant, and all three have admin controls. They differ in where access lives and how you pay.
| What to check | Elaichi | Zapier MCP | Composio |
|---|---|---|---|
| Where the AI connects |
One address for the whole organization.
https://api.elaichi.ai/mcp
|
A server per member, created at sign-in. | An MCP endpoint per team, or an SDK. |
| Control over MotherDuck tools | Allow or restrict single MotherDuck tools, per role or user. | App and action restrictions on the account. | Role permissions, down to the action. |
| Record of calls | One audit entry per MotherDuck call. | A History tab of tool calls. | A log of every tool call. |
| Single sign-on | SAML or OIDC, plus SCIM, on Gold. | SAML on Enterprise. | SAML and OIDC on Enterprise. |
| Price | $15 per user per month. | 2 tasks per successful call. | Billed per tool call. |
Sources: Zapier MCP docs, security, usage; Composio docs, gateway, enterprise, pricing. Checked September 2026.
Longer take: Zapier MCP alternative and when you don't need an MCP gateway.
AI tools
MotherDuck tools for your AI agents
39 tools are ready to call through Elaichi's MCP endpoint the moment you connect MotherDuck, governed by the same roles, restrictions, and audit log as everything else in Elaichi. MotherDuck builds and runs these tools.
No tools match your search.
See it in Elaichi
What connecting MotherDuck gets you
6 screens from the product, each doing one job for your MotherDuck account.
The agent
Ask MotherDuck questions in plain language.
Get answers from live tables, views and shares without writing a line of SQL.
- databases
- tables
- dives
- flights
Ask Elaichi to work across your apps.
Which tables in the sales database were updated this week?
Show me last month's revenue by region from the orders table.
Save this churn analysis as a dive and share it with Finance.
Also runs in Claude, ChatGPT or Cursor
MCP clients
One governed endpoint reaches MotherDuck from every client.
Claude, ChatGPT and Cursor connect over OAuth, with no SDK and no shared API key.
ElaichiMCP clientsClaude
ChatGPT
Cursor
Copy the endpoint
Tool catalog
39 MotherDuck tools, ready with no connector code.
Databases, tables, columns, views, macros, dives and flights, covered the moment you connect.
- List databases
- List shares
- List tables
- List columns
ElaichiToolsToolboxes
Every team gets its own MotherDuck toolbox.
Scope what Finance, Sales and Data can reach, each from one shared endpoint.
- Data
- Analytics
- Finance
- Sales
ElaichiToolboxesShared connections
Teammates query MotherDuck without ever seeing a credential.
One person connects an account and shares it; nobody else handles a credential.
- Data platform
- Analytics
- Finance
- Sales ops
ElaichiConnectionsAudit log
Every MotherDuck query is logged with a name.
See when, who, what happened, type and resource for every call, in an append-only log.
- When
- Who
- What happened
- Type
ElaichiAudit logLaunching soon
From answering questions to doing the work
A person no longer has to ask. A trigger starts the work, inside the same permissions and the same audit log as everything else. Automations and live dashboards are launching soon, on the Black plan.
Automations
Schedules turn MotherDuck tables into approved digests.
Records are fetched, grouped and drafted, a person approves, then it posts back to MotherDuck.
MotherDuck digest
Run 418 · started 2 minutes ago · on behalf of Emily Carter
-
✓
Schedule
Every weekday at 8:00 AM
0.2s -
✓
Fetch databases
MotherDuck
1.4s -
✓
Group by owner
Transform
0.1s -
✓
Draft the digest
Agent step
Ran with 4 tools, returned a structured summary
6.2s -
Approve the digest
Needs approval
Assigned to Michael Brennan
Approve Deny -
Post the digest
MotherDuck
Queued
Collections and dashboards
MotherDuck health numbers arrive before anyone asks.
Four metrics and a 14 day chart, computed on a schedule with no model involved.
MotherDuck health
Refreshed 4 minutes ago · every 15 minutes · from the databases collection
Databases
1,284 ↓ 12%
Tables
96 ↓ 8%
Needs attention
3 ↑ 2
Updated this week
412 ↑ 9%
Databases created
Last 14 days
By team
Share of activity
Data platform 34%
Analytics 27%
Finance 21%
Sales ops 18%
Related connectors
More from the catalog
FAQ
Frequently asked questions
How do I connect MotherDuck to Claude?
Connect MotherDuck in Elaichi first; it signs in over OAuth, so you approve access in your MotherDuck account and there is no client ID or secret to generate. Then in Claude open Customize, then Connectors, then Add, and paste https://api.elaichi.ai/mcp as the endpoint. Claude signs you in through Elaichi and MotherDuck is ready to query.
Does MotherDuck work with ChatGPT and Cursor as well as Claude?
Yes. Once MotherDuck is connected in Elaichi, the same endpoint, https://api.elaichi.ai/mcp, works in Claude, ChatGPT, Cursor, any other MCP client and the Elaichi Agent. You connect MotherDuck once and every client picks it up.
What can an AI agent actually do with my MotherDuck data?
An agent can browse your MotherDuck databases, shares, tables, views and macros, search the catalog for the right column, run queries and explain the answers, and, where allowed, write results back. It can also save, update and share dives, create and update flights, and look up the MotherDuck docs when it is unsure. Short, concrete asks such as "revenue by region last month" work better than long paragraphs.
Can I stop an agent from deleting or changing things in MotherDuck?
Yes. In Elaichi you restrict actions one by one, so you can allow reading from MotherDuck tables while blocking writes, dive deletion or flight changes. A restricted action is never shown to Claude, ChatGPT or Cursor at all, so no prompt can reach it.
What happens to a MotherDuck connection when someone leaves?
Offboarding a person in Elaichi ends their access to MotherDuck through every client at once. If they had shared a MotherDuck connection with a team, it keeps working for everyone else. Disconnecting MotherDuck once in Elaichi removes it from Claude, ChatGPT, Cursor and every other client together.
Does the MotherDuck MCP connector work with Gemini, Codex, Claude Code or other MCP clients?
Yes. MotherDuck is reached over the same MCP endpoint every client uses, so anything that speaks MCP can call it — Gemini, Codex, Claude Code, Windsurf, Cline, Zed and OpenCode among them — alongside Claude, ChatGPT, Cursor, and the Elaichi Agent. The tools on offer and the access behind them are identical whichever client asks. Only the setup screen differs.
Is Elaichi an alternative to Zapier MCP for MotherDuck?
Yes. Both let Claude, ChatGPT or Cursor use MotherDuck. Zapier MCP fits a team that already automates in Zapier, since each person signs in and acts as themselves in that account. Elaichi fits when IT wants one address for the whole company, per-tool rules by role, and a record of every MotherDuck call.
How is Elaichi different from Composio for MotherDuck?
Composio gives AI agents tools and sign-in handling across 1,000+ apps, for developers building agents or people using an assistant, billed per tool call. Elaichi gives a company's own people governed access to MotherDuck: one address, restrictions per role or user, and $15 per user per month. Both have role permissions and a log of every call.
Put MotherDuck in front of your team
14 days on Gold, no credit card. Connect it once and pick what each team can call.
- Works with
-
and any other MCP client, or the Elaichi Agent.
- When the trial ends
- Nothing is deleted. Connections, roles and the audit log stay where they are, so subscribing picks up exactly where you left off.