# MotherDuck / DuckDB MCP Server

> MCP servers for DuckDB and MotherDuck: a managed remote server at api.motherduck.com/mcp and an open-source local server for DuckDB files, in-memory DBs and S3.

- id: `motherduck-mcp-server`
- category: MCP Servers (`mcp-servers`)
- url: https://motherduck.com/docs/sql-reference/mcp/
- repo: https://github.com/motherduckdb/mcp-server-motherduck
- docs: https://motherduck.com/docs/sql-reference/mcp/
- status: active
- pricing: freemium
- license: MIT
- tags: mcp, duckdb, motherduck, database, sql, analytics
- llms.txt: https://motherduck.com/docs/llms.txt
- mcp endpoint: https://api.motherduck.com/mcp
- auth: oauth
- access notes: OAuth for interactive clients; backend clients can send Authorization: Bearer <motherduck_token>. The MIT license covers the local server.
- related: ClickHouse MCP Server (https://indexagentica.com/entries/clickhouse-mcp-server/); Postgres MCP Pro (https://indexagentica.com/entries/postgres-mcp-pro/); MCP Toolbox for Databases (https://indexagentica.com/entries/mcp-toolbox-databases/); Neon MCP Server (https://indexagentica.com/entries/neon-mcp-server/)
- sources: https://motherduck.com/docs/sql-reference/mcp/ , https://github.com/motherduckdb/mcp-server-motherduck , https://motherduck.com/product/pricing/
- added: 2026-10-19
- updated: 2026-10-19
- last verified: 2026-10-19
- featured in: Data analysis agent stack (https://indexagentica.com/stacks/data-analysis-agent/)
- maintainer: MotherDuck
- submitted by: agentica-curator
- page: https://indexagentica.com/entries/motherduck-mcp-server/
- json: https://indexagentica.com/api/entries/motherduck-mcp-server.json

**Remote (managed):** `https://api.motherduck.com/mcp` over HTTP, OAuth for most clients or `Authorization: Bearer <motherduck_token>` for backend clients; runs read-only and read-write SQL, explores schemas, attaches shares, answers DuckDB/MotherDuck docs questions, and manages Dives, Flights and Guides. **Local (this repo):** `uvx mcp-server-motherduck --db-path ...` connects to local DuckDB files (read-only by default), in-memory databases, S3-hosted databases or MotherDuck, and can read from and write to the local filesystem. MotherDuck itself has a Lite plan from $0 and a Business plan at $250 per org per month plus usage.