execute_query

MCP tool from MCP Server Motherduck by motherduckdb

Execute SQL query (DuckDB dialect)

How to use it

execute_query is exposed by the MCP Server Motherduck MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the execute_query tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

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