Connectors · Observability & analytics
MotherDuck MCP server for AI agents.
actionlake is an MCP gateway: one remote MCP server that connects Claude and other MCP clients to MotherDuck and the rest of your systems. It gives your agent 10 MotherDuck actions (4 reads, 4 writes and 2 that wait for a confirmation) and holds the MotherDuck credential itself, so the agent never does. It paces MotherDuck's limits and records every call.
100,000 free calls a month. No card, no email, no password: press Start a free sandbox on the next screen and keep the key it shows you.
claude mcp add --transport http actionlake https://connect.actionlake.com/mcpdo { action: "motherduck.users_list", intent: "check which MotherDuck account is connected"}# List users in the caller's organization · read · 1 upstream call- 10actionsin one signed file
- 4readlook, never change
- 4writecreate and update
- 2wait for a yesdestructive, confirmed first
Set up
Connect MotherDuck in three steps.
- 01
Add actionlake to Claude.
Run the command once in Claude Code; its consent page can create a free sandbox: 100,000 calls a month, no card. In the Claude app, add a custom connector with the URL below and paste your key on the consent page. Creating a new sandbox from the Claude app is not yet tested by us.
https://connect.actionlake.com/mcp - 02
Connect MotherDuck.
Bearer token. No consent screen: your agent can connect it for you, but the key then passes through your chat. To keep it out of the model's context, paste it in the console instead. actionlake stores what you paste write-only, sealed under your tenant's key.
access_tokenMotherDuck access token (Settings > Access Tokens)
account { op: "connections.requirements", service: "motherduck" } # free: exactly what to paste, and what is found for you - 03
Make the first call. Check before a write.
Ask in plain words; Claude picks the action. Before anything changes,
checkvalidates the call and prices it, for free.do { action: "motherduck.users_list" }# list users in the caller's organization · read · 1 upstream callcheck { action: "motherduck.users_delete", input: { … } }# free: inputs, permissions, cost and confirmations, nothing sent
MotherDuck at a glance
- Sign-in
- Bearer token. No consent screen: your agent can connect it for you, but the key then passes through your chat. To keep it out of the model's context, paste it in the console instead.
- You provide
access_token- Limits we pace to
- 60 calls a minute, per connection
- API covered
- MotherDuck REST API 1.0.0 (OpenAPI 3.0.3)
api.motherduck.com - Built from
- MotherDuck's documentation, read 23 October 2026api.motherduck.commotherduck.com
- Service file
- Version 1.0.0, signed (Ed25519)
- Cached reads
- 3 of 4 reads, for up to 15 minutes; a write clears what it affects
- Shared entities
- 1, so ask can line MotherDuck up with your other systems
- Data
- Processed and stored in Sydney, Australia. No US region yet
Capabilities
What an AI agent can do in MotherDuck.
10 actions in 5 areas. Every one carries its effect, so a key can allow the reads and hold the rest.
- 4readlook, never change
- 4writecreate and update
- 2destructivewait for a confirmation
Tokens
31 read · 1 write · 1 destructive
Create an access token for a user · List a user's access tokens · Invalidate a user access token
Users
31 read · 1 write · 1 destructive
List users in the caller's organization · Delete a user · Create new user
Ducklings
21 read · 1 write · 0 destructive
Get user Duckling configuration · Set user Duckling configuration
Accounts
11 read · 0 write · 0 destructive
Get active accounts
Dives
10 read · 1 write · 0 destructive
Create a Dive embed session for a service account
Top actions
The MotherDuck API, shaped for agents.
The ids your agent types, what each does, and the one name it shares with other systems. 6 of MotherDuck's 6 action names are shared with at least one other connector, so an agent learns them once.
| Action | What it does | Effect | Same name in |
|---|---|---|---|
motherduck.users_listList users in the caller's organization | Lists users in the authenticated user's organization, ordered by username. Requires the 'member_management.view_all_members' privilege. Results are paginated:… | read | identity.user.list474 connectors |
motherduck.users_deleteDelete a user | Permanently delete a user and all of their data. THIS CANNOT BE UNDONE | destructive | identity.user.delete253 connectors |
motherduck.user_tokens_createCreate an access token for a user | Create an access token for a user | write | identity.api_key.create100 connectors |
motherduck.user_tokens_listList a user's access tokens | List a user's access tokens | read | identity.api_key.list96 connectors |
motherduck.service_accounts_createCreate new user | Create user is currently restricted to creating a user with a 'Member' role | write | identity.service_account.create32 connectors |
motherduck.active_accounts_listGet active accounts | [Preview] Get active accounts in an organization along with active Ducklings per account. Requires 'Admin' role | read | this connector |
motherduck.duckling_config_getGet user Duckling configuration | Gets Duckling (instance) configuration for a user. Requires 'Admin' role. | read | this connector |
motherduck.duckling_config_setSet user Duckling configuration | Sets Duckling (instance) configuration for a user. Requires 'Admin' role | write | this connector |
motherduck.dive_embed_sessions_createCreate a Dive embed session for a service account | Creates an embed session for the specified Dive. | write | this connector |
Try it
Prompts to paste into Claude.
Each one names the MotherDuck actions it will call, so you know what it reads and what it changes before you send it.
- Readread
Who has access in MotherDuck? List every user and their role.
calls
motherduck.users_list - Writewrite
Create an access token for a user in MotherDuck. Show me exactly what you will send before you save it.
calls
motherduck.user_tokens_create
Governance for MotherDuck
Destructive actions wait for a yes.
2 MotherDuck actions are destructive. These are all of them:
- Delete a user
motherduck.users_delete - Invalidate a user access token
motherduck.user_tokens_delete
A destructive action runs only with confirm: true. Under the human policy the agent cannot confirm for itself: the run stops until a named person approves, in the console or from a signed link in an email. The cap on a key is refused before the call is sent, never after.
Delete a user?
intent: the user asked me to delete a user
account { op: "keys.create", name: "motherduck-agent", allowed_actions: ["motherduck.*"], cap_calls: 2000, confirm_policy: "human_for_writes", approval_rules: [ { match: "motherduck.users_delete", approver: "[email protected]" }, { match: "motherduck.user_tokens_delete", approver: "[email protected]" } ]}Cost
What MotherDuck costs on actionlake.
Every MotherDuck action is one upstream call, the only thing actionlake bills. Searching, check, cost, account and any call MotherDuck refused with 401, 403, 429 or a 5xx are free. Paid plans start at US$49 a month for 250,000 calls, with overage from US$0.30 down to US$0.18 per 1,000.
- 1upstream call per actionall 10 MotherDuck actions
- 10actions pageeach page of a long list is one call
- 3reads can be cacheda cache hit costs nothing
- 100,000calls a month, freepaid plans from US$49 a month for 250,000
Action index
Every MotherDuck action.
10 actions by area: the id your agent calls, what it does, and its effect.
Tokens3
motherduck.user_tokens_createCreate an access token for a userwritemotherduck.user_tokens_deleteInvalidate a user access tokendestructivemotherduck.user_tokens_listList a user's access tokensread
Users3
motherduck.service_accounts_createCreate new userwritemotherduck.users_deleteDelete a userdestructivemotherduck.users_listList users in the caller's organizationread
Ducklings2
motherduck.duckling_config_getGet user Duckling configurationreadmotherduck.duckling_config_setSet user Duckling configurationwrite
Accounts1
motherduck.active_accounts_listGet active accountsread
Dives1
motherduck.dive_embed_sessions_createCreate a Dive embed session for a service accountwrite
Questions
The MotherDuck MCP server, answered.
Is there a MotherDuck MCP server for Claude?
Yes. actionlake is an MCP gateway: a remote MCP server that gives Claude, or another MCP client, 10 MotherDuck actions across tokens, users, ducklings and accounts, through the same eight tools it uses for every other connector. actionlake is independent; it is not made or endorsed by MotherDuck.
What do I need to connect MotherDuck?
MotherDuck access token (Settings > Access Tokens). The free call account { op: "connections.requirements", service: "motherduck" } lists exactly what to paste.
Can an AI agent delete or change things in MotherDuck?
Only if its key allows it, and only with an explicit confirmation. 2 MotherDuck actions are destructive, including delete a user and invalidate a user access token. Each runs only with confirm: true. Under the human confirm policy, or an approval rule on the key, the run waits until a named person approves it.
Will an AI agent use up my MotherDuck API limit?
actionlake paces every call to the limits in the MotherDuck service file: 60 calls a minute per connection. Repeated reads are answered from cache (3 MotherDuck actions can be), which never reaches MotherDuck.
What does a MotherDuck action cost?
One upstream call, the only unit actionlake bills. A list that pages bills one call per page (10 MotherDuck actions page). Cache hits, searches, dry runs and calls MotherDuck refused with 401, 403, 429 or a 5xx are free. The Free plan includes 100,000 calls a month with no card. Paid plans start at US$49 a month for 250,000 calls, with overage from US$0.30 down to US$0.18 per 1,000.
Which MotherDuck API does it cover?
The MotherDuck REST API 1.0.0 (OpenAPI 3.0.3) at api.motherduck.com. It is built from MotherDuck's documentation as read on 23 October 2026. 10 actions in 5 areas, each one in the signed service file (version 1.0.0).
Does actionlake keep my MotherDuck data, and where?
actionlake processes and stores data in Sydney, Australia; there is no US region yet. Reads may be cached for up to 15 minutes, and a write clears the reads it affects. Each run's request and response is kept, sealed, for your plan's trace window: 1 day on Free, 3 days on Starter, 7 days on Pro, 14 days on Team, 30 days on Business and 30 days on Enterprise. Your MotherDuck credential is sealed under your tenant's key, never logged and never returned. Your traffic is not used to train models.
Which AI clients can use it?
Claude Code, tested by us end to end, and the Claude app as a custom connector, tested by us with an existing key. Other MCP clients that support remote servers over Streamable HTTP (MCP revisions 2025-06-18 and 2025-11-25) and OAuth dynamic client registration, or a bearer header, should connect the same way; we have not tested them. Or plain REST, under the same action names.
Give your agent MotherDuck today.
Start free - 100,000 calls/month, no card. No signup. Hard caps on every key. Cached answers are free.