Skip to content
AgentAtlas

Official server by MotherDuck

MotherDuck / DuckDB MCP server

SQL analytics over DuckDB and MotherDuck.

Install

Pick your agent and copy one line. Remote servers ask you to sign in on first use.

claude mcp add motherduck -- uvx mcp-server-motherduck
Full steps for Claude Code →

Comparing options? Database MCP servers compared →

What it can do

From MotherDuck's own MCP documentation.

Sign in

Hosted: OAuth for most clients, or Authorization: Bearer with a MotherDuck token. Local: motherduck_token or MOTHERDUCK_TOKEN env var, or --motherduck-token.

Tools

execute_querylist_databaseslist_tableslist_columnsswitch_database_connection

Options

  • Local server is read-only by default. --read-write enables writes.
  • --allow-switch-databases enables switch_database_connection.
  • --max-rows (default 1024) and --max-chars (default 50000) cap results.
  • --query-timeout, --init-sql, --db-path (default :memory:), --transport stdio or http.
  • --motherduck-saas-mode.

Good to know

  • The tool list above is for the local open source server. The hosted server groups tools into core, Dive, Flight and Guide tools without listing names.
  • The hosted server is read-write and available in all MotherDuck regions. Query results pass through the remote server.
  • Read-only mode against MotherDuck needs a read-scaling token. Regular tokens need --read-write.
  • Read-only mode alone is not enough to safely give third parties access to a self-hosted server.

Details

Registry name
io.github.motherduckdb/mcp-server-motherduck
Latest version
1.1.0 (updated 2026-10-07)
Packages

mcp-server-motherduck (pypi)

Links
MotherDuck docsSource

More in Databases

Reviewed Oct 21, 2026. Official means published under MotherDuck's namespace in the MCP registry. It is not a security audit.

Built an MCP server? Get it listed everywhere →

Shipping an Android app? Google Play needs 12 testers for 14 days first. Get them with Tester Exchange →