io.github.motherduckdb/mcp-server-motherduck
SQL analytics and data engineering for AI Assistants and IDEs
MCP server · by motherduckdb
About
io.github.motherduckdb/mcp-server-motherduck is an MCP server published by motherduckdb. Marketplaces we read that list it: 1 (Official MCP Registry). The last change we recorded was on 2026-10-17. As of our marketplace pass on 2026-10-17.
What it asks for
- Runs on your machine
- Secrets: 5
- Settings: 8
Requires: AWS_ACCESS_KEY_ID (secret), AWS_SECRET_ACCESS_KEY (secret), AWS_SESSION_TOKEN (secret), MOTHERDUCK_TOKEN (secret), motherduck_token (secret)
What it declares, asks for and runs, in full
Only install plugins from developers you trust. We list what marketplaces publish and do not test plugins.
Package
PyPI mcp-server-motherduck (mcp-server-motherduck on PyPI)
- PyPI downloads/week: 7 274 (2026-10-13)
- PyPI downloads/month: 18 759 (2026-10-13)
- Latest version on PyPI: 1.1.0, published 2026-10-07
No known vulnerabilities in OSV for 1.1.0 (checked 2026-10-14)
PyPI facts come from pypi.org, PyPI downloads from pypistats.org. Each figure is the registry's own and is never added to another. A registry that publishes no figure shows none: no number is not zero. Vulnerability records come from OSV.dev (CC BY 4.0) and concern the declared version only; a listing that declares no version gets no answer. We do not scan code.
Works with
- Claude Code
- Codex
- Cursor
- VS Code
- Copilot CLI
From the marketplaces that list it and the MCP transport it declares, as each client documents them. We do not test plugins.
Connect
Commands and configs built only from what its marketplaces declare. We do not run them for you and do not test plugins.
As a local MCP server: PyPI package
Built from what Official MCP Registry declares.
claude mcp add --env "AWS_ACCESS_KEY_ID=<YOUR_AWS_ACCESS_KEY_ID>" --env "AWS_SECRET_ACCESS_KEY=<YOUR_AWS_SECRET_ACCESS_KEY>" --env "AWS_SESSION_TOKEN=<YOUR_AWS_SESSION_TOKEN>" --env "MOTHERDUCK_TOKEN=<YOUR_MOTHERDUCK_TOKEN>" --env "motherduck_token=<YOUR_MOTHERDUCK_TOKEN>" --transport stdio mcp-server-motherduck -- uvx mcp-server-motherduck --transport stdio --port 8000 --host 127.0.0.1 --db-path :memory: --max-rows 1024 --max-chars 50000 --query-timeout -1[mcp_servers.mcp-server-motherduck]
command = "uvx"
args = ["mcp-server-motherduck", "--transport", "stdio", "--port", "8000", "--host", "127.0.0.1", "--db-path", ":memory:", "--max-rows", "1024", "--max-chars", "50000", "--query-timeout", "-1"]
[mcp_servers.mcp-server-motherduck.env]
AWS_ACCESS_KEY_ID = "<YOUR_AWS_ACCESS_KEY_ID>"
AWS_SECRET_ACCESS_KEY = "<YOUR_AWS_SECRET_ACCESS_KEY>"
AWS_SESSION_TOKEN = "<YOUR_AWS_SESSION_TOKEN>"
MOTHERDUCK_TOKEN = "<YOUR_MOTHERDUCK_TOKEN>"
motherduck_token = "<YOUR_MOTHERDUCK_TOKEN>"{
"mcpServers": {
"mcp-server-motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck",
"--transport",
"stdio",
"--port",
"8000",
"--host",
"127.0.0.1",
"--db-path",
":memory:",
"--max-rows",
"1024",
"--max-chars",
"50000",
"--query-timeout",
"-1"
],
"env": {
"AWS_ACCESS_KEY_ID": "<YOUR_AWS_ACCESS_KEY_ID>",
"AWS_SECRET_ACCESS_KEY": "<YOUR_AWS_SECRET_ACCESS_KEY>",
"AWS_SESSION_TOKEN": "<YOUR_AWS_SESSION_TOKEN>",
"MOTHERDUCK_TOKEN": "<YOUR_MOTHERDUCK_TOKEN>",
"motherduck_token": "<YOUR_MOTHERDUCK_TOKEN>"
}
}
}
}Replace the values in angle brackets with your own. We show the names of the settings, never values.
Optional arguments it also declares: --motherduck-token, --read-write, --allow-switch-databases, --motherduck-saas-mode, --init-sql, --home-dir, --ephemeral-connections.
Optional settings it also lists: AWS_DEFAULT_REGION, AWS_ENDPOINT, HOME.
Where it is published
| Marketplace | Status | Version | Figures | Verified | First seen |
|---|---|---|---|---|---|
| Official MCP Registry (Open the registry record) | Listed | 1.1.0 | Downloads/month (PyPI): 18 759 Downloads/week (PyPI): 7 274 Forks (GitHub): 88 Stars (GitHub): 530 |
Not marked |
Each figure is the marketplace's own and is never added up across marketplaces. A marketplace that publishes no figure shows none: no number is not zero.
How its figures have moved
- 2026-10-12527
- 2026-10-13528
- 2026-10-14527
- 2026-10-16528
- 2026-10-17530
Each dot is a day we read a different number; flat stretches are days the number did not move. Figures of different marketplaces are never added up.
What changed
Nothing has moved on this plugin since we started watching it.
Similar plugins
Products whose own names, descriptions, tools and skills are closest in meaning to this one, on every marketplace we read. Closeness is ranked within this list only.
-
aifordatabase-mcp io.github.dann26parr69/aifordatabase-mcp
Query any database in plain English or SQL through a guardrailed, read-only data layer.
-
mcp com.gibsonai/mcp
GibsonAI MCP server: manage your databases with natural language
-
sql-builder-ai-mcp io.github.CSOAI-ORG/sql-builder-ai-mcp
Sql Builder Ai MCP Server by MEOK AI Labs
-
dbhawk com.datasparc/dbhawk
Secure access to DBHawk datasources: browse schemas, run governed queries, DBHawk AI text-to-SQL.
-
db-conn-mcp io.github.Idle-Sync/db-conn-mcp
A dead-simple, self-hosted MCP server for securely querying databases via AI agents.
-
simpliq-server io.github.gersonfreire/simpliq-server
Simpliq Data Proxy MCP Server - Connects LLMs to SQL Databases via Semantic Mapping
-
dingdawg-data-agent io.github.dingdawg/dingdawg-data-agent
AI data agent — schema analysis, query optimization, PII detection, pipelines.
-
postgres-mcp io.github.sparta2025/postgres-mcp
PostgreSQL MCP server with 15 tools (SQL, EXPLAIN, health, indexes) plus a Gradio UI with LLM chat.
-
MCP server providing AI assistants with safe, read-only SQL Server access
-
warehouse-mcp io.github.kalehdoo/warehouse-mcp
Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.
Similar plugins by marketplace
The same question asked of one marketplace at a time: is there an analog of this plugin there?
Has a listing on Claude Code: claude-plugins-community (5)
-
redash-mcp io.github.seob717/redash-mcp
Connect Redash to Claude -- query data, manage dashboards, and run SQL with natural language.
-
150+ SAP HANA database tools as MCP tools for AI assistants
-
Databricks skills for the CLI, Apps, Lakebase, Model Serving, Lakeflow Jobs, Spark Declarative Pipelines, Declarative Automation Bundles (DABs), and classic-to-serverless…
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
Manage your Neon projects and databases with the neon-postgres agent skill and the Neon MCP Server.
Has a listing on Claude Code: claude-plugins-official (5)
-
150+ SAP HANA database tools as MCP tools for AI assistants
-
Databricks skills for the CLI, Apps, Lakebase, Model Serving, Lakeflow Jobs, Spark Declarative Pipelines, Declarative Automation Bundles (DABs), and classic-to-serverless…
-
oracle-ai-data-platform-workbench-engineer-agent
Oracle AI Data Platform (AIDP) Workbench engineer agent for Claude Code — a 37-skill agent that operates the full Spark/Delta lakehouse in natural language. Discovers your catalog…
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
Manage your Neon projects and databases with the neon-postgres agent skill and the Neon MCP Server.
Has a listing on Claude: knowledge-work-plugins (5)
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
Connect Claude to your ClickHouse Cloud databases. Browse organizations, services, databases, and table schemas. Run read-only SQL queries against your data and get instant…
-
Prisma MCP integration for Postgres database management, schema migrations, SQL queries, and connection string management. Provision Prisma Postgres databases, run migrations, and…
-
An authenticated hosted MCP server that accesses your PlanetScale organizations, databases, branches, schema, and Insights data. Query against your data, surface slow queries, and…
-
Atlan data catalog plugin for Claude Code. Search, explore, govern, and manage your data assets through natural language. Powered by the Atlan MCP server with semantic search…
Has a listing on Codex: openai-curated (openai/plugins) (5)
-
Manage Supabase projects directly through ChatGPT. Execute SQL queries on PostgreSQL databases, design and modify table schemas, deploy serverless edge functions, and configure…
-
Answer product and business questions with data
-
Available for US1 customers only. Analyze, investigate, and act on your Datadog telemetry directly from ChatGPT using natural language. Ask questions about your production…
-
CrowdStrike Falcon Foundry development skills for building cybersecurity applications on the Falcon platform. Includes UI development, collections, functions, workflows, API…
-
Evaluate Codex skills and plugins from chat with a beginner-friendly start command, local-first reports, token budget explanations, and guided benchmarking.
Has a listing on Community GitHub marketplaces (5)
-
Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite
-
Read-only SQL querying + schema introspection over Postgres & SQLite, with a gated write mode.
-
Operations toolchain for SQLite, Cloudflare D1 & Turso: inspect, diff, migrate, monitor & repair.
-
Databricks skills for the CLI, Apps, Lakebase, Model Serving, Lakeflow Jobs, Spark Declarative Pipelines, Declarative Automation Bundles (DABs), and classic-to-serverless…
-
custom-mcp-database io.github.renanlido/custom-mcp-database
Run alias-based queries against PostgreSQL, MySQL, MongoDB and Oracle without exposing credentials.
Has a listing on Copilot CLI: github/awesome-copilot (5)
-
Connect GitHub Copilot to your CockroachDB clusters: run and explore SQL through MCP, with DBA/Developer/Operator agents, CockroachDB best-practice skills, and safety hooks that…
-
Database administration, SQL optimization, and data management tools for PostgreSQL, SQL Server, and general database development best practices.
-
Use Datadog directly in Copilot / VS Code through a preconfigured Datadog MCP server. Query logs, metrics, traces, dashboards, and more through natural conversation.
-
Build and manage Microsoft Dataverse solutions using natural language. Includes table/column creation, solution lifecycle, data operations, and MCP server configuration.
-
Complete toolkit for building Model Context Protocol (MCP) servers in TypeScript/Node.js using the official SDK. Includes instructions for best practices, a prompt for generating…
Has a listing on Copilot CLI: github/copilot-plugins (5)
-
Toolkit for building Microsoft 365 Copilot declarative agents — scaffolding, JSON manifest development, and capability configuration.
-
Build Power Apps Canvas Apps using the Canvas Authoring MCP server.
-
Bring Azure DevOps work-item, repository, and pull-request workflows into GitHub Copilot.
-
model-apps
Build and deploy Power Apps generative pages for model-driven apps with specialist agents for planning, entity creation, and parallel code generation. Requires PAC CLI >= 2.7.0…
-
Advanced Security plugin for GitHub Copilot.
Has a listing on Cursor: cursor/plugins (5)
-
Build apps, scripts, and automations with the TypeScript SDK.
-
Explore datasets and tables and run SQL queries.
-
Fan large tasks out across parallel cloud agents with planners, workers, verifiers, and structured handoffs.
-
Work with PostHog from chat: query product analytics and run SQL, manage feature flags and experiments, triage error tracking issues, and review session replays, surveys, and…
-
Skills for building on the Cursor Origin API. Fetch the live spec first, then follow the Origin rules for credentials, scopes, webhooks, paging, and errors. Includes a skill that…
Has a listing on Docker MCP Catalog (5)
-
schemacrawler-ai io.github.schemacrawler/schemacrawler-ai
Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast
-
Database interaction and business intelligence capabilities.
-
Enable AI agents to manage, monitor, and query CockroachDB using natural language. Perform complex database operations, cluster management, and query execution seamlessly through…
-
MCP server for SQLite, PostgreSQL, and MySQL with natural language to SQL and direct SQL tooling.
-
Keboola MCP Server is an open-source bridge between your Keboola project and modern AI tools.
Has a listing on Official MCP Registry (5)
-
aifordatabase-mcp io.github.dann26parr69/aifordatabase-mcp
Query any database in plain English or SQL through a guardrailed, read-only data layer.
-
mcp com.gibsonai/mcp
GibsonAI MCP server: manage your databases with natural language
-
sql-builder-ai-mcp io.github.CSOAI-ORG/sql-builder-ai-mcp
Sql Builder Ai MCP Server by MEOK AI Labs
-
dbhawk com.datasparc/dbhawk
Secure access to DBHawk datasources: browse schemas, run governed queries, DBHawk AI text-to-SQL.
-
db-conn-mcp io.github.Idle-Sync/db-conn-mcp
A dead-simple, self-hosted MCP server for securely querying databases via AI agents.
Found by meaning, not by shared code or a shared repository: similar plugins stay separate products, and this is not a review or a recommendation.
Want this mark on your plugin in our catalog?
Prove you maintain it with a file in its repository, a file on your domain or a DNS record, and you can show this mark on the card, with live banners for your site and README. How verification works
You also get alerts when a marketplace lists it, drops it, changes its verified mark or what it asks for, and its remote endpoint goes on monitoring as a web service.
Data comes from the Official MCP Registry (registry.modelcontextprotocol.io), CC0 1.0. Figures come from our own regular passes over the marketplaces, last read on . We publish no contact details for plugin publishers.