execute_query

MCP tool from MCP Server Motherduck by motherduckdb

Execute SQL query (DuckDB dialect)

How to use it

Project documentation lists execute_query 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)

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

switch_database_connection

Switch to different database