{"repo":"motherduckdb/mcp-server-motherduck","free":true,"listed":false,"github":"https://github.com/motherduckdb/mcp-server-motherduck","clone":"git clone https://github.com/motherduckdb/mcp-server-motherduck.git","description":"Local MCP server for DuckDB and MotherDuck","language":"Python","stars":506,"topics":["ai","duckdb","motherduck"],"license":"MIT","category":"mcp-servers","readme_excerpt":"DuckDB / MotherDuck Local MCP Server SQL analytics and data engineering for AI Assistants and IDEs. --- Connect AI assistants to your data using DuckDB's powerful analytical SQL engine. Supports connecting to local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck. Allows executing SQL read- and write-queries, browsing database catalogs, and switching between different database connections on-the-fly. Looking for a fully-managed remote MCP server for MotherDuck? → Go to the MotherDuck Remote MCP docs Remote vs Local MCP Remote MCP Local MCP (this repo) --- --- --- Hosting Hosted by MotherDuck Runs locally/self-hosted Setup Zero-setup Requires local installation Access Read-write supported Read-write supported Local filesystem - Query across local and remote databases, ingest data from / export data to local filesystem 📝 Migrating from v0.x? - Read-only by default : The server now runs in read-only mode by default. Add --read-write to enable write access. See Securing for Production. - Default database changed : --db-path default changed from md: to :memory: . Add --db-path md: explicitly for MotherDuck. - MotherDuck read-only requires read-scaling token : MotherDuck connections in read-only mode require a read-scaling token. Regular tokens require --read-write . Quick Start Prerequisites : Install uv via pip install uv or brew install uv Connecting to In-Memory DuckDB (Dev Mode) Full flexibility with no guardrails — read-write access and the ability to s","default_branch":null,"files":null,"tree":[],"storefront":"/r/motherduckdb","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/motherduckdb/mcp-server-motherduck/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}