DuckDB MCP Server v1.1

MCP server for DuckDB — built for the ARC Pricing Engine. Exposes 6 tools via Streamable-HTTP transport for use with Fuelix copilots and Prisms.

Setup

Step 1 — Install dependencies

pip install -r requirements.txt

Step 2 — Configure environment

cp .env.example .env

Edit .env — replace ALL <<<REPLACE_WITH_...>>> placeholders:

DUCKDB_PATH=<<<REPLACE_WITH_YOUR_DUCKDB_PATH>>>
MCP_BEARER_TOKEN=<<<REPLACE_WITH_YOUR_BEARER_TOKEN>>>

Generate a bearer token:

python -c "import secrets; print(secrets.token_urlsafe(32))"

Step 3 — Run the server

uvicorn main:app --host 0.0.0.0 --port 8001 --reload

Step 4 — Health check

curl http://localhost:8001/health

Step 5 — Test a tool

curl http://localhost:8001/mcp/call \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer <<<REPLACE_WITH_YOUR_BEARER_TOKEN>>>" \
  -d '{"tool": "list_tables", "parameters": {}}'

Step 6 — Test with MCP Inspector

npx @modelcontextprotocol/inspector --server-url http://localhost:8001/mcp --transport http

Related MCP server: FastAPI Database MCP Server

Tools

Changelog

• v1.1 — Fixed get_suppliers + get_price_types table names. Added <<>> placeholders.

• v1.0 — Initial build. Read-only, 6 tools, Bearer token auth.