Can VS Code & GitHub Copilot Use DuckDB / MotherDuck? MCP Setup

Q: Can VS Code & GitHub Copilot use DuckDB / MotherDuck?

Yes, via local install. Paste the install config into VS Code’s mcp.json. 9 DuckDB / MotherDuck MCP servers run locally on your machine. Checked on 2026-10-27.

Updated October 27, 2026 · from live checks of 50,180 MCP servers · Methodology

Built a third-party DuckDB / MotherDuck MCP server? Get the Verified vendor label so buyers can tell yours from the other 9 ($49/mo) Get Verified →

Remote DuckDB / MotherDuck servers

Server	Publisher	Status	Sign-in	Tools	Trust
stagenth · 数据工具箱 Yours? Claim it	Registry domain	Down	API key	—	D

Local DuckDB / MotherDuck servers

Server	Publisher	Status	Sign-in	Tools	Trust
MCP Server Motherduck Yours? Claim it	Official	Local install	API key	—	A
Misata: synthetic data library Yours? Claim it	Community	Local install	No auth	—	B
Sqlike MCP Yours? Claim it	Community	Local install	API key	—	C
MCP Data Pipeline Connector Yours? Claim it	Community	Local install	API key	—	C
MCP Server Spreadsheet Yours? Claim it	Community	Local install	No auth	—	C
MCP Loom Yours? Claim it	Community	Local install	No auth	—	C
Vector DB MCP Yours? Claim it	Community	Local install	No auth	—	C
Warehouse MCP Yours? Claim it	Community	Local install	API key	—	C

How to add DuckDB / MotherDuck to VS Code & GitHub Copilot

Open the Command Palette and run MCP: Add Server. Choose HTTP for a server URL or Command (stdio) for a local install command.
Or edit .vscode/mcp.json in your workspace: VS Code’s format puts servers under a top-level "servers" object (remote: "type": "http" + "url"; local: "type": "stdio" + "command"). Portable Copilot files (.mcp.json, ~/.copilot/mcp-config.json) use "mcpServers" instead, so don’t copy between them unchecked.
Sign in if the server asks, then use its tools in Copilot agent chat.

Example for MCP Server Motherduck (local, from the table above), in .vscode/mcp.json:

{
  "servers": {
    "duckdb": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ],
      "env": {
        "motherduck_token": "<value>",
        "MOTHERDUCK_TOKEN": "<value>",
        "AWS_ACCESS_KEY_ID": "<value>",
        "AWS_SECRET_ACCESS_KEY": "<value>",
        "AWS_SESSION_TOKEN": "<value>"
      }
    }
  }
}

Menus change, so check the VS Code MCP configuration reference. Every server page has a copy-paste config for VS Code & GitHub Copilot.

Is it safe to connect DuckDB / MotherDuck to VS Code & GitHub Copilot?

Use the official server run by DuckDB / MotherDuck. Anything a tool returns is sent to the AI vendor, so use a business plan that doesn't train on your data.

Can ChatGPT or Claude connect to DuckDB / MotherDuck?

See https://canmyaiuse.pages.dev/can/chatgpt/duckdb/ and https://canmyaiuse.pages.dev/can/claude/duckdb/

Does DuckDB / MotherDuck have an official MCP server?

Yes: MCP Server Motherduck (io.github.motherduckdb/mcp-server-motherduck), published by DuckDB / MotherDuck in the official MCP Registry. Full list: https://canmyaiuse.pages.dev/apps/duckdb/

Can VS Code & GitHub Copilot use DuckDB / MotherDuck?

Official DuckDB / MotherDuck route