Skip to content
ai-supply.store
ExplorarCategoríasClasificacionesComunidadAgent APIFAQ
Iniciar sesiónRegístrate gratis
catalog / Data & ETL / DuckDB & MotherDuck MCP Server
⇄ConnectorData & ETLFree

DuckDB & MotherDuck MCP Server

Local MCP server that lets agents run analytical SQL over DuckDB files and MotherDuck cloud warehouses.

@ai-supply
Instalaciones34k
⟳ upstream v1.0.7 · updated 2mo ago
↗ Repositorio fuente
← More Data & ETLData & ETL leaderboard →How we grade security →Source ↗
! Grade B · 88/100 · ReviewSecurity assessment
✓No compromise signals10capabilities surfaced1known CVE9of 20 OWASP controls clear
Broad capability surfaceBroad capability surfaceSuspicious code patternsSuspicious network references
scanned 1mo ago·osv · gitleaks · opengrep · picklescan + heuristics·full breakdown in the Security tab ↓

DuckDB & MotherDuck MCP Server

This Model Context Protocol server exposes DuckDB — the fast in-process analytical database — and the MotherDuck cloud warehouse to AI agents through a single SQL tool. It is ideal for ad-hoc data analysis where an agent needs to query Parquet, CSV, or JSON without spinning up heavy infrastructure.

Key features

  • One query tool that runs arbitrary DuckDB SQL against local files or MotherDuck cloud databases
  • Directly reads Parquet, CSV, and JSON with DuckDB's zero-copy, columnar engine
  • Supports in-memory mode for throwaway analysis or a persistent .duckdb file
  • Optional MotherDuck token to attach shared cloud warehouses and hybrid local/cloud queries
  • Lightweight Python implementation installable via uvx, easy to add to any MCP client

Because DuckDB speaks standard SQL and handles gigabyte-scale files on a laptop, this server turns an agent into a capable, low-friction data analyst.

Curated mirror of the open-source mcp-server-motherduck (MIT). Get it from the source.

Rating rank
#1
of 24 in Data & ETL
Install rank
#19
of 24 in Data & ETL
Security score
88/100 · B
review
Security rank
#8
of 24 in Data & ETL
Installs
34k
cat avg 164k
This listing vs category average
Installs
this
cat avg
Security (of 100)
this
cat avg
Adoption trend
See the Data & ETL leaderboard →
! Security: Review · 8888/100 · grade Bscanned 1mo ago
✓ no compromise signals11 risk-surface · 5/20 OWASP controls flagged

Compromise signals — malicious or tampered code (leaked secrets, backdoors, a dropped executable) — reduce the score, and known dependency CVEs carry a bounded penalty (they warrant review but never QUARANTINE — update the dependency to clear). Other dangerous-by-capability traits are risk surface, expected for some capabilities. Every finding is mapped to its OWASP control below.

What this capability can do · high confidence (static)
Tools (3)
list_databases_toollist_tableslist_columns
⚑ filesystem⚑ shell⚑ network⚑ secrets
egress → motherduck.com, cursor.com, img.shields.io, insiders.vscode.dev, kiro.dev, duckdb.org, docs.aws.amazon.com, www.youtube.com +4
github.commotherduck.comcursor.comimg.shields.ioinsiders.vscode.devkiro.devduckdb.orgdocs.aws.amazon.com

Findings mapped to the OWASP Top 10 for LLM Applications (2025) and the OWASP Machine Learning Security Top 10. Expand any flagged control for the exact findings — compromise reduces the score; expected/risk-surface do not, except a known CVE, which carries a small bounded penalty (high/critical → Review).

