{"library":"mcp-server-motherduck","title":"MotherDuck Connector Protocol Server","description":"This is a sample implementation of the MotherDuck Connector Protocol (MCP) server that allows DuckDB clients to connect to MotherDuck or local DuckDB instances via a lightweight HTTP server. It's built on FastAPI. The current version is 1.0.4, and its release cadence is tied to updates in the MCP specification or the underlying DuckDB/MotherDuck APIs, serving primarily as a reference and bridge.","language":"python","status":"active","last_verified":"Thu Apr 16","install":{"commands":["pip install mcp-server-motherduck"],"cli":{"name":"mcp-server-motherduck","version":"Usage: mcp-server-motherduck [OPTIONS]"}},"imports":["from mcp_server_motherduck.main import app"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import os\n\n# Set environment variables for MotherDuck (or DUCKDB_PATH for local DuckDB)\n# For local DuckDB: os.environ['DUCKDB_PATH'] = '/path/to/my_local.duckdb'\n# For MotherDuck: os.environ['MD_TOKEN'] = os.environ.get('MD_TOKEN', 'YOUR_MOTHERDUCK_TOKEN')\n\nprint(\"To run the MCP server:\")\nprint(\"1. Ensure mcp-server-motherduck and uvicorn are installed: pip install mcp-server-motherduck uvicorn[standard]\")\nprint(\"2. Run the server from your terminal:\")\nprint(\"   uvicorn mcp_server_motherduck.main:app --host 0.0.0.0 --port 8000\")\nprint(\"\\nOnce running, you can connect using the DuckDB CLI:\")\nprint(\"   duckdb 'md:http://localhost:8000/'\")\nprint(\"   -- or if using a local DuckDB file --\")\nprint(\"   duckdb 'md:http://localhost:8000/?duckdb_path=/path/to/my_local.duckdb'\")","lang":"python","description":"This quickstart demonstrates how to run the MCP server using `uvicorn` and how to connect to it using the DuckDB CLI. You must have `uvicorn[standard]` installed alongside `mcp-server-motherduck`. Remember to configure MotherDuck via `MD_TOKEN` or a local DuckDB path via `DUCKDB_PATH` environment variables.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}