DuckDB MCP Server

uvx mcp-server-duckdb --db-path ~/data.duckdb

{
  "mcpServers": {
    "duckdb-mcp": {
      "command": "uvx",
      "args": [
        "mcp-server-duckdb",
        "--db-path",
        "~/data.duckdb"
      ]
    }
  }
}

Opens the DuckDB file given on the command line and exposes one tool that accepts any DuckDB SQL statement. The maintainer's reasoning is that a capable model writes its own SELECT, CREATE TABLE or JOIN, so splitting the surface into separate endpoints adds little. A read-only flag hands the guarantee to DuckDB itself rather than to prompt wording, and the file is created automatically when it does not exist.