OWASP Top 10 for LLM Applications
⚠LLM03Supply Chainhigh
Vulnerable/compromised dependencies, models or archives in the artifact.
•Vulnerable dependencies — 23 known vulnerabilities in: cryptography@47.0.0, joserfc@1.6.4, pydantic-settings@2.14.0, pyjwt@2.12.1, python-multipart@0.0.27, starlette@1.0.1 (CWE-1395)known CVE · -12 pts
⚠LLM05Improper Output Handlingmedium
Code that pipes model/user output into shell, eval, SQL or paths unsafely.
•Suspicious code patterns — OS command execution · motherduckdb-mcp-server-motherduck-dc17020/tests/e2e/test_http_transport.py (CWE-78)risk surface
•Suspicious code patterns — dynamic code execution · motherduckdb-mcp-server-motherduck-dc17020/tests/e2e/test_motherduck_readonly.py (CWE-95)risk surface
⚠LLM06Excessive Agencylow
Over-broad tool/permission surface or unrestricted egress.
•External endpoints declared — 1 distinct host(s) · motherduckdb-mcp-server-motherduck-dc17020/.github/workflows/publish-mcp.ymlexpected
•External endpoints declared — 3 distinct host(s) · motherduckdb-mcp-server-motherduck-dc17020/.gitignoreexpected
•Broad capability surface — 4 high-impact capability categories referenced — verify least-privilege · motherduckdb-mcp-server-motherduck-dc17020/README.md (CWE-272)risk surface
•External endpoints declared — 9 distinct host(s) · motherduckdb-mcp-server-motherduck-dc17020/README.mdexpected
•Broad capability surface — 3 high-impact capability categories referenced — verify least-privilege · motherduckdb-mcp-server-motherduck-dc17020/manifest.json (CWE-272)risk surface
•External endpoints declared — 2 distinct host(s) · motherduckdb-mcp-server-motherduck-dc17020/manifest.jsonexpected
•External endpoints declared — 4 distinct host(s) · motherduckdb-mcp-server-motherduck-dc17020/server.jsonexpected
§LLM09MisinformationGovernance
Artifacts designed to produce false/deceptive output.
Detectable only by runtime behavioral evaluation; addressed via responsible-use attestation.
◷LLM10Unbounded ConsumptionRuntime-enforced
Unbounded loops/recursion causing DoS or runaway cost.
Enforced at runtime by the gateway (rate limits + spend caps + size caps); static check flags unbounded loops.
✓LLM01Prompt InjectionPassed
✓LLM02Sensitive Information DisclosurePassed
✓LLM04Data and Model PoisoningPassed
Backdoors/poisoning in training data or serialized models.
Behavioral poisoning needs model execution; static check covers unsafe serialization + dataset skew only.
✓LLM07System Prompt LeakagePassed
✓LLM08Vector and Embedding WeaknessesPassed
PII or plaintext source leakage in embedding/vector exports.
Embedding inversion/poisoning is largely runtime; static check covers PII in vector exports.
OWASP Machine Learning Security Top 10
⚠ML06AI Supply Chainhigh
Compromised PyPI/npm packages, typosquats, unsafe serialized models.
•Vulnerable dependencies — 23 known vulnerabilities in: cryptography@47.0.0, joserfc@1.6.4, pydantic-settings@2.14.0, pyjwt@2.12.1, python-multipart@0.0.27, starlette@1.0.1 (CWE-1395)known CVE · -12 pts
⚠ML09Output Integritymedium
Middleware tampering with model outputs in transit.
Gateway enforces TLS + response integrity; static check flags output-rewriting code.
•Suspicious code patterns — OS command execution · motherduckdb-mcp-server-motherduck-dc17020/tests/e2e/test_http_transport.py (CWE-78)risk surface
•Suspicious code patterns — dynamic code execution · motherduckdb-mcp-server-motherduck-dc17020/tests/e2e/test_motherduck_readonly.py (CWE-95)risk surface
§ML01Input Manipulation (Adversarial)Governance
Models vulnerable to adversarial perturbations.
Requires runtime robustness evaluation; addressed via publisher robustness attestation.
§ML03Model InversionGovernance
Training data reconstructable from a model's outputs.
Runtime/evaluation property; addressed via model-card data-provenance + DP attestation.
§ML04Membership InferenceGovernance
Determining whether a record was in the training set.
Runtime/evaluation property; addressed via overfitting disclosure + DP attestation.
§ML08Model SkewingGovernance
Models trained on skewed data producing biased output.
Requires fairness evaluation; addressed via model-card bias/limitations disclosure.
✓ML02Data PoisoningPassed
Poisoned training datasets with triggers or anomalous distributions.
Static check covers trigger phrasing, PII and label skew; full poisoning detection is runtime.
✓ML05Model TheftPassed
Unlicensed re-distribution / license-incompatible derivatives.
Static check verifies license declaration; extraction throttling is runtime.
✓ML07Transfer Learning AttackPassed
Backdoored base models / LoRA adapters propagating to derivatives.
Backdoor detection needs behavioral probing; static check covers unsafe serialization + provenance.
✓ML10Model Poisoning (Weights)Passed
Tampered model weight files; integrity must be verifiable.
Static check enforces safe formats + records a content hash for downstream verification.
Other findings (5) · hygiene / uncategorized
•Unrecognized file type — '.gitignore' is not on the allowlist · motherduckdb-mcp-server-motherduck-dc17020/.gitignorerisk surface
•Unrecognized file type — '.mcpbignore' is not on the allowlist · motherduckdb-mcp-server-motherduck-dc17020/.mcpbignorerisk surface
•Unrecognized file type — '.python-version' is not on the allowlist · motherduckdb-mcp-server-motherduck-dc17020/.python-versionrisk surface
•Unrecognized file type — '.?' is not on the allowlist · motherduckdb-mcp-server-motherduck-dc17020/LICENSErisk surface
•Suspicious network references — raw IP URL (3 URLs) · motherduckdb-mcp-server-motherduck-dc17020/tests/e2e/test_http_transport.pyrisk surface
✔ verified source · pinned motherduckdb-mcp-server-motherduck-dc17020
Check against a policy

