io.github.motherduckdb/mcp-server-motherduck

Run SQL analytics and data engineering workflows through MotherDuck for AI assistants.

Source

Official Registry

Updated

2026-06-09

// securityCaution

Requires keys· MOTHERDUCK_TOKEN, HOME, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, AWS_DEFAULT_REGION, AWS_ENDPOINT
Runs locally
Official / curated
Open source
Community-trusted

Running security audit…

Credentials
Network egress
Code execution
Data access
Supply chain

// install

Copy the install command and let the AI configure it · recommended for beginners

Please install the "io.github.motherduckdb/mcp-server-motherduck" MCP server from askskill:
Run: claude mcp add 'io-github-motherduckdb-mcp-server-motherduck' -- npx -y mcp-server-motherduck

// examples

Analyze sales trends

Prompt

Connect to the sales dataset in MotherDuck, summarize revenue and order counts by month for the last 12 months, identify the fastest growth month and the steepest decline month, and return the SQL plus a short findings summary.

Expected

Executable SQL, monthly summary results, and a concise analysis of the sales trend.

Clean and build an analytics table

Prompt

Use MotherDuck to deduplicate a raw user events table, normalize timestamp formats, filter invalid records, and create an aggregated activity analytics table by user and date, explaining each transformation step.

Expected

SQL for cleaning and table creation, along with a clear explanation of the data engineering steps.

Troubleshoot SQL performance

Prompt

Review this slow-running query in MotherDuck, analyze likely performance bottlenecks, and provide an optimized SQL version with tuning recommendations.

Expected

A performance diagnosis, optimized SQL, and a list of actionable improvement recommendations.