What is MCP Server MotherDuck?
MCP Server MotherDuck connects AI assistants to your data using DuckDB’s powerful analytical SQL engine. It’s a local MCP server that enables AI-powered data analysis, SQL query execution, and data engineering workflows directly from your IDE or AI assistant.Looking for a fully-managed remote MCP server for MotherDuck? Check out the MotherDuck Remote MCP for zero-setup, hosted-by-MotherDuck access.
Key Features
Multiple Database Types
Connect to local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck cloud databases
SQL Query Execution
Execute read and write SQL queries using DuckDB’s analytical SQL dialect with full OLAP capabilities
Database Catalog Browsing
List databases, tables, views, and columns to explore your data schema dynamically
Flexible Connection Switching
Switch between different database connections on-the-fly during your session
Local & Remote Data
Query across local and remote databases, ingest data from or export data to local filesystem
Security Controls
Read-only mode by default with configurable write access and security options for production
Capabilities
SQL Analytics
Execute powerful analytical SQL queries using DuckDB’s OLAP engine. Run aggregations, joins, window functions, and complex analytical queries on your data.DuckDB & MotherDuck Support
- Local DuckDB: Work with local
.duckdbfiles with read-only or read-write access - In-Memory: Create temporary databases for development and testing
- S3 Integration: Connect to DuckDB files hosted on S3
- MotherDuck Cloud: Access your MotherDuck cloud databases with full read-write capabilities
Database Management
Browse database catalogs, list tables and views, inspect column schemas, and manage multiple database connections within a single session.Remote vs Local MCP
| Feature | Remote MCP | Local MCP (this server) |
|---|---|---|
| Hosting | Hosted by MotherDuck | Runs locally/self-hosted |
| Setup | Zero-setup | Requires local installation |
| Access | Read-write supported | Read-write supported |
| Local filesystem | - | Query across local and remote databases, ingest data from / export data to local filesystem |
Get Started
Installation
Install MCP Server MotherDuck using uvx, pip, or uv
Quickstart
Connect to DuckDB or MotherDuck and run your first query
Configuration
Configure database paths, security settings, and query limits
Tools Reference
Explore available MCP tools for SQL execution and catalog browsing