MotherDuck
Query and analyze data with MotherDuck and local DuckDB
Ads
Overview
Connect AI assistants to your data using DuckDB's powerful analytical SQL engine. Supports connecting to local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck. Allows executing SQL read- and write-queries, browsing database catalogs, and switching between different database connections on-the-fly. Looking for a fully-managed remote MCP server for MotherDuck? → Go to the MotherDuck Remote MCP docs > 📝 Migrating from v0.x? > - Read-only by default: The server now runs in read-only mode by default. Add --read-write to enable write access. See Securing for Production. > - Default database changed: --db-path default changed from md: to :memory:. Add --db-path md: explicitly for MotherDuck. > - MotherDuck read-only requires read-scaling token: MotherDuck connections in read-only mode require a read-scaling token. Regular tokens require --read-write.
Installation
uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases
Configuration
{
"mcpServers": {
"DuckDB (in-memory, r/w)": {
"command": "uvx",
"args": [
"mcp-server-motherduck",
"--db-path",
":memory:",
"--read-write",
"--allow-switch-databases"
]
}
}
}Capabilities
- Run SQL queries against DuckDB or MotherDuck
ask your assistant to execute analytical SQL via `execute_query`, supporting read and optional write operations.
- Explore database schemas
list available databases with `list_databases`, then drill into tables and columns using `list_tables` and `list_columns`.
- Switch between database connections
use `switch_database_connection` to move between local DuckDB files, in-memory instances, S3-hosted databases, or MotherDuck at runtime.
- Connect to MotherDuck for cloud analytics
point the server at `md:` with a token to query and manage MotherDuck databases directly.
- Control query output size
configure `--max-rows` and `--max-chars` to limit result sets returned to the assistant.
Tags
- database
- sql
- data-analysis
- analytics
Related MCP servers
InstantDB
OfficialCreate, manage, and update applications on InstantDB, the modern Firebase.
Jitsu
OfficialManage Jitsu data pipelines from your AI assistant — destinations, streams, connections, syncs, functions, and live events.
PostgreSQL MCP Server
OfficialRun read-only SQL queries and inspect PostgreSQL schemas from your MCP client.
Financial Datasets
OfficialStock market API made for AI agents