Lets an AI assistant query many databases through prebuilt or custom SQL tools.

MotherDuck MCP Server
MCP server by MotherDuck
MotherDuck MCP Server at a glance
MotherDuck MCP Server is an official MCP server from MotherDuck. It lets an AI assistant run SQL analytics on DuckDB files and MotherDuck cloud databases.
- Connects to
- Data and databases
- Hosting
- Remote and local · Streamable HTTP and stdio
- Sign-in
- OAuth or MotherDuck token
- Price
- Free (needs a MotherDuck account)
- Works with
- Claude, Claude Code, ChatGPT, Cursor, VS Code, Gemini CLI
- Best for
- Analysts using DuckDB or MotherDuck
- Checked
- October 3, 2026 on official sources
How to install MotherDuck MCP Server
Add the URL below as a new MCP server in your AI app’s settings or MCP config file, then sign in when asked. Sign-in: OAuth or MotherDuck token.
https://api.motherduck.com/mcpWhat MotherDuck MCP Server can do
It connects an AI assistant to MotherDuck or local DuckDB so it can explore schemas and run SQL. The hosted version also manages data shares and can build interactive visual reports called Dives.
Best for: analysts using DuckDB or MotherDuck
Pros
- Hosted and local options
- Works with local files and S3
- Read-only mode available
Cons
- Hosted server needs a MotherDuck account
- Query results pass through the remote server
MotherDuck MCP Server FAQ
Is MotherDuck MCP Server free?
The local server is free and open source under MIT. The hosted server needs a MotherDuck account.
How do I connect MotherDuck MCP Server?
Add https://api.motherduck.com/mcp to your client and sign in, or run uvx mcp-server-motherduck locally.
What can MotherDuck MCP Server do?
It can run SQL, list databases, tables and columns and work with DuckDB files, S3 data and MotherDuck.