AgentDrives

MotherDuck

motherduck.com

MotherDuck is a cloud database service built on DuckDB.

Can an AI agent use MotherDuck? Yes, without signing up. Our agent got into MotherDuck on its own in 2 minutes and did all 10 of its core tasks.

Visit MotherDuck Follow changes

Category

Data warehouses

Connects by

MCP, API, CLI

Agent payments

None found

Driven 26 Oct 2026

From finding it to leaving

What an agent managed without a person, at each step.

  1. Find

    On its own

    Docs it can act on: llms.txt, an OpenAPI and an MCP server.

    596 doc pages read

  2. Get in

    On its own

    Try first, claim later, MCP sign-in, sign-up in a browser.

    2 minutes

  3. Use

    On its own

    Did: run queries and create databases and tables; build a chart (Dive) and embed it in a page.

    10 of 10 core tasks

  4. Pay

    Not reached

    Its robots.txt closes the payment page.

  5. Leave

    On its own

    Nothing to cancel, deletes its account.

Getting in

4 of 5 ways in worked without a person.

The way that worked

Try first, claim later2 minutes

  • An inboxNot needed
  • A browserNot needed
  • A personNot needed
  • Agent on a serverAPI, MCP, CLIPartlyWithout an account (try first, claim later) it gets an API key, makes its first API call and does all of the core work, then stops at payment: paying takes a checkout page in a browser.
  • Assistant in its own browserLike ChatGPT agentNot checkedSign-up wasn't tried in this drive.
  • Signed agentNot checkedNot checked: its robots.txt asks crawlers to stay off the sign-up page.

Every way in

Way inWhat happenedWhy
Try first, claim laterWorked
Email and passwordWorked
CLI code loginWorked
Sign-in for apps (OAuth, MCP)Worked
Sign-up by APINot triedThe same as another way
  • Crawlersrobots.txt asks crawlers to stay off sign-up and the API. Nothing to fix. It keeps these pages out of search and doesn't stop agents signing up.

What an agent can do with MotherDuck

All 10 core tasks done, and 20 of 23 others.

Core tasks

  • done there
TaskResultThrough
Run a SQL query against a MotherDuck databaseDoneMCPCLI
Create a databaseDoneMCPCLI
List databases and read their schemaDoneMCP
Create a tableDoneMCPCLI
Generate an interactive visualization (Dive) from a natural-language questionDoneMCPCLI
Embed a Dive in an external applicationDoneAPI
Build and deploy a scheduled Python data pipeline (Flight)DoneMCPCLI
Trigger a Flight run on demandDoneMCPCLI
Read Flight run history and logsDoneMCPCLI
Build a managed Iceberg/DuckLake lakehouse on cloud object storageDoneMCPCLI

  • Reliability

    70of 100

    Core tasks that worked on all 3 runs

  • Handles mistakes

    72of 100

    Clear errors, retries without duplicates, honest limits

  • Surface tested

    97of 100

    Documented routes, tools and commands run and checked

  • Docs accuracy

    99of 100

    Documented operations that behaved as the docs say

  • Docs completeness

    75of 100

    How fully the docs describe each operation

  • What it can't do, and why

    • Pay for a plan Buying is a card form in the web app; no billing API or agent payment.
    • Connect an Iceberg catalog Needs an outside catalog and cloud credentials the account lacked.
    • Keep a terminal-made account past 72 hours A person must claim it first.

20 of 23 other tasks done

  • Query a table as of a past time or snapshot version (time travel)Done
  • Create and manage a read-only data share of a databaseDone
  • Scope a share to specific tables and mask or filter rows/columnsDone
  • Restore a database from a snapshotDone
  • Create a named long-lived backup snapshotDone
  • Write a Guide capturing org metric definitions and query conventions for AI agentsDone
  • Read and browse existing Guides by topicDone
  • Update or edit a Guide's contentDone
  • Ask a natural-language documentation question (ask_docs_question)Done
  • Search the catalog for databases, tables, shares and GuidesDone
  • Auto-fix a broken SQL query (FixIt)Done
  • Visualize result-set columns instantly (Column Explorer)Done
  • Run SQL AI functions (prompt, embedding) over dataDone
  • Scale read workloads with read-scaling replicasDone
  • View consolidated query history across the organizationDone
  • Ingest data from cloud storage, databases, or SaaS sourcesDone
  • Resize compute instance type/sizeDone
  • Create a service account for programmatic accessDone
  • Restrict a connection to read-only database accessDone
  • Assign role-based access control to usersDone
  • Set up AWS PrivateLink or IP allowlisting for network accessPaid plan
  • Read Apache Iceberg tables via REST catalogBlocked
  • Invite an internal user to the organizationNot tried
  • Purchase via AWS Marketplace private offerNot tried

The plans they need

  • Set up AWS PrivateLink or IP allowlistingEnterprise

Paid-plan tasks don't count toward the level. The drive used the no-card trial (Business, 7 days) on the web account; Free Plan on the CLI account.

Surface audit: 194 documented operations, 187 run, 186 passed, 2 not as documented, 1 blocked (sandbox or plan limits), 3 not run for time, 5 left out to stay safe.

How an agent connects

MCP, API, OpenAPI, CLI and llms.txt found.

The standards

  • MCP server

    All tested

    Official server. Remote server, 47 tools when driven (SQL, schema, Dives, Flights, Guides, docs Q&A) Sign‑in needed to see its tools.

    api.motherduck.com/mcp

    41 tools across its docs

  • API

    All tested

    REST admin API, 10 operations (users, tokens, ducklings, embed sessions); data work is SQL.

    10 operations across its docs

  • OpenAPI

    Yes

    3.0.3, 10 operations.

  • CLI

    All tested

    MotherDuck CLI v1.5.6-2026-10-707: new, login (device flow), query, dive, flight, guide.

    35 commands across its docs

  • SDK

    94 tested

    101 methods across its docs

  • llms.txt

    Yes

    motherduck.com/llms.txt

  • Agent payments

    None found

    The checkout: Chose a plan; the checkout didn't open: Business, $250 a month; Checkout: Stripe Checkout; No CAPTCHA at checkout.

  • Docs

    No gaps in what we read

    Covers getting started, auth, error codes and code examples.

    12 of 12 documented ways to do the core work worked when tried.

    motherduck.com/docs/getting-started

    596 of 743 pages read

Tips for agent builders

From this drive

6 tips
  1. Install the MotherDuck CLI from https://install.motherduck.com and run 'motherduck new -o json' to get an account and token with no browser; delete it with DELETE /v1/users/<username> when done.
  2. On an existing account, use 'motherduck login --headless' then 'motherduck login --device-code=<code>' after a person confirms the code.
  3. Use the remote MCP server at https://api.motherduck.com/mcp with 'Authorization: Bearer <token>' (protocol 2025-11-25); call get_dive_guide or get_flight_guide before writing Dives or Flights.
  4. The MCP 'query' tool refuses CALL, SHOW ALL ROLES and EXPLAIN ANALYZE as not read-only: send them through query_rw.
  5. Find your username with GET /v1/users before calling /v1/users/{username}/... (the email's local part with '-' turned into '_').
  6. Create scoped tokens with POST /v1/users/{username}/tokens (ttl >= 300, token_type read_scaling for read-only).

How MotherDuck compares

In Data warehouses

1st of 2 Data warehouses products our agent got into on its own.

ProductLevelFind to leave
ClickHouse CloudL4Find: On its own, Get in: On its own, Use: On its own, Pay: Card checkout, Leave: On its own.
MotherDuckL4Find: On its own, Get in: On its own, Use: On its own, Pay: Not reached, Leave: On its own.
DatabricksL1Find: On its own, Get in: Stopped, Use: Not reached, Pay: Not reached, Leave: Not reached.
FireboltL1Find: On its own, Get in: Stopped, Use: Not reached, Pay: Not reached, Leave: Not reached.
SnowflakeL1Find: On its own, Get in: Stopped, Use: Not reached, Pay: Not reached, Leave: Not reached.
StarburstL1Find: On its own, Get in: Stopped, Use: Not reached, Pay: Not reached, Leave: Not reached.
TinybirdL1Find: On its own, Get in: Stopped, Use: Not reached, Pay: Not reached, Leave: Not reached.
All 7 in Data warehouses

Sorted by level, then work done, then time to the first call. How we rank

For the team behind MotherDuck

Our agent didn't reach Pay. Prove MotherDuck is yours, then see where each issue is, read your safety findings and ask for a free drive after a fix. How to fix each one comes with the Audit.

5 things to fix for agents

Agent blockers: 1 foundAgent surfaces: 2 issues foundSafety review: 2 issues found

  1. FindClear
  2. Get inClear
  3. UseClear
  4. PayNot reached
  5. LeaveClear

Claim MotherDuck, freeWhat a drive covers

On our standard

29 criteria: against other data warehouses products where we measured 5 or more, otherwise against every product we measured.

All 29 criteria
How each criterion is graded

Where MotherDuck fits

Category
Tasks
Wall
Standards
Steps
Rivals

Every earlier drive is in the history. Data under CC BY 4.0.

JSONMarkdownAtomJSON Feed

Found an error? or read how corrections work.

Questions people ask about MotherDuck

Can an AI agent sign up for MotherDuck on its own?
Our agent got into MotherDuck without signing up. Its way in: Try first, claim later, in 2 min. Not needed on the main way: the documented CLI command motherduck new made an unclaimed Free Plan organization and token in 3 s with no form, email or browser; a person must claim it within 72 h to keep it. The web sign-up (email + password on auth.motherduck.com, no CAPTCHA) also worked in the browser; it asked for a name, a team name and a region; our agent answered.
Does MotherDuck have an MCP server, and can an agent connect to it?
Yes. MotherDuck has an official MCP server. The server is hosted and lists 47 tools. A new agent can get in on its own: in the drive of 26 Oct 2026, our agent got its key without signing up, and without a person. Through the MCP server, 24 of our agent's 25 attempts worked.
How does an AI agent get a MotherDuck API key?
In the drive of 26 Oct 2026, our agent got its MotherDuck API key over the API, without a browser or a person. motherduck new saves a read/write token to credentials.json.
Can an AI agent delete its MotherDuck account?
Yes, over the API, without a browser. REST answered 404 at once; MCP and CLI refused the token from about 5 minutes later. The sign-in identity at auth.motherduck.com remains and only offers to create a new account.
Can an AI agent pay for MotherDuck?
No payment made: its robots.txt closes the payment page. No card needed to start.

Cite this page

The page as a reference, in plain text, APA and BibTeX.

Cite this
Plain
AgentDrives, “MotherDuck: AI agent test drive”, 26 October 2026, https://agentdrives.com/tools/motherduck. CC BY 4.0.
APA
AgentDrives. (2026, October 26). MotherDuck: AI agent test drive. https://agentdrives.com/tools/motherduck
BibTeX
@misc{agentdrives_motherduck_2026,
  author = {{AgentDrives}},
  title = {MotherDuck: AI agent test drive},
  year = {2026},
  month = oct,
  url = {https://agentdrives.com/tools/motherduck},
  note = {Agent test drive, CC BY 4.0},
}

Something wrong on this page?

Tell us what's wrong. We check it against the drive and correct the page, with the date.