MotherDuck MCP Server (Official)

Official MotherDuck MCP server enabling AI agents to run SQL analytics with DuckDB — querying local files (Parquet, CSV, JSON), cloud-hosted MotherDuck databases, and performing in-process analytics without spinning up a cluster.

Evaluated Mar 06, 2026 (0d ago) vcurrent

Homepage ↗ Repo ↗ Other motherduck duckdb analytics mcp-server official sql serverless olap

⚙ Agent Friendliness

/ 100

Can an agent use this?

🔒 Security

/ 100

Is it safe for agents?

⚡ Reliability

/ 100

Does it work consistently?

Score Breakdown

⚙ Agent Friendliness

MCP Quality

Documentation

Error Messages

Auth Simplicity

Rate Limits

🔒 Security

TLS Enforcement

100

Auth Strength

Scope Granularity

Dep. Hygiene

Secret Handling

HTTPS for cloud. No token scope granularity. SOC 2. Local DuckDB is fully on-device.

⚡ Reliability

Uptime/SLA

Version Stability

Breaking Changes

Error Recovery

Best When

An agent needs fast, serverless SQL analytics on local or cloud data files — especially for data exploration and ad-hoc analysis without infrastructure overhead.

Avoid When

You need a multi-user concurrency-heavy data warehouse — use BigQuery, Snowflake, or ClickHouse instead.

Use Cases

• Running fast SQL analytics on local files from data analysis agents
• Querying MotherDuck cloud databases from analytics agents
• Analyzing Parquet files directly from data pipeline agents
• Ad-hoc data exploration with zero infrastructure from exploration agents
• Joining local and cloud data with hybrid execution
• Generating analytics reports from large CSV/JSON datasets

Not For

• High-concurrency OLTP transactional workloads
• Teams needing enterprise-scale distributed analytics (use BigQuery/Snowflake)
• Real-time streaming analytics

Interface

REST API

GraphQL

gRPC

MCP Server

Yes ↗

SDK

Yes

Webhooks

Authentication

Methods: service_token

OAuth: No Scopes: No

MotherDuck service token for cloud database access. Local DuckDB requires no auth. Token scopes not granular.

Pricing

Model: usage-based

Free tier: Yes

Requires CC: No

MotherDuck is serverless DuckDB in the cloud. Local DuckDB is always free. MCP server is open source.

Agent Metadata

Pagination

none

Idempotent

Full

Retry Guidance

Not documented

Known Gotchas

⚠ DuckDB SQL is mostly PostgreSQL-compatible but has extensions (PIVOT, UNPIVOT, LIST, STRUCT)
⚠ File paths for local queries must be absolute or relative to working directory
⚠ md: prefix required for MotherDuck cloud queries (e.g., md:mydb.schema.table)
⚠ No token scope granularity — full MotherDuck account access
⚠ Memory limits apply for very large in-process queries
⚠ Parquet, CSV, JSON files can be queried directly without import

Alternatives

google-bigquery-mcp mcp-clickhouse databricks-mcp-server

Full Evaluation Report

Detailed scoring breakdown, competitive positioning, security analysis, and improvement recommendations for MotherDuck MCP Server (Official).

$99

API endpoint ↗ Agent guide ↗ Report inaccuracy

Scores are editorial opinions as of 2026-03-06.