Get the Agent Brief

MotherDuck MCP Server

MCP server by MotherDuck

OfficialRemote and local
Official pageGitHub repo
By the Klyvoo teamChecked October 3, 2026Checked on official sources

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.

Remote server URL
https://api.motherduck.com/mcp

What 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.

Tools it exposes include
execute_querylist_databaseslist_tableslist_columnsswitch_database_connection

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.