mcp-server-motherduck MCP server
@MCP-Mirror
About mcp-server-motherduck MCP server
Mirror of
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mcp-server-motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
],
"env": {
"motherduck_token": "",
"HOME": ""
}
}
}
}Tools
3Create a connection to either a local DuckDB or MotherDuck and retrieve available databases
Get table schemas from a specific DuckDB/MotherDuck database
Execute a query on the MotherDuck (DuckDB) database
Overview
What is mcp-server-motherduck?
An MCP server for MotherDuck and local DuckDB. It enables AI assistants to initialize a connection, read database schemas, and execute SQL queries on DuckDB or MotherDuck instances.
How to use mcp-server-motherduck?
Configure the server in Claude Desktop by adding the JSON snippet to claude_desktop_config.json. The server is run via uvx mcp-server-motherduck. When using MotherDuck, set the motherduck_token environment variable; also set the HOME variable to your home folder (required by DuckDB).
Key features of mcp-server-motherduck
- Three tools: initialize‑connection, read‑schemas, execute‑query
- One prompt: duckdb‑motherduck‑initial‑prompt
- Initialize a DuckDB (local) or MotherDuck connection
- Read table schemas from a specified database
- Execute arbitrary SQL queries on the connected database
Use cases of mcp-server-motherduck
- Connecting an AI assistant to a local DuckDB for data analysis
- Querying a MotherDuck cloud database through natural language
- Exploring database schemas before running analytical queries
- Automating database initialization and querying in conversational workflows
FAQ from mcp-server-motherduck
What command is used to start the server?
The server is started with uvx mcp-server-motherduck.
How do I authenticate with MotherDuck?
Set the motherduck_token environment variable in the server’s configuration. (See MotherDuck documentation for obtaining the token.)
Where is the Claude Desktop configuration file located?
On macOS: ~/Library/Application Support/Claude/claude_desktop_config.json.
On Windows: %APPDATA%/Claude/claude_desktop_config.json.
What environment variables must be set?
You must set HOME to your home folder (required by DuckDB). When using MotherDuck, also set motherduck_token.
What tools does the server provide?
Three tools: initialize-connection (takes type), read-schemas (takes database_name), and execute-query (takes query).
Frequently asked questions
What command is used to start the server?
The server is started with `uvx mcp-server-motherduck`.
How do I authenticate with MotherDuck?
Set the `motherduck_token` environment variable in the server’s configuration. (See MotherDuck documentation for obtaining the token.)
Where is the Claude Desktop configuration file located?
On macOS: `~/Library/Application Support/Claude/claude_desktop_config.json`. On Windows: `%APPDATA%/Claude/claude_desktop_config.json`.
What environment variables must be set?
You must set `HOME` to your home folder (required by DuckDB). When using MotherDuck, also set `motherduck_token`.
What tools does the server provide?
Three tools: `initialize-connection` (takes type), `read-schemas` (takes database_name), and `execute-query` (takes query).
Basic information
More Other MCP servers
Lemon.io
lemon-ioRequest dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3
AutoBrowser MCP
autobrowser-aiBrowser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser
ghidraMCP
LaurieWiredMCP Server for Ghidra
🚀 Model Context Protocol (MCP) Curriculum for Beginners
microsoftThis open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,
Mcp
browsermcpBrowser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser
Comments