MotherDuck MCP Server

This MCP server integrates MotherDuck and local DuckDB, enabling SQL analytics for Claude. It offers hybrid execution, querying data from both cloud-based MotherDuck and local DuckDB instances. Cloud storage integration allows access to data in Amazon S3 via MotherDuck. Data sharing is facilitated through database creation and sharing. Users can leverage DuckDB's SQL dialect to query data of any size directly from Claude, all within a serverless architecture.

The server provides a duckdb-motherduck-initial-prompt and a query tool, which accepts a SQL query as input. To get started, a MotherDuck account and access token are required, along with uv. For Claude Desktop integration, the claude_desktop_config.json needs configuration with the server command and arguments, including the MotherDuck token. Example queries include creating databases, querying local files, joining data sources, and analyzing S3 data. The server can be tested manually by specifying the database path. It can also be run in SSE mode using supergateway. The server is licensed under the MIT License.