Skip to content
  1. Home
  2. MCP servers
  3. DuckDB / MotherDuck Local MCP Server

DuckDB / MotherDuck Local MCP Server

Run analytical SQL on local DuckDB files, in-memory data or MotherDuck

What it is

A local server that hands an agent DuckDB's SQL engine. It can open DuckDB files, in-memory databases, databases on S3 or a MotherDuck account, browse catalogs and switch connections mid-session. Handy for ad-hoc analysis of CSV and Parquet files.

Good for

  • Analyse CSV or Parquet files with SQL
  • Query a local DuckDB database
  • Run queries against MotherDuck

Install or run

claude mcp add --scope user duckdb --transport stdio -- uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases

Command as given in the project README. Read the repository before you run anything on your machine.

What you need

uv; a MotherDuck token only when connecting to MotherDuck

Worth knowingMotherDuck also offers a separate fully managed remote server; this repo is the local one.

Sources

The summary is ours, written from the README. Spotted an error? See how we work.

More for data & research

See the topic →
  • MCP Toolbox for Databases

    googleapis/mcp-toolbox

    Google's server and framework for connecting agents to SQL databases

    MCP serverGitHub stars: 17k
  • Firecrawl MCP Server

    firecrawl/firecrawl-mcp-server

    Web search, scraping, crawling and page interaction returning clean Markdown

    MCP serverGitHub stars: 7.8k
  • Exa MCP Server

    exa-labs/exa-mcp-server

    Hosted web search, page fetching and research tools from Exa

    MCP serverGitHub stars: 5.2k
  • Flint

    microsoft/flint-chart

    Chart spec language and MCP server for agent-made visualisations

    MCP serverGitHub stars: 4.6k