MotherDuck MCP Server

✓ verified

Run DuckDB and MotherDuck SQL analytics from the assistant.

Don't have ToolPiper? We'll take you to the download.

Open repository →

Publisher

MotherDuck

License

MIT

Transport

Local subprocess

Tools

1

What this server does

DuckDB is a fast analytical SQL engine; MotherDuck is its cloud. This server points the assistant at either one. With md: as the database path and a MotherDuck token it queries your cloud warehouse; swap in a local .duckdb file or a path and it runs entirely on disk. DuckDB reads Parquet, CSV, and JSON directly, so you can ask questions about files without loading them first. One tool, query, runs any DuckDB SQL the assistant writes.

Tools included

  • query

    Run a DuckDB SQL query against MotherDuck or a local database.

The authoritative list comes from the server's tools/list at runtime. This catalog entry may lag the upstream until the next ToolPiper release.

Install in ToolPiper

ToolPiper handles the JSON configuration. Click Install, fill in any required tokens, and the server is ready in your chat.

Don't have ToolPiper? We'll take you to the download.

Install in another client

Install in another MCP client (Claude Desktop, Cursor, Continue, Cline)

Add this to ~/Library/Application Support/Claude/claude_desktop_config.json.

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

Example prompts

  • "Query my sales database and show monthly revenue for the last year."

  • "Read this Parquet file in S3 and tell me the row count and column types."

  • "What are the top 10 products by units sold this quarter?"

Security notes

The MotherDuck token grants access to your cloud warehouse and bills against your account; treat it as a credential. The query tool runs arbitrary SQL, which on a writable database includes destructive statements. Point it at a read-only or analytics database for safety, or use a local file copy when exploring.

Related tools