mcp-server-motherduck
Local MCP server for DuckDB and MotherDuck
What it does for you
Connects your AI to MotherDuck / DuckDB — run analytical queries over local and cloud data through chat.
Capabilities
- Run analytical SQL
- Query DuckDB / MotherDuck data
Once installed, try asking your AI
Say this directly in Claude / Cursor or any client with this server connected
- ›“Analyze this CSV and total by category”
Before you connect
Config example (to connect)
{
"mcpServers": {
"DuckDB (in-memory, r/w)": {
"command": "uvx",
"args": ["mcp-server-motherduck", "--db-path", ":memory:", "--read-write", "--allow-switch-databases"]
}
}
}Install / Connect
# No npm package — install from source.
# See the repo's README for the exact command:
# https://github.com/motherduckdb/mcp-server-motherduckFollow the official README; env and args vary per server.
🛠️ Maintenance weight 30% · 58 pts
📊 Adoption weight 25% · 49 pts
✅ Usability weight 20% · 100 pts
❤️ Health & community weight 25% · 74 pts
Sources: GitHub API · npm registry · Official registry · updated 2026-07-23
90-day trend
⭐ stars +0%
Similar / alternative servers
How to choose among these
Database servers split into relational vs. vector; vector stores are all for RAG, differing by scale and hosting.
- Relational DB (business data, SQL)→Pick Supabase / Neon / MongoDB / ClickHouse — match your DB
- RAG with semantic memory→Pick a vector store: Pinecone (scaled) / Qdrant / Chroma (light) / Weaviate
@supabase/mcp-server-supabase
Connect Supabase to your AI assistants
@redis/mcp-redis
The official Redis MCP Server is a natural language interface designed for agent
@clickhouse/mcp-clickhouse
Connect ClickHouse to your AI assistants.
ai.haymon/database
Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite
One email a week, 5 minutes to see what happened in the MCP ecosystem
New servers, breakout trends, abandonment alerts — tracked automatically, curated by hand, sent to your inbox.
One email a week · unsubscribe anytime · no data selling