MotherDuck
MCP server by MotherDuck
Query, explore and manage MotherDuck cloud databases with DuckDB SQL from your AI assistant.
Connect to MotherDuck
MotherDuck needs sign-in. Connect with its own URL:
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/motherduckAbout
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_queryRun a SQL query; unqualified table names resolve automatically.
list_databasesList all databases, useful with multiple attached DuckDB databases or MotherDuck.
list_tablesList all tables and views, defaulting to the current database.
list_columnsList all columns of a table or view in the current database or schema.
switch_database_connectionSwitch 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
- Run this in a terminal, in your project folder:
claude mcp add --transport http motherduck https://api.motherduck.com/mcp- 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
- Open Customize → Connectors, click + Add, then Add custom connector.
- Name it MotherDuck and paste this URL:
https://api.motherduck.com/mcp- 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
- Open the connector form on claude.ai. This button fills in the name and URL for you:
Add to claude.ai (opens in a new tab)
- Check that the URL reads
https://api.motherduck.com/mcpand click Add. - 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
- On chatgpt.com, go to Plugins, select +, then Add custom MCP server.
- Enter a name for the server.
- Under Connection, paste
https://api.motherduck.com/mcpas the server URL, then for authentication choose OAuth. ChatGPT sends you to MotherDuck to sign in. - 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
Add to Cursor (opens in a new tab)
Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):
{
"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
Install in VS Code (opens in a new tab)
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:
{
"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
- Add it to
~/.config/devin/mcp_config.json(macOS and Linux) or%APPDATA%\devin\mcp_config.json(Windows):
{
"mcpServers": {
"motherduck": {
"serverUrl": "https://api.motherduck.com/mcp"
}
}
}- 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 motherduckOr edit ~/.codex/config.toml directly:
[mcp_servers.motherduck]
url = "https://api.motherduck.com/mcp"Gemini CLI
gemini mcp add --transport http motherduck https://api.motherduck.com/mcpThen, 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
[](https://mcp.tc/i/motherduck)<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
<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
<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.jsonAI prompt
Paste this into an AI coding assistant, such as Claude Code or Cursor, and it adds the MotherDuck card to your site.
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
[](https://mcp.tc/i/motherduck)
```
Reference: https://mcp.tc/embedChange 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.
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.