Back
Marketplace/DuckDB / MotherDuck

TL;DR

DuckDB / MotherDuck is a Databases MCP server that lets Claude Code, Cursor, Windsurf and any MCP-compatible AI agent query and analyze data with MotherDuck and local DuckDB. Install in 1 minute with mcpizy install duckdb.

🦆

DuckDB / MotherDuck

Verified

Databases

Last updated May 30, 2026 · By MCPizy team

Query and analyze data with MotherDuck and local DuckDB. In-process analytical database.

Install DuckDB / MotherDuck

Via MCPizy CLI (recommended):
mcpizy install duckdb
Or run directly:
npx -y @motherduckdb/mcp-server
View on GitHub

Works with

Claude Code
Claude Desktop
Cursor
Windsurf
VS Code + Copilot
Any MCP Client

More Databases MCPs

⚡

DynamoDB

AWS DynamoDB NoSQL database operations

🐬

MariaDB

MariaDB relational database server

🪳

CockroachDB

Distributed SQL database for cloud apps

🗃️

SQLite

Local SQLite database access and management

Alternatives to DuckDB / MotherDuck

If DuckDB / MotherDuck doesn't fit your stack, these Databases MCP servers solve similar problems.

🔵

Neo4j

Graph database queries

🔍

Elasticsearch

Full-text search and analytics engine

🎯

Qdrant

Vector similarity search engine

Key Takeaways

  • DuckDB / MotherDuck exposes an MCP interface for databases workflows in Claude Code, Cursor and Windsurf.
  • No authentication required — works out of the box once installed.
  • Install in 1 command: mcpizy install duckdb — config written to your client automatically.
  • Free and open source (GitHub source linked above) — verified compatible with every MCP client (Claude Code, Claude Desktop, Cursor, Windsurf, VS Code + Copilot).
  • Best use case: automate databases workflows from your AI agent without leaving the editor.

Frequently asked questions

What is the DuckDB / MotherDuck MCP server?

The DuckDB / MotherDuck MCP server is an Databases Model Context Protocol server that lets Claude Code, Cursor, Windsurf, VS Code with Copilot, and other MCP-compatible AI agents query and analyze data with MotherDuck and local DuckDB. It exposes DuckDB / MotherDuck's capabilities as tools the AI can call directly from your editor or CLI.

How do I install DuckDB / MotherDuck MCP with Claude Code?

The fastest way is the MCPizy CLI: run `mcpizy install duckdb` and MCPizy will add the server to your `.claude.json` automatically. You can also install it manually by adding an entry under `mcpServers` in `.claude.json` with the command `npx -y @motherduckdb/mcp-server` and restarting Claude Code.

Is DuckDB / MotherDuck MCP free?

Yes. The DuckDB / MotherDuck MCP server is free and open source (see the GitHub repository linked on this page). You may still need a DuckDB / MotherDuck account or API key to connect the server to the underlying service, but the MCP layer itself has no MCPizy subscription cost.

Does DuckDB / MotherDuck MCP work with Cursor and Windsurf?

Yes. Any MCP-compatible client works — including Claude Code, Claude Desktop, Cursor (via `.cursor/mcp.json`), Windsurf, VS Code with Copilot Chat, and custom agents built on the MCP SDK. The same install command targets all of them; only the config file path differs.

What can I do with DuckDB / MotherDuck MCP?

Once installed, your AI agent can query and analyze data with MotherDuck and local DuckDB directly inside your conversation. Typical use cases include asking Claude Code or Cursor to run DuckDB / MotherDuck operations, inspect results, chain DuckDB / MotherDuck with other MCP servers (see our Workflow Recipes), and automate repetitive databases tasks without leaving your editor.

Manage all your MCPs in one place

Monitor usage, track costs, and discover new MCPs.

Get Started Free