Schema | MotherDuck DuckDB MCP Server

MotherDuck DuckDB MCP Server

Describes the environment variables required to run the server.

Name	Required	Description
`motherduck_token`	No	Access token for MotherDuck. Used as default for --motherduck-token if not provided.
`AWS_ACCESS_KEY_ID`	No	AWS access key ID for S3 connections.
`AWS_SESSION_TOKEN`	No	AWS session token for temporary credentials (SSO).
`AWS_DEFAULT_REGION`	No	AWS default region for S3 connections.
`AWS_SECRET_ACCESS_KEY`	No	AWS secret access key for S3 connections.

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
queryA	Use this to execute a query on the MotherDuck or DuckDB database

Interactive templates invoked by user choice

Name	Description
`duckdb-motherduck-initial-prompt`	A prompt to initialize a connection to duckdb or motherduck and start working with it

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/fastmcp-me/mcp-server-motherduck'

If you have feedback or need assistance with the MCP directory API, please join our Discord server