general MCP Server
Local MCP server for DuckDB and MotherDuck
Discovered via unknown and last synced 1w ago.
1. Install the package
uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases
2. Add to claude_desktop_config.json
{
"mcpServers": {
"mcp-server-motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck",
"--db-path",
":memory:",
"--read-write",
"--allow-switch-databases"
]
}
}
}Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) / %APPDATA%\Claude\claude_desktop_config.json (Windows)
Requires local installation
For protocol compatibility only (e.g. with [AWS Bedrock AgentCore Runtime](https://docs.aws.amazon.com/bedrock-agentcore/latest/devguide/runtime-mcp-protocol-contract.html)). Server still maintains global state via the shared DatabaseClient.
Port for HTTP transport
List columns of a table/view
Use temporary connections for read-only local files
List all databases (useful for MotherDuck or multiple attached DBs)
Max characters returned
AWS secret key for S3 database connections
Execute SQL query (DuckDB dialect)
Max rows returned
AWS access key for S3 database connections
List tables and views
SQL to execute on startup
`create_if_not_exists`
Transport type: `stdio` or `http`
AWS endpoint for S3 connections
Config Location
Description
Default
Description
Used by DuckDB for extensions and config. Override with `--home-dir` if not set.
AWS region for S3 connections
Execute a SQL query on the DuckDB or MotherDuck database
`query` (string, required): The SQL query to execute
AWS session token for temporary credentials (IAM roles, SSO, EC2 instance profiles)