This MCP server connects AI assistants to DuckDB and MotherDuck, providing powerful SQL analytics. It is flexible, supporting local, in-memory, S3, and cloud databases, with read/write access controlled by flags. The default read-only mode reduces risk, but security configurations must be considered when exposing it to third parties.
This is a local MCP server that connects AI assistants to DuckDB or MotherDuck databases. It supports querying local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck. The server allows executing SQL read and write queries, browsing database catalogs, and switching between different database connections on the fly. It runs in read-only mode by default; write access must be explicitly enabled.
{
"mcpServers": {
"DuckDB (in-memory, r/w)": {
"command": "uvx",
"args": [
"mcp-server-motherduck",
"--db-path",
":memory:",
"--read-write",
"--allow-switch-databases"
]
}
}
}