Skip to content
appsgit

MCP Server Motherduck

MCP Server Motherduck is an MCP server that adds data and analytics tools to AI assistants such as Claude Desktop, Claude Code and Cursor. SQL analytics and data engineering for AI Assistants and IDEs. It has 526 GitHub stars, is released under the MIT license and runs locally with uvx mcp-server-motherduck.

github.com/motherduckdb/mcp-server-motherduck (opens in a new tab)

View on GitHub (opens in a new tab)

Install MCP Server Motherduck

Generated from the server's MCP registry entry. Replace your-value with your own values.

Claude Desktop

claude_desktop_config.json
{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ],
      "env": {
        "MOTHERDUCK_TOKEN": "your-value",
        "AWS_ACCESS_KEY_ID": "your-value",
        "AWS_SECRET_ACCESS_KEY": "your-value",
        "AWS_SESSION_TOKEN": "your-value"
      }
    }
  }
}

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

Claude Code

claude mcp add --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 --transport stdio mcp-server-motherduck -- uvx mcp-server-motherduck

Cursor

.cursor/mcp.json
{
  "mcpServers": {
    "mcp-server-motherduck": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ],
      "env": {
        "MOTHERDUCK_TOKEN": "your-value",
        "AWS_ACCESS_KEY_ID": "your-value",
        "AWS_SECRET_ACCESS_KEY": "your-value",
        "AWS_SESSION_TOKEN": "your-value"
      }
    }
  }
}

Project file; use ~/.cursor/mcp.json to enable it in every project.

VS Code

.vscode/mcp.json
{
  "inputs": [
    {
      "type": "promptString",
      "id": "motherduck_token",
      "description": "MOTHERDUCK_TOKEN",
      "password": true
    },
    {
      "type": "promptString",
      "id": "aws_access_key_id",
      "description": "AWS_ACCESS_KEY_ID",
      "password": true
    },
    {
      "type": "promptString",
      "id": "aws_secret_access_key",
      "description": "AWS_SECRET_ACCESS_KEY",
      "password": true
    },
    {
      "type": "promptString",
      "id": "aws_session_token",
      "description": "AWS_SESSION_TOKEN",
      "password": true
    }
  ],
  "servers": {
    "mcp-server-motherduck": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ],
      "env": {
        "MOTHERDUCK_TOKEN": "${input:motherduck_token}",
        "AWS_ACCESS_KEY_ID": "${input:aws_access_key_id}",
        "AWS_SECRET_ACCESS_KEY": "${input:aws_secret_access_key}",
        "AWS_SESSION_TOKEN": "${input:aws_session_token}"
      }
    }
  }
}

Config formats checked against the official docs on Oct 7, 2026: modelcontextprotocol.io (opens in a new tab), code.claude.com (opens in a new tab), cursor.com (opens in a new tab), code.visualstudio.com (opens in a new tab).

Environment variables

Variables the server reads at startup.

NameRequiredDescription
MOTHERDUCK_TOKENsecretNoAccess token for MotherDuck connections (alternative to --motherduck-token)
HOMENoUsed by DuckDB for extensions and config. Override with --home-dir if not set.
AWS_ACCESS_KEY_IDsecretNoAWS access key for S3 database connections
AWS_SECRET_ACCESS_KEYsecretNoAWS secret access key for S3 database connections
AWS_SESSION_TOKENsecretNoAWS session token for temporary credentials
AWS_DEFAULT_REGIONNoAWS region for S3 database connections
AWS_ENDPOINTNoAWS endpoint for S3 database connections

Tools (4)

Parsed from the Tools section of the README; check the repository for the current list.

  • execute_query

    Execute SQL query (DuckDB dialect)

  • list_databases

    List all databases (useful for MotherDuck or multiple attached DBs)

  • list_tables

    List tables and views

  • list_columns

    List columns of a table/view

About MCP Server Motherduck

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.

  • ai
  • duckdb
  • motherduck

Similar MCP servers

More data & analytics MCP servers

All Data & analytics

FAQ

MCP Server Motherduck FAQ

Still curious? Email info@appsgit.com.

What is MCP Server Motherduck?

MCP Server Motherduck is an MCP server that adds data and analytics tools to AI assistants such as Claude Desktop, Claude Code and Cursor. SQL analytics and data engineering for AI Assistants and IDEs. It has 526 GitHub stars, is released under the MIT license and runs locally with uvx mcp-server-motherduck. The source code is at github.com/motherduckdb/mcp-server-motherduck.

How do I install the MCP Server Motherduck MCP server?

Add the command uvx mcp-server-motherduck to your MCP client: put it in claude_desktop_config.json for Claude Desktop, run claude mcp add for Claude Code, or add it to .cursor/mcp.json (Cursor) or .vscode/mcp.json (VS Code). The snippets on this page are ready to paste.

Is MCP Server Motherduck free?

The server is open source under the MIT license, so running it is free. It needs credentials (MOTHERDUCK_TOKEN, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY and AWS_SESSION_TOKEN) for the service it connects to, which may require a paid account.

Is MCP Server Motherduck actively maintained?

The most recent commit was on Aug 19, 2026. The latest release is v1.0.8, published Aug 19, 2026. appsgit only lists MCP servers with a commit in the last six months and re-checks every server daily.