DuckDB MCP Server

MCP server for DuckDB, the fast in-process analytical database. Lets AI agents run analytical SQL over local files (CSV, Parquet, JSON), attach databases, inspect schemas, and profile queries. Ideal for ad-hoc data analysis, ETL prototyping, and querying large columnar files without a separate database server.

{
  "mcpServers": {
    "duckdb": {
      "command": "npx",
      "args": [
        "-y",
        "@motherduck/mcp-server-motherduck"
      ],
      "env": {
        "MOTHERDUCK_TOKEN": "<YOUR_MOTHERDUCK_TOKEN>"
      }
    }
  }
}

{
  "type": "object",
  "required": [
    "sql"
  ],
  "properties": {
    "sql": {
      "type": "string",
      "description": "SQL query to execute"
    }
  }
}

{
  "type": "object",
  "properties": {}
}