motherduckdb_mcp-server-motherduck

motherduckdb_mcp-server-motherduck

0
databases

MCP Server MotherDuck is designed to facilitate working with MotherDuck and DuckDB databases through establishing connections, retrieving data schemas, and executing queries. It includes tools and prompts for easy integration, particularly with Claude Desktop.

MCP Server MotherDuck

An MCP server for MotherDuck and local DuckDB.

Components

Prompts

  • duckdb-motherduck-initial-prompt: A prompt to initialize a connection to DuckDB or MotherDuck.

Tools

  • initialize-connection: Create a connection to either a local DuckDB or MotherDuck and retrieve available databases.
  • read-schemas: Get table schemas from a specific DuckDB/MotherDuck database.
  • execute-query: Execute a query on the MotherDuck (DuckDB) database.

Usage with Claude Desktop

Instructions for configuring the server with Claude Desktop on MacOS and Windows.