Skip to main content

​
Prerequisites

MCP Server MotherDuck requires Python 3.10 or higher and the uv package manager.
1

Install uv

Install uv using one of the following methods:
pip install uv
Visit the uv documentation for more installation options.

​
Installation Methods

Choose your preferred installation method: 
# Run directly without installation
uvx mcp-server-motherduck --help
We recommend using uvx for the simplest experience. It runs the package directly without requiring a global installation.

​
Verify Installation

Test that the installation was successful: 
mcp-server-motherduck --help
You should see output showing the available command-line options: 
MotherDuck MCP Server - Execute SQL queries via DuckDB/MotherDuck.

Options:
  --port INTEGER                  Port to listen on for HTTP transport
  --host TEXT                     Host to bind the MCP server
  --transport [stdio|http|sse|stream]
                                  Transport type
  --db-path TEXT                  Path to local DuckDB database file or
                                  MotherDuck database
  --read-write                    Enable write access to the database
  ...

​
Next Steps

Quickstart Guide

Learn how to configure MCP Server MotherDuck with your AI assistant or IDE

​
Troubleshooting

If you encounter a spawn uvx ENOENT error, your client may not be able to find the uvx command.Solution: Specify the full path to uvx in your configuration:
# Find the uvx path
which uvx
Then use the full path in your MCP configuration (e.g., /usr/local/bin/uvx or /home/username/.local/bin/uvx).
MCP Server MotherDuck requires Python 3.10 or higher.Check your Python version:
python --version
If you need to upgrade, visit python.org or use a version manager like pyenv.
If you encounter permission errors during installation:
  • With pip: Try installing with the --user flag: 
    pip install --user mcp-server-motherduck
  • With uv: Use uvx instead, which doesn’t require global installation

Build docs developers (and LLMs) love

Get started for freeTalk to us