mcp-server-motherduck
by MCP-Mirror
An MCP server for MotherDuck and local DuckDB. It provides tools to initialize connections, read schemas, and execute queries.
Last updated: N/A
What is mcp-server-motherduck?
This is an MCP (Model Context Protocol) server designed to facilitate interaction with MotherDuck and local DuckDB databases. It allows users to connect to these databases and execute queries through the MCP framework.
How to use mcp-server-motherduck?
To use this server, add the provided configuration snippet to your Claude Desktop config file. Ensure that the HOME environment variable is set correctly. For MotherDuck, you also need to set the motherduck_token environment variable. The server provides prompts and tools that can be used within the MCP environment.
Key features of mcp-server-motherduck
Initializes connections to DuckDB and MotherDuck
Retrieves available databases
Gets table schemas from databases
Executes queries on the database
Use cases of mcp-server-motherduck
Querying MotherDuck databases from Claude Desktop
Accessing local DuckDB databases from Claude Desktop
Integrating database access into MCP workflows
Automating database interactions through MCP
FAQ from mcp-server-motherduck
What is MotherDuck?
What is MotherDuck?
MotherDuck is a cloud-based data warehouse built on DuckDB.
What is DuckDB?
What is DuckDB?
DuckDB is an in-process SQL OLAP database management system.
How do I get a MotherDuck token?
How do I get a MotherDuck token?
You can obtain a MotherDuck token from the MotherDuck website after creating an account.
Where do I find the Claude Desktop config file?
Where do I find the Claude Desktop config file?
The config file is located at ~/Library/Application Support/Claude/claude_desktop_config.json on MacOS and %APPDATA%/Claude/claude_desktop_config.json on Windows.
What is the MIT License?
What is the MIT License?
The MIT License is a permissive free software license, allowing you to use, modify, and distribute the software with few restrictions.