list_columns

MCP tool from MCP Server Motherduck by motherduckdb

List columns of a table/view

How to use it

list_columns is exposed by the MCP Server Motherduck MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the list_columns 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)

execute_query

Execute SQL query (DuckDB dialect)

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