# DuckDB / MotherDuck Local MCP
> Local MCP server for running DuckDB SQL against in-memory or local databases, S3-hosted databases, and MotherDuck.
Canonical: https://www.mcpfolio.com/servers/motherduck-duckdb
Last updated: 2026-10-28
## Catalog record

- Publisher: MotherDuck
- Categories: database, memory

## Website

https://motherduck.com/

## Repository

https://github.com/motherduckdb/mcp-server-motherduck

## Transports

stdio and Streamable HTTP

## Authentication

MotherDuck connections require a MotherDuck token via motherduck_token or MOTHERDUCK_TOKEN. Local DuckDB can run without this token.

## Tools

- **execute_query**: See official README. switch_database_connection requires --allow-switch-databases.
- **list_databases**: See official README. switch_database_connection requires --allow-switch-databases.
- **list_tables**: See official README. switch_database_connection requires --allow-switch-databases.
- **list_columns**: See official README. switch_database_connection requires --allow-switch-databases.
- **switch_database_connection**: See official README. switch_database_connection requires --allow-switch-databases.

## Sources

- [official_repository_readme](https://github.com/motherduckdb/mcp-server-motherduck)

## Setup

Use the interactive setup panel on [the detail page](https://www.mcpfolio.com/servers/motherduck-duckdb) to view instructions for each supported client.