The same gate an agent runs before installing (POST /api/v1/trust/motherduck-duckdb-mcp/check). Click a policy:

Consume DuckDB & MotherDuck MCP Server programmatically. Authenticate with an API key or session — see Authorize an agent.

# Agents: CHECK BEFORE YOU INSTALL (no auth) — score, grade, level, capability manifest
curl https://ai-supply.store/api/v1/trust/motherduck-duckdb-mcp

# Gate against your org policy (returns { pass, violations })
curl -X POST https://ai-supply.store/api/v1/trust/motherduck-duckdb-mcp/check \
  -H "Content-Type: application/json" \
  -d '{"minGrade":"B","denyPermissions":["shell"],"denyUnknownEgress":true}'

# CLI
npx ai-supply add motherduck-duckdb-mcp

# REST (install → download)
curl -X POST https://ai-supply.store/api/v1/listings/motherduck-duckdb-mcp/install \
  -H "Authorization: Bearer $AIM_KEY"

# MCP tool
install_listing({ "slug": "motherduck-duckdb-mcp" })
OpenAPI spec →
vlatest
! Security: Review · 881mo ago

Curated mirror — latest upstream source. See the repository for tagged releases.

Sign in and install this listing to leave a review.

More from @ai-supply

View profile →
◉Agent
MetaGPT
Multi-agent framework that assigns GPT roles (PM, engineer, QA) to solve complex software tasks end-to-end.
↓ 1.0M
⇄Connector
vLLM
High-throughput, memory-efficient LLM inference engine with PagedAttention and continuous batching.
↓ 892k
⇄Connector
Meilisearch
Lightning-fast open-source search engine with typo-tolerance, semantic hybrid search, and sub-50ms response times.
↓ 811k
△Eval
Weights & Biases (wandb)
ML experiment tracking and visualization — log metrics, hyperparameters, models, and media in real time.
↓ 784k
ai-supply.store

Capacidades de IA gratuitas y verificadas en seguridad: skills, MCPs, plugins, agents, datasets y mucho más, cada una con su puntuación y control de actualidad, pensadas por igual para personas y agents.

api · v3.1status · all green
Contacto
support@ai-supply.storesecurity@ai-supply.store
Catálogo
  • Explorar
  • Categorías
  • Clasificaciones
  • Benchmarks
  • Seguridad
  • Scan a repo
Comunidad
  • Comunidad
  • FAQ
Para agentes
  • Inicio rápido (60s)
  • Autorizar un agente
  • Agent API
  • Especificación OpenAPI
Para desarrolladores
  • Publicar
  • Panel
Cuenta
  • Crear cuenta
  • Iniciar sesión
  • Configuración
Legal
  • Términos
  • Acuerdo de editor
  • Uso aceptable
  • Privacidad