scroll-world
A skill that turn any brand into a scrollable 3D world landing page
SQL analytics and data engineering for AI Assistants and IDEs
Skills that teach the AI this kind of work; they work alongside this one
A skill that turn any brand into a scrollable 3D world landing page
Lists are ordered by a usage score (out of 100) built from these parts
| Popularity | 44/80 | GitHub stars or weekly downloads: the larger counts 60, the smaller 20 |
|---|---|---|
| Freshness | 12/12 | Full marks for a release or code change within 30 days |
| Still answering | 0/8 | The cloud endpoint answered at the last check |
| Usage score | 56/100 |
Quality: Passed 3/3 basic checks (shown, not used for ordering) · Momentum: 44 (Used only on the Trending tab)
Pick the AI app you use, then copy the settings.
Let your AI install it with one sentence
Please install MCP Server Motherduck. Follow https://mcp.popnx.com/i/motherduckdb-mcp-server-motherduck.md, show me the commands and wait for my OK before running them.Paste it into an AI that can work on your computer (such as Claude Code or Cursor). It reads our steps, shows you the commands and waits for your OK. No key, no sign-up. · See the full text your AI reads
Passed 3/3 checks · Runs on your computer · ✓ Commands checked Nov 14, 2026
First: which AI do you use?
Pick your app and the steps appear below.
Copy this message into a Claude chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server MCP Server Motherduck for Claude on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "motherduck": { "command": "uvx", "args": [ "mcp-server-motherduck", "--transport", "stdio", "--port", "8000", "--host", "127.0.0.1", "--db-path", ":memory:", "--max-rows", "1024", "--max-chars", "50000", "--query-timeout", "-1" ], "env": { "motherduck_token": "your-value", "MOTHERDUCK_TOKEN": "your-value", "AWS_ACCESS_KEY_ID": "your-value", "AWS_SECRET_ACCESS_KEY": "your-value", "AWS_SESSION_TOKEN": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For motherduck_token, MOTHERDUCK_TOKEN, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the MCP Server Motherduck tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
SettingsDeveloperEdit Config
{
"mcpServers": {
"motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck",
"--transport",
"stdio",
"--port",
"8000",
"--host",
"127.0.0.1",
"--db-path",
":memory:",
"--max-rows",
"1024",
"--max-chars",
"50000",
"--query-timeout",
"-1"
],
"env": {
"motherduck_token": "your-value",
"MOTHERDUCK_TOKEN": "your-value",
"AWS_ACCESS_KEY_ID": "your-value",
"AWS_SECRET_ACCESS_KEY": "your-value",
"AWS_SESSION_TOKEN": "your-value"
}
}
}
}Paste the key only into the app’s field, never into a chat or to anyone
Use MCP Server Motherduck and tell me what you can do for me, then show me one thing✓ If Claude says it is using MCP Server Motherduck or shows a MCP Server Motherduck tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
HOME Used by DuckDB for extensions and config. Override with --home-dir if not set.AWS_DEFAULT_REGION AWS region for S3 database connectionsAWS_ENDPOINT AWS endpoint for S3 database connectionsDescriptions are as written by the maker.
Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version
ChatGPT cannot connect MCP Server Motherduck yet
MCP Server Motherduck runs on your computer, but ChatGPT can only connect servers that run on the web
A · Use an app that can connect MCP Server Motherduck
B · Others in Marketing & social media that work with ChatGPT
Picked from the most used in the same category, only ones that connect by address with no key
Works with Claude Code, with some setup first
You need a MCP Server Motherduck key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)
Copy this message into a Claude Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server MCP Server Motherduck for Claude Code on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): claude mcp add --scope user motherduck --env motherduck_token=your-value --env MOTHERDUCK_TOKEN=your-value --env AWS_ACCESS_KEY_ID=your-value --env AWS_SECRET_ACCESS_KEY=your-value --env AWS_SESSION_TOKEN=your-value -- uvx mcp-server-motherduck --transport stdio --port 8000 --host 127.0.0.1 --db-path :memory: --max-rows 1024 --max-chars 50000 --query-timeout -1 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For motherduck_token, MOTHERDUCK_TOKEN, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the MCP Server Motherduck tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
Mac: press Command+Space and type Terminal · Windows: open PowerShell
claude mcp add --scope user motherduck --env motherduck_token=your-value --env MOTHERDUCK_TOKEN=your-value --env AWS_ACCESS_KEY_ID=your-value --env AWS_SECRET_ACCESS_KEY=your-value --env AWS_SESSION_TOKEN=your-value -- uvx mcp-server-motherduck --transport stdio --port 8000 --host 127.0.0.1 --db-path :memory: --max-rows 1024 --max-chars 50000 --query-timeout -1Replace “your-value” with your key before pressing Enter
Paste the key only into the app’s field, never into a chat or to anyone
You should see MCP Server Motherduck listed as connected
Use MCP Server Motherduck and tell me what you can do for me, then show me one thing✓ If Claude Code says it is using MCP Server Motherduck or shows a MCP Server Motherduck tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
HOME Used by DuckDB for extensions and config. Override with --home-dir if not set.AWS_DEFAULT_REGION AWS region for S3 database connectionsAWS_ENDPOINT AWS endpoint for S3 database connectionsDescriptions are as written by the maker.
Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version
Works with Cursor, with some setup first
You need a MCP Server Motherduck key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)
Copy this message into a Cursor chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server MCP Server Motherduck for Cursor on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "motherduck": { "command": "uvx", "args": [ "mcp-server-motherduck", "--transport", "stdio", "--port", "8000", "--host", "127.0.0.1", "--db-path", ":memory:", "--max-rows", "1024", "--max-chars", "50000", "--query-timeout", "-1" ], "env": { "motherduck_token": "your-value", "MOTHERDUCK_TOKEN": "your-value", "AWS_ACCESS_KEY_ID": "your-value", "AWS_SECRET_ACCESS_KEY": "your-value", "AWS_SESSION_TOKEN": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For motherduck_token, MOTHERDUCK_TOKEN, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the MCP Server Motherduck tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
In the MCP Server Motherduck settings, motherduck_token, MOTHERDUCK_TOKEN, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN is empty; add your key and save
Paste the key only into the app’s field, never into a chat or to anyone
Use MCP Server Motherduck and tell me what you can do for me, then show me one thing✓ If Cursor says it is using MCP Server Motherduck or shows a MCP Server Motherduck tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
HOME Used by DuckDB for extensions and config. Override with --home-dir if not set.AWS_DEFAULT_REGION AWS region for S3 database connectionsAWS_ENDPOINT AWS endpoint for S3 database connectionsDescriptions are as written by the maker.
Menu names checked against Cursor’s help page on Nov 11, 2026 · your screen may differ slightly by app version
Works with VS Code, with some setup first
You need a MCP Server Motherduck key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)
Copy this message into a VS Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server MCP Server Motherduck for VS Code on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "servers": { "motherduck": { "type": "stdio", "command": "uvx", "args": [ "mcp-server-motherduck", "--transport", "stdio", "--port", "8000", "--host", "127.0.0.1", "--db-path", ":memory:", "--max-rows", "1024", "--max-chars", "50000", "--query-timeout", "-1" ], "env": { "motherduck_token": "your-value", "MOTHERDUCK_TOKEN": "your-value", "AWS_ACCESS_KEY_ID": "your-value", "AWS_SECRET_ACCESS_KEY": "your-value", "AWS_SESSION_TOKEN": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For motherduck_token, MOTHERDUCK_TOKEN, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the MCP Server Motherduck tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
In the MCP Server Motherduck settings, motherduck_token, MOTHERDUCK_TOKEN, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN is empty; add your key and save
Paste the key only into the app’s field, never into a chat or to anyone
Use MCP Server Motherduck and tell me what you can do for me, then show me one thing✓ If VS Code says it is using MCP Server Motherduck or shows a MCP Server Motherduck tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
HOME Used by DuckDB for extensions and config. Override with --home-dir if not set.AWS_DEFAULT_REGION AWS region for S3 database connectionsAWS_ENDPOINT AWS endpoint for S3 database connectionsDescriptions are as written by the maker.
Menu names checked against VS Code’s help page on Nov 11, 2026 · your screen may differ slightly by app version
Other apps that use MCP, such as Windsurf, Zed or Gemini CLI, each add servers differently. See how in the app list.
JSON settings are under “For developers” below
Claude Code
claude mcp add --scope user motherduck --env motherduck_token=your-value --env MOTHERDUCK_TOKEN=your-value --env AWS_ACCESS_KEY_ID=your-value --env AWS_SECRET_ACCESS_KEY=your-value --env AWS_SESSION_TOKEN=your-value -- uvx mcp-server-motherduck --transport stdio --port 8000 --host 127.0.0.1 --db-path :memory: --max-rows 1024 --max-chars 50000 --query-timeout -1Claude Desktop (claude_desktop_config.json)
{
"mcpServers": {
"motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck",
"--transport",
"stdio",
"--port",
"8000",
"--host",
"127.0.0.1",
"--db-path",
":memory:",
"--max-rows",
"1024",
"--max-chars",
"50000",
"--query-timeout",
"-1"
],
"env": {
"motherduck_token": "your-value",
"MOTHERDUCK_TOKEN": "your-value",
"AWS_ACCESS_KEY_ID": "your-value",
"AWS_SECRET_ACCESS_KEY": "your-value",
"AWS_SESSION_TOKEN": "your-value"
}
}
}
}Cursor (~/.cursor/mcp.json)
{
"mcpServers": {
"motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck",
"--transport",
"stdio",
"--port",
"8000",
"--host",
"127.0.0.1",
"--db-path",
":memory:",
"--max-rows",
"1024",
"--max-chars",
"50000",
"--query-timeout",
"-1"
],
"env": {
"motherduck_token": "your-value",
"MOTHERDUCK_TOKEN": "your-value",
"AWS_ACCESS_KEY_ID": "your-value",
"AWS_SECRET_ACCESS_KEY": "your-value",
"AWS_SESSION_TOKEN": "your-value"
}
}
}
}VS Code (mcp.json)
{
"servers": {
"motherduck": {
"type": "stdio",
"command": "uvx",
"args": [
"mcp-server-motherduck",
"--transport",
"stdio",
"--port",
"8000",
"--host",
"127.0.0.1",
"--db-path",
":memory:",
"--max-rows",
"1024",
"--max-chars",
"50000",
"--query-timeout",
"-1"
],
"env": {
"motherduck_token": "your-value",
"MOTHERDUCK_TOKEN": "your-value",
"AWS_ACCESS_KEY_ID": "your-value",
"AWS_SECRET_ACCESS_KEY": "your-value",
"AWS_SESSION_TOKEN": "your-value"
}
}
}
}motherduck_token secret required envMOTHERDUCK_TOKEN secret required envHOME envAWS_ACCESS_KEY_ID secret required envAWS_SECRET_ACCESS_KEY secret required envAWS_SESSION_TOKEN secret required envAWS_DEFAULT_REGION envAWS_ENDPOINT envDescriptions are as written by the maker.
These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.
Based on how this server connects and on each app’s own docs, checked Nov 10, 2026.
Run on your computer in
ClaudeGooseLM StudioMsty StudioCherry StudioCursorVS Code + GitHub CopilotVisual StudioWindsurf (Devin Desktop)ZedKiroClineContinueJetBrains AI AssistantClaude CodeCodex CLIGemini CLIOpenCodenodecodeWarpLibreChatRaycast
Runs on your computer; the tool list appears in your AI app after you install it.
We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 20, 2026
The registry name was verified with the GitHub account motherduckdb, which owns the repo
Code last changed 6 days ago
Uses MIT
This one runs on your computer; there is no internet endpoint
Runs on your computer and uses local settings instead
Runs on your computer; we can only read tool lists from internet endpoints
No entries on OSV.dev for mcp-server-motherduck@1.1.1
Checks only this package version, not every dependency · checked Nov 15, 2026
If you made this, paste this code into your README. The badge links back to this page.
[](https://mcp.popnx.com/en/servers/motherduckdb-mcp-server-motherduck)Ask, share a tip or report that it does not work. Sorted by what people marked helpful.
No posts yet. Be the first to ask or share.
Posts here are written by users, not the PopNx team.
No reviews yet
Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.
It passed 3 of 3 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.
You need to fill in: motherduck_token, MOTHERDUCK_TOKEN, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN
It runs on your computer. Your AI app starts it when needed, and data does not pass through the maker’s servers (unless it calls an online service itself).
The GitHub repo last changed 6 days ago, and the latest version (1.1.1) reached the registry 8 days ago.
Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Python (uv) on your computer.
In the same category: Relaticle, ChatbotX, X (Twitter) MCP Server by Xquik, Betterlytics, BibiGPT YouTube Video Summarizer
Same category, other makers, commands already checked. Official ones first, then by stars.
Reading a card:↓ Downloads per weeki★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi
Open-source CRM your AI agents can write to: companies, people, opportunities, tasks and notes.
Omnichannel customer messaging, CRM contacts, flows, sequences, broadcasts, and AI automation.
Xquik is the world's fastest and cheapest X (Twitter) data API with the most complete X data.
Query your Betterlytics web analytics from AI agents: traffic, funnels, journeys, errors, uptime.
AI video summarizer: summarize and transcribe YouTube, Bilibili, TikTok and podcast videos.
| This one MCP Server Motherduck | Relaticle | ChatbotX | X (Twitter) MCP Server by Xquik | Betterlytics | BibiGPT YouTube Video Summarizer | |
|---|---|---|---|---|---|---|
| Runs where | Installs on your computer | Runs in the cloud, nothing to install | Runs in the cloud, nothing to install | Runs in the cloud, nothing to install | Runs in the cloud, nothing to install | Runs in the cloud, nothing to install |
| Needs a key | Yes | No | No | No | Yes | No |
| Add with + in Claude | No | No | No | No | No | No |
| Basic checks | 3/3 | 4/4 | 4/4 | 4/4 | 4/4 | 4/4 |
| License | MIT | AGPL-3.0 | NOASSERTION | MIT | AGPL-3.0 | MIT |
| Price | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry |
Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.
DuckDB / MotherDuck Local MCP Server
SQL analytics and data engineering for AI Assistants and IDEs.
Connect AI assistants to your data using DuckDB's powerful analytical SQL engine. Supports connecting to local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck. Allows executing SQL read- and write-queries, browsing database catalogs, and switching between different database connections on-the-fly.
Looking for a fully-managed remote MCP server for MotherDuck? → Go to the MotherDuck Remote MCP docs
| [Remote MCP](https://motherduck.com/docs/sql-reference/mcp/) | Local MCP (this repo) | |
|---|---|---|
| Hosting | Hosted by MotherDuck | Runs locally/self-hosted |
| Setup | Zero-setup | Requires local installation |
| Access | Read-write supported | Read-write supported |
| Local filesystem | - | Query across local and remote databases, ingest data from / export data to local filesystem |
Prerequisites: Install uv via pip install uv or brew install uv
{
"mcpServers": { "DuckDB (in-memory, r/w)": { "command": "uvx", "args": ["mcp-server-motherduck", "--db-path", ":memory:", "--read-write", "--allow-switch-databases"] } } }
Full flexibility with no guardrails — read-write access and the ability to switch to any database (local files, S3, or MotherDuck) at runtime.
{
"mcpServers": { "DuckDB (read-only)": { "command": "uvx", "args": ["mcp-server-motherduck", "--db-path", "/absolute/path/to/your.duckdb"] } } }
Connects to a specific DuckDB file in read-only mode. Won't hold on to the file lock, so convenient to use alongside a write connection to the same DuckDB file. You can also connect to remote DuckDB files on S3 using s3://bucket/path.duckdb — see Environment Variables for S3 authentication. If you're considering third-party access to the MCP, see Securing for Production.
{
"mcpServers": { "MotherDuck (local, r/w)": { "command": "uvx", "args": ["mcp-server-motherduck", "--db-path", "md:", "--read-write"], "env": { "motherduck_token": " " } } } }
See Command Line Parameters for more options, Securing for Production for deployment guidance, and Troubleshooting if you encounter issues.
| Client | Config Location | One-Click Install |
|---|---|---|
| Claude Desktop | Settings → Developer → Edit Config | .mcpb (MCP Bundle) |
| Claude Code | Use CLI commands below | - |
| Codex CLI | Use CLI commands below or ~/.codex/config.toml | - |
| Gemini CLI | Use CLI commands below or ~/.gemini/settings.json | - |
| Cursor | Settings → MCP → Add new global MCP server | |
| VS Code | Ctrl+Shift+P → "Preferences: Open User Settings (JSON)" | |
| Kiro | ~/.kiro/settings/mcp.json (global) or .kiro/settings/mcp.json (project) |
Any MCP-compatible client can use this server. Add the JSON configuration from Quick Start to your client's MCP config file. Consult your client's documentation for the config file location.
Claude Code CLI commands
In-Memory DuckDB (Dev Mode):
claude mcp add --scope user duckdb --transport stdio -- uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases
Local DuckDB (Read-Only):
claude mcp add --scope user duckdb --transport stdio -- uvx mcp-server-motherduck --db-path /absolute/path/to/db.duckdb
MotherDuck (Read-Write):
claude mcp add --scope user motherduck --transport stdio --env motherduck_token=YOUR_TOKEN -- uvx mcp-server-motherduck --db-path md: --read-write
Codex CLI commands
In-Memory DuckDB (Dev Mode):
codex mcp add duckdb -- uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases
Local DuckDB (Read-Only):
codex mcp add duckdb -- uvx mcp-server-motherduck --db-path /absolute/path/to/db.duckdb
MotherDuck (Read-Write):
codex mcp add motherduck --env motherduck_token=YOUR_TOKEN -- uvx mcp-server-motherduck --db-path md: --read-write
Gemini CLI commands
In-Memory DuckDB (Dev Mode):
gemini mcp add -s user duckdb uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases
Local DuckDB (Read-Only):
gemini mcp add -s user duckdb uvx mcp-server-motherduck --db-path /absolute/path/to/db.duckdb
MotherDuck (Read-Write):
gemini mcp add -s user -e motherduck_token=YOUR_TOKEN motherduck uvx mcp-server-motherduck --db-path md: --read-write
Kiro manual JSON config
Add the following to your Kiro MCP config file (~/.kiro/settings/mcp.json for global, or .kiro/settings/mcp.json for project-scoped). See the Kiro MCP documentation for more details.
In-Memory DuckDB (Dev Mode):
{
"mcpServers": { "DuckDB (in-memory, r/w)": { "command": "uvx", "args": ["mcp-server-motherduck", "--db-path", ":memory:", "--read-write", "--allow-switch-databases"] } } }
MotherDuck (Read-Write):
{
"mcpServers": { "MotherDuck (local, r/w)": { "command": "uvx", "args": ["mcp-server-motherduck", "--db-path", "md:", "--read-write"], "env": { "motherduck_token": " " } } } }
| Tool | Description | Required Inputs | Optional Inputs |
|---|---|---|---|
execute_query | Execute SQL query (DuckDB dialect) | sql | - |
list_databases | List all databases (useful for MotherDuck or multiple attached DBs) | - | - |
list_tables | List tables and views | - | database, schema |
list_columns | List columns of a table/view | table | database, schema |
switch_database_connection* | Switch to different database | path | create_if_not_exists |
*Requires --allow-switch-databases flag
All tools return JSON. Results are limited to 1024 rows / 50,000 chars by default (configurable via --max-rows, --max-chars).
When giving third parties access to a self-hosted MCP server, read-only mode alone is not sufficient — it still allows access to the local filesystem, changing DuckDB settings, and other potentially sensitive operations.
For production deployments with third-party access, we recommend [MotherDuck Remote MCP](https://motherduck.com/docs/sql-reference/mcp/) — zero-setup, read-write capable, and hosted by MotherDuck.
Self-hosting MotherDuck MCP: Fork this repo and customize as needed. Use a [service account](https://motherduck.com/docs/key-tasks/service-accounts-guide/) with [read-scaling tokens](https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/read-scaling/#creating-a-read-scaling-token) and enable [SaaS mode](https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck/#authentication-using-saas-mode) to restrict local file access.
Self-hosting DuckDB MCP: Use --init-sql to apply security settings. See the Securing DuckDB guide for available options.
Build and run the server with Streamable HTTP on port 8000 (defaults to an in-memory DuckDB):
docker build -t mcp-server-motherduck .
docker run --rm -p 8000:8000 mcp-server-motherduck
Connect to MotherDuck by passing a token and overriding the command:
docker run --rm -p 8000:8000 \
-e motherduck_token="$MOTHERDUCK_TOKEN" \ mcp-server-motherduck --transport http --db-path md:
The MCP endpoint is available at http://localhost:8000/mcp. CLI flags and env vars from below still apply.
| Parameter | Default | Description |
|---|---|---|
--db-path | :memory: | Database path: local file (absolute), md: (MotherDuck), or s3:// URL |
--motherduck-token | motherduck_token env var | MotherDuck access token |
--read-write | False | Enable write access |
--motherduck-saas-mode | False | MotherDuck SaaS mode (restricts local access) |
--allow-switch-databases | False | Enable switch_database_connection tool |
--max-rows | 1024 | Max rows returned |
--max-chars | 50000 | Max characters returned |
--query-timeout | -1 | Query timeout in seconds (-1 = disabled) |
--init-sql | None | SQL to execute on startup |
| --motherduck-connection-parameters | session_hint=mcp& dbinstance_inactivity_ttl=0s | Additional MotherDuck connection string parameters (key=value pairs separated by &) | | --ephemeral-connections | True | Use temporary connections for read-only local files | | --transport | stdio | Transport type: stdio or http | | --stateless-http | False | For protocol compatibility only (e.g. with AWS Bedrock AgentCore Runtime). Server still maintains global state via the shared DatabaseClient. | | --port | 8000 | Port for HTTP transport | | --host | 127.0.0.1 | Host for HTTP transport |
| Variable | Description |
|---|---|
motherduck_token or MOTHERDUCK_TOKEN | MotherDuck access token (alternative to --motherduck-token) |
HOME | Used by DuckDB for extensions and config. Override with --home-dir if not set. |
AWS_ACCESS_KEY_ID | AWS access key for S3 database connections |
AWS_SECRET_ACCESS_KEY | AWS secret key for S3 database connections |
AWS_SESSION_TOKEN | AWS session token for temporary credentials (IAM roles, SSO, EC2 instance profiles) |
AWS_DEFAULT_REGION | AWS region for S3 connections |
AWS_ENDPOINT | AWS endpoint for S3 connections |
uvx (run which uvx to find it)--ephemeral-connections is turned on (default: true) an