We and selected third parties use cookies or similar technologies for technical purposes and, with your consent, to analyze how the site is used.

You can freely give, refuse or withdraw your consent at any time.

MotherDuck

MCP server by MotherDuck

Query, explore and manage MotherDuck cloud databases with DuckDB SQL from your AI assistant.

OAuth sign-in (You sign in with the vendor the first time you connect)Streamable HTTP

Connect to MotherDuck

MotherDuck needs sign-in. Connect with its own URL:

https://api.motherduck.com/mcp

Your client opens MotherDuck’s sign-in the first time you use it. The token stays between your client and MotherDuck.

Share this server

Opens this page, with the URL and setup steps.

mcp.tc/i/motherduck

About

Connects an assistant to MotherDuck, the cloud service built on DuckDB. It can run SQL queries, list databases, tables and views, and inspect column definitions so answers come from your real data.

The hosted endpoint at https://api.motherduck.com/mcp uses streamable HTTP and OAuth sign-in with a MotherDuck account. A local alternative, the mcp-server-motherduck package, runs with uvx and can also open in-memory DuckDB, local DuckDB files and S3-hosted databases. It is read-only by default, and a MotherDuck token is needed to reach MotherDuck from it.

What you can do

  • Run SQL queries against MotherDuck and DuckDB databases
  • List available databases
  • List tables and views in a database
  • Inspect columns of a table or view
  • Switch between database connections in the local server when enabled

Tools 5

  • execute_query

    Run a SQL query; unqualified table names resolve automatically.

  • list_databases

    List all databases, useful with multiple attached DuckDB databases or MotherDuck.

  • list_tables

    List all tables and views, defaulting to the current database.

  • list_columns

    List all columns of a table or view in the current database or schema.

  • switch_database_connection

    Switch to a different database connection; needs the --allow-switch-databases flag.

From the package’s own manifest, not a live connection, on 17 Nov 2026.

Example prompts

  • List the databases in my MotherDuck account.

  • Show the columns of the orders table and summarize its structure.

  • Run a SQL query for monthly revenue by region from my sales database.

  • Which tables in my analytics database contain a user_id column?

Set up

Every client connects to api.motherduck.com, and MotherDuck asks you to sign in the first time. Pick yours; the page remembers your choice.

Claude Code

  1. Run this in a terminal, in your project folder:
claude mcp add --transport http motherduck https://api.motherduck.com/mcp
  1. Start Claude Code, type /mcp, pick motherduck and choose Authenticate. A browser window opens for the MotherDuck sign-in.

Add --scope user to make it available in every project, not just this one.

Claude Desktop

  1. Open Customize → Connectors, click + Add, then Add custom connector.
  2. Name it MotherDuck and paste this URL:
https://api.motherduck.com/mcp
  1. Click Add, then Connect, and sign in when MotherDuck asks.

Claude Desktop’s JSON config file only starts local servers. Remote servers go through Connectors, and connectors you add on claude.ai show up here too.

claude.ai

  1. Open the connector form on claude.ai. This button fills in the name and URL for you:
  1. Check that the URL reads https://api.motherduck.com/mcp and click Add.
  2. Click Connect and sign in when MotherDuck asks.

Free plans allow one custom connector. On Team and Enterprise plans an owner adds it under Organization settings → Connectors.

ChatGPT

  1. On chatgpt.com, go to Plugins, select +, then Add custom MCP server.
  2. Enter a name for the server.
  3. Under Connection, paste https://api.motherduck.com/mcp as the server URL, then for authentication choose OAuth. ChatGPT sends you to MotherDuck to sign in.
  4. Check I understand and want to continue, then select Create as a plugin.

Whether you can add a custom MCP server depends on your ChatGPT plan and your workspace permissions (in Business workspaces, admins and owners can).

Cursor

Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):

mcp.json
{
  "mcpServers": {
    "motherduck": {
      "url": "https://api.motherduck.com/mcp"
    }
  }
}

Cursor shows Needs authentication next to the server. Click the button beside it to sign in.

VS Code

Or from a terminal:

code --add-mcp '{"name":"motherduck","type":"http","url":"https://api.motherduck.com/mcp"}'

Or commit it to the repo in .vscode/mcp.json:

.vscode/mcp.json
{
  "servers": {
    "motherduck": {
      "type": "http",
      "url": "https://api.motherduck.com/mcp"
    }
  }
}

VS Code asks you to sign in the first time the server starts.

Devin Desktop

  1. Add it to ~/.config/devin/mcp_config.json (macOS and Linux) or %APPDATA%\devin\mcp_config.json (Windows):
mcp_config.json
{
  "mcpServers": {
    "motherduck": {
      "serverUrl": "https://api.motherduck.com/mcp"
    }
  }
}
  1. Refresh the MCP server list in Cascade and sign in when asked.

Devin Desktop is the new name for Windsurf. It reads serverUrl (or url) for remote servers.

Codex

codex mcp add motherduck --url https://api.motherduck.com/mcp
codex mcp login motherduck

Or edit ~/.codex/config.toml directly:

config.toml
[mcp_servers.motherduck]
url = "https://api.motherduck.com/mcp"

Gemini CLI

gemini mcp add --transport http motherduck https://api.motherduck.com/mcp

Then, inside Gemini CLI, run /mcp auth motherduck to sign in.

This adds it to the current project. Add -s user to use it everywhere.

Any client

Most clients accept this shape. Some name the URL field differently: serverUrl in Devin Desktop, httpUrl in Gemini CLI’s settings file.

