---
title: "MotherDuck MCP Server for ToolPiper · ModelPiper"
description: "Run DuckDB and MotherDuck SQL analytics from the assistant. 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"
canonical: "https://modelpiper.com/mcp-tools/motherduck"
---

# MotherDuck MCP Server for ToolPiper · ModelPiper

> Run DuckDB and MotherDuck SQL analytics from the assistant. 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

M

# MotherDuck MCP Server

✓ verified

Run DuckDB and MotherDuck SQL analytics from the assistant.

Install MotherDuck in ToolPiper

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

[Open repository →](https://github.com/motherduckdb/mcp-server-motherduck)

Publisher

[MotherDuck](https://github.com/motherduckdb/mcp-server-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.

Install MotherDuck in ToolPiper

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)

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:"
      ]
    }
  }
}
```

Copy

## Example prompts

-   "Query my sales database and show monthly revenue for the last year."
    
    Copy
-   "Read this Parquet file in S3 and tell me the row count and column types."
    
    Copy
-   "What are the top 10 products by units sold this quarter?"
    
    Copy

## 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

-   [
    
    P
    
    ### Postgres
    
    ✓ verified
    
    Query Postgres databases with read-only SQL.
    
    DataLocal subprocess1 tool
    
    
    
    
    
    ](/mcp-tools/postgres)
-   [
    
    S
    
    ### SQLite
    
    ✓ verified
    
    Query SQLite databases and run business-intelligence prompts.
    
    DataLocal subprocess4 tools
    
    
    
    
    
    ](/mcp-tools/sqlite)
-   [
    
    R
    
    ### Redis
    
    ✓ verified
    
    Interact with Redis key-value stores from the assistant.
    
    DataLocal subprocess4 tools
    
    
    
    
    
    ](/mcp-tools/redis)
-   [
    
    A
    
    ### AWS Knowledge Base
    
    ✓ verified
    
    Retrieve answers from an AWS Bedrock Knowledge Base.
    
    DataLocal subprocess1 tool
    
    
    
    
    
    ](/mcp-tools/aws-kb-retrieval)

[← Back to all MCP tools](/mcp-tools)