Skip to content

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/mcp
the first call
do {  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.

  1. 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
  2. 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
  3. 03

    Make the first call. Check before a write.

    Ask in plain words; Claude picks the action. Before anything changes, check validates 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
  1. Tokens

    3

    1 read · 1 write · 1 destructive

    Create an access token for a user · List a user's access tokens · Invalidate a user access token

  2. Users

    3

    1 read · 1 write · 1 destructive

    List users in the caller's organization · Delete a user · Create new user

  3. Ducklings

    2

    1 read · 1 write · 0 destructive

    Get user Duckling configuration · Set user Duckling configuration

  4. Accounts

    1

    1 read · 0 write · 0 destructive

    Get active accounts

  5. Dives

    1

    0 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.

ActionWhat it doesEffectSame name in
motherduck.users_listList users in the caller's organizationLists users in the authenticated user's organization, ordered by username. Requires the 'member_management.view_all_members' privilege. Results are paginated:…readidentity.user.list474 connectors
motherduck.users_deleteDelete a userPermanently delete a user and all of their data. THIS CANNOT BE UNDONEdestructiveidentity.user.delete253 connectors
motherduck.user_tokens_createCreate an access token for a userCreate an access token for a userwriteidentity.api_key.create100 connectors
motherduck.user_tokens_listList a user's access tokensList a user's access tokensreadidentity.api_key.list96 connectors
motherduck.service_accounts_createCreate new userCreate user is currently restricted to creating a user with a 'Member' rolewriteidentity.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' rolereadthis connector
motherduck.duckling_config_getGet user Duckling configurationGets Duckling (instance) configuration for a user. Requires 'Admin' role.readthis connector
motherduck.duckling_config_setSet user Duckling configurationSets Duckling (instance) configuration for a user. Requires 'Admin' rolewritethis connector
motherduck.dive_embed_sessions_createCreate a Dive embed session for a service accountCreates an embed session for the specified Dive.writethis 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.

  1. Readread

    Who has access in MotherDuck? List every user and their role.

    callsmotherduck.users_list

  2. Writewrite

    Create an access token for a user in MotherDuck. Show me exactly what you will send before you save it.

    callsmotherduck.user_tokens_create

Governance for MotherDuck

Destructive actions wait for a yes.

2 MotherDuck actions are destructive. These are all of them:

  • Delete a usermotherduck.users_delete
  • Invalidate a user access tokenmotherduck.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.

domotherduck.users_deleteconfirm_policy: human

Delete a user?

intent: the user asked me to delete a user

run suspended · waiting for a named person · key motherduck-agent cannot confirm itself
In the console, or from an emailed signed link.
a key for this connector
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]" }  ]}
Illustrative. Scoped to MotherDuck only, capped at 2,000 upstream calls, every write confirmed, and the destructive ones approved by a named person.

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

See pricing

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 userwrite
  • motherduck.user_tokens_deleteInvalidate a user access tokendestructive
  • motherduck.user_tokens_listList a user's access tokensread
Users3
  • motherduck.service_accounts_createCreate new userwrite
  • motherduck.users_deleteDelete a userdestructive
  • motherduck.users_listList users in the caller's organizationread
Ducklings2
  • motherduck.duckling_config_getGet user Duckling configurationread
  • motherduck.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.