{
  "mcpServers": {
    "motherduck": {
      "type": "http",
      "url": "https://api.motherduck.com/mcp"
    }
  }
}

Zed puts servers under context_servers in its settings. Cline needs "type": "streamableHttp", or it assumes SSE.

Client only starts local servers? Bridge it with npx -y mcp-remote https://api.motherduck.com/mcp.

Embed

Show MotherDuck in a README or on your site. Each embed links to this page, uses the server’s own URL, and sets no cookies. How embeds work

The card, the iframe and the JSON are in English. Add ?lang=it, fr, de or es to their address for another language.

README badge

Badge preview, lightBadge preview, dark
Markdown
[![MotherDuck on mcp.tc](https://mcp.tc/i/motherduck/badge.svg)](https://mcp.tc/i/motherduck)
HTML
<a href="https://mcp.tc/i/motherduck"><img src="https://mcp.tc/i/motherduck/badge.svg" alt="MotherDuck on mcp.tc" height="20"></a>

It follows the reader’s light or dark mode. Add ?theme=light or ?theme=dark to fix it, or ?style=compact to show the mark without the word.

Website card

HTML
<script src="https://mcp.tc/w/motherduck.js" async></script>

The card appears where the tag is. Add data-theme="dark" or data-size="compact" to the tag to change it. The file holds everything it needs, so it makes no other requests and sets no cookies.

iframe

HTML
<iframe src="https://mcp.tc/embed/motherduck" title="MotherDuck on mcp.tc" width="420" height="200" loading="lazy" allow="clipboard-write" style="border:0;border-radius:8px;max-width:100%"></iframe>

Use it on pages that don’t allow scripts. Add ?theme=light or ?theme=dark to the address to fix the colors.

JSON

The listing as data for your own pages and tools: name, tagline, the server’s own URL, tools and the “Add to” links. Any site can read it (CORS is open).

https://mcp.tc/i/motherduck.json

What each field means

AI prompt

Paste this into an AI coding assistant, such as Claude Code or Cursor, and it adds the MotherDuck card to your site.

Markdown
Add the mcp.tc card for MotherDuck, an MCP server, to my website. It is one static script: no build step, no package to install, no cookies.

Put this tag where the card should appear. The card renders right before it:

```html
<script src="https://mcp.tc/w/motherduck.js" async></script>
```

To show the card somewhere else, put this placeholder there and load the same script once, for example before `</body>`. Keep the link inside: visitors without JavaScript see it.

```html
<div data-mcptc="motherduck"><a href="https://mcp.tc/i/motherduck">MotherDuck on mcp.tc</a></div>
```

Options:
- `data-theme="light"` or `"dark"` on the tag or the placeholder fixes the colors. Without it, the card follows the visitor’s light or dark mode.
- `data-size="compact"` gives a smaller card without the tagline.
- The CSS variable `--mcptc-max-width` on the placeholder or a parent sets the width (default `520px`).
- `?lang=` on the script URL sets the card’s language: `en`, `it`, `fr`, `de` or `es`.

If the site has a Content Security Policy, allow `script-src https://mcp.tc` and `img-src data:` (the icon is inline).

For a README or other Markdown docs, use the badge instead:

```markdown
[![MotherDuck on mcp.tc](https://mcp.tc/i/motherduck/badge.svg)](https://mcp.tc/i/motherduck)
```

Reference: https://mcp.tc/embed

Change history

We read the tool list in this server’s bundle manifest on GitHub every 3 hours and record what changes. Last read 18 Nov 2026, 05:31 UTC.

Follow MotherDuck and we’ll email you when something changes.

  1. , Automatic check

    Tracking started: 5 tools.

FAQ

Can I paste mcp.tc/i/motherduck into my MCP client?

No. mcp.tc links are pages, not server addresses. Connect with https://api.motherduck.com/mcp, so your client talks to MotherDuck directly. The sign-in token only works there anyway. The quick link is for sharing: it opens this page, with setup steps for every client.

Does MotherDuck need an API key or a sign-in?

Yes, you need a MotherDuck account. The first time your client connects, it opens MotherDuck’s sign-in page. The token goes straight to the server’s own URL, never through mcp.tc.

Is MotherDuck a remote or a local server?

Remote. MotherDuck hosts it at https://api.motherduck.com/mcp, and it speaks Streamable HTTP. There’s nothing to install.

What can MotherDuck do?

It has 5 tools, including execute_query, list_databases and list_tables. You can run SQL queries against MotherDuck and DuckDB databases, list available databases and list tables and views in a database.

Which clients can use it?

Any client that supports remote MCP servers: Claude Code, Claude Desktop, claude.ai, ChatGPT, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. The setup steps cover each one.

Does mcp.tc track changes to MotherDuck?

Yes. We follow the tool list in MotherDuck’s bundle manifest, and its History tab shows each change we find, plus new versions and edits by its owner. Follow the listing to get an email when it changes.

Who wrote this page?

mcp.tc’s robot read MotherDuck’s own metadata (its MCP handshake, tool list and public pages), and an AI model drafted the text from it. A person reviews anything the checks can’t confirm. The text can still be wrong, so if you spot a mistake, use Report this listing on this page.

mcp.tc isn’t affiliated with MotherDuck. This page was built from MotherDuck’s public metadata, last checked on 17 Nov 2026, and an AI model wrote the description, so it can be wrong. Names and marks belong to their owners. Something off? Report this listing.