switch_database_connection

MCP tool from MCP Server Motherduck by motherduckdb

Switch to different database

How to use it

Project documentation lists switch_database_connection for the MCP Server Motherduck MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install MCP Server Motherduck

claude mcp add --scope user duckdb --transport stdio -- uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases

FULL MCP SERVER MOTHERDUCK LISTING

Other tools in MCP Server Motherduck (4)

execute_query

Execute SQL query (DuckDB dialect)

list_columns

List columns of a table/view

list_databases

List all databases (useful for MotherDuck or multiple attached DBs)

list_tables

List tables and views