MCP Server Motherduck

SQL analytics and data engineering for AI Assistants and IDEs

Connector by motherduckdb · GitHub account verified by the MCP Registry

IndexedMITLocal (stdio)★ 534

Write a review

Chalk Labs

Need help deploying MCP Server Motherduck?

Chalk Labs sets up agents like this inside real teams: connected to your tools, tested on your data, with a human in the loop where it matters.

Book a call

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/motherduckdb-mcp-server-motherduck

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

About

SQL analytics and data engineering for AI Assistants and IDEs

Use cases: database-access, data-analysis

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list and install config. Checked Oct 25, 2026.

Tools: 3 read · 0 write · 0 delete · 2 not yet classified
Secrets: 5 (API keys, tokens or passwords)
Install scripts: None found
Runs as: Python package

Tools by what they do 5

Read from the source code; the running server may list different tools.

Read 3 · Look things up without changing anything.

list_columns
list_databases
list_tables

Not yet classified 2 · We could not tell from the name and description.

execute_query
switch_database_connection

Secrets and settings it asks for

Secrets: values you paste in that let it act as you.

AWS_ACCESS_KEY_ID
AWS_SECRET_ACCESS_KEY
AWS_SESSION_TOKEN
MOTHERDUCK_TOKEN
motherduck_token

Other settings (environment variables or headers).

AWS_DEFAULT_REGION
AWS_ENDPOINT
HOME

Files it touches

Any path the agent passes to its tools

Tools (5)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

execute_queryExecute Query
Execute a SQL query on the DuckDB or MotherDuck database. Unqualified table names resolve to current_database() and current_schema() automatically. Fully qualified names (database.schema.table) are only needed when multiple DuckDB databases are attached or when connected to MotherDuck.
list_columnsList Columns
List all columns of a table or view with their types and comments. If database/schema are not specified, uses the current database/schema.
list_databasesList Databases
List all databases available in the connection. Useful when multiple DuckDB databases are attached or when connected to MotherDuck.
list_tablesList Tables
List all tables and views in a database with their comments. If database is not specified, uses the current database.
switch_database_connectionSwitch Database Connection
Switch to a different database connection. For local files, use absolute paths only. The new connection respects the server's read-only/read-write mode. For local files, the file must exist unless create_if_not_exists=True (requires read-write mode).

Compare and alternatives

Alternatives to MCP Server Motherduck →

Featured in

Signals

Stars: 534
Forks: 90
Open issues: 0
Contributors: 20
Weekly downloads: 4,996
Last commit: Oct 7, 2026 (23 days ago)
Last release: Oct 7, 2026 (23 days ago)
Last package publish: Oct 7, 2026 (23 days ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name: io.github.motherduckdb/mcp-server-motherduck
Version: 1.1.0
Auth: API key
Packages: pypi mcp-server-motherduck
License: MIT
Repository: github.com/motherduckdb/mcp-server-motherduck
First seen: Oct 24, 2026
Last checked: Oct 24, 2026
Source: Official MCP Registry github-graphql

Done for you

Rather not set it up yourself?

Chalk Labs scopes, builds and runs agents for your team: the task audit, the eval harness, the integrations and the weekly ops report. Fixed scope, priced before we start.

See how we build AI agents →Read the case studies

Chalk Labs is a two-founder AI and growth studio. We build AI agents, CRMs and MVPs for Web3 and AI companies, and have shipped 50+ product and token launches.

launches shipped: 50+; launches shipped
media placements: 500+; media placements
founders on every account: 2; founders on every account

Press we've placed: Forbes · CoinDesk · Decrypt · Cointelegraph · The Block

Rahil Jain, Co-founder, Chalk Labs. Ex-Goldman Sachs engineer. You talk to the person who builds it.

Get MCP Server Motherduck running in your business

Tell us what you want to automate. A founder replies within one working day with a plan, not a pitch deck.

Need help deploying MCP Server Motherduck?

Call Get help

Cite this page

MCP Server Motherduck. Agent Mart. https://agentmart.dev/connectors/motherduckdb-mcp-server-motherduck (last updated 2026-10-24)