mcp-server-motherduck

Name: mcp-server-motherduck
Author: motherduckdb

Community

MCP server by motherduckdb · updated 16 days ago · ★ 532

Score 85

SQL analytics and data engineering for AI Assistants and IDEs mcp-server-motherduck is a community project by motherduckdb, not verified by a company domain.

Install Add to Cursor Add to VS Code GitHub

Yours? Claim it

Works withClaude Code Claude Desktop Cursor Codex Gemini CLI VS Code Windsurf Antigravity CLI

Install mcp-server-motherduck

Built from the published package, never by AI

claude mcp add mcp-server-motherduck -- uvx mcp-server-motherduck

Run in your terminal. Add --scope user to use it in every project.

Step-by-step: install mcp-server-motherduck in Claude Code

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ]
    }
  }
}

Settings, Developer, Edit config. Paste into claude_desktop_config.json and restart.

Step-by-step: install mcp-server-motherduck in Claude Desktop

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ]
    }
  }
}

Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project).

Step-by-step: install mcp-server-motherduck in Cursor

{
  "servers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ]
    }
  }
}

Add to .vscode/mcp.json. VS Code uses "servers", not "mcpServers".

Step-by-step: install mcp-server-motherduck in VS Code

codex mcp add mcp-server-motherduck -- uvx mcp-server-motherduck

Step-by-step: install mcp-server-motherduck in Codex

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ]
    }
  }
}

Add to ~/.gemini/config/mcp_config.json (all projects) or .agents/mcp_config.json (this project).

Step-by-step: install mcp-server-motherduck in Antigravity CLI

gemini mcp add mcp-server-motherduck uvx mcp-server-motherduck

Gemini CLI was replaced by Antigravity CLI in June 2026 and remains only for enterprise licences and paid API keys.

Step-by-step: install mcp-server-motherduck in Gemini CLI

MCP servers run with your permissions and can read what you give them access to. Some need an API key: check the README and add it under env in the mcp-server-motherduck block.

Maintenance

Last commit 16 days ago

Licence

MIT: permissive, fine for commercial use

Quality

Clear description, published package or server URL, 532 stars, original repository

Security

No risky patterns in the files we checked

What you need

Setting	Needed	What it is
`motherduck_token`Environment variable, secret	Optional	Access token for MotherDuck connections (alternative to --motherduck-token)
`MOTHERDUCK_TOKEN`Environment variable, secret	Optional	Access token for MotherDuck connections (alternative to --motherduck-token)
`HOME`Environment variable	Optional	Used by DuckDB for extensions and config. Override with --home-dir if not set.
`AWS_ACCESS_KEY_ID`Environment variable, secret	Optional	AWS access key for S3 database connections
`AWS_SECRET_ACCESS_KEY`Environment variable, secret	Optional	AWS secret access key for S3 database connections
`AWS_SESSION_TOKEN`Environment variable, secret	Optional	AWS session token for temporary credentials
`AWS_DEFAULT_REGION`Environment variable	Optional	AWS region for S3 database connections
`AWS_ENDPOINT`Environment variable	Optional	AWS endpoint for S3 database connections

From the publisher's entry in the official MCP Registry. Required settings are already in the install config below as placeholders.

Weekly newsletter

Like mcp-server-motherduck? Get the best new MCP servers every week

The best new tools, security warnings before you install something risky, and one practical tip. Free, three minute read.

Security check

No download-and-run commands, hidden instructions or signs of sending keys out were found.

Checked automatically: README.md. This looks for known risky patterns and is not a full audit. How grades work

Alternatives to mcp-server-motherduck

All alternatives →

Supabase supabase

MCP server for interacting with the Supabase platform

AAB Local and remote 68k/wk

ArcadeDB MCP Server ArcadeData

Built-in MCP server for ArcadeDB multi-model database (graph, document, vector, time-series)

AAA Local 1.2k

MCP Toolbox for Databasesgoogleapis

MCP Toolbox for Databases enables your agent to connect to your database.

AAA Local 17k

MCP Toolbox for Databasesgoogleapis

MCP Toolbox for Databases enables your agent to connect to your database.

AAA Local 17k

mcpkubeshark

Real-time Kubernetes network traffic visibility and API analysis for HTTP, gRPC, Redis, Kafka, DNS.

AAA Local 12k

Ruvector ruvnet

Self-learning vector database for Node.js — hybrid search, Graph RAG, FlashAttention-3, HNSW, 50+ attention mechanisms

AAA Local 59k/wk

mcp-server-motherduck vs Supabase mcp-server-motherduck vs ArcadeDB MCP Server mcp-server-motherduck vs MCP Toolbox for Databases

mcp-server-motherduck: common questions

How do I install mcp-server-motherduck?

In Claude Code run claude mcp add mcp-server-motherduck -- uvx mcp-server-motherduck. For Claude Desktop, Cursor and VS Code, paste the config shown above and restart. See the install guides.

Is mcp-server-motherduck the official server?

mcp-server-motherduck is a community project by motherduckdb, not verified by a company domain.

Is mcp-server-motherduck free?

The code is published under the MIT licence. The service it connects to may have its own pricing.

Is mcp-server-motherduck safe to use?

It scores 85 of 100. Grades: maintenance A, licence A, quality A. Security check: grade A, no risky patterns found in the files checked. Review the code before you install. How grades work.

What are alternatives to mcp-server-motherduck?

Does mcp-server-motherduck work with ChatGPT?

Not directly. It runs locally, and ChatGPT only connects to remote servers with a URL. Use it in Claude Code, Claude Desktop, Cursor, VS Code or Codex.