DuckDB MCP

Opens a local DuckDB database and exposes SQL over it, including files as views. That makes it the cheapest way to let an agent analyse a data dump on a laptop: no warehouse, no…

Community stdio Verified 2026-11-12 databaseanalyticslocalsql

Use it for

Local analysis over a folder of parquet or CSV files

Skip it if

Production endpoints — DuckDB is a local engine

What it is

Opens a local DuckDB database and exposes SQL over it, including files as views. That makes it the cheapest way to let an agent analyse a data dump on a laptop: no warehouse, no credentials, no network. The bound is equally clear — whatever is on the machine is what it can see.

Install

Terminal
uvx duckdb-mcp

Client configuration

Paste this into your MCP client config, then restart the client.

MCP client config (JSON)
{
  "mcpServers": {
    "avbbc": {
      "command": "npx",
      "args": ["-y", "uvx duckdb-mcp"]
    }
  }
}

Overlapping servers

All servers
  • 01
    PostHog MCPOfficial

    Queries PostHog for events, funnels, and cohorts through a project-scoped API key. The useful pattern is a question translated into one existing query, not free expl…

    #analytics#product#data
    TypeScriptstdio
  • 02
    Amplitude MCPCommunity

    Reads Amplitude charts and cohort data through the dashboard API: event segmentation, funnel results, and retention curves. It is a reporting interface rather than a…

    #analytics#product#retention
    TypeScriptstdio
  • 03
    ClickHouse MCPCommunity

    Runs SQL against a ClickHouse database with a read-only user: table listing, schema inspection, and query execution. The natural fit is event data where an agent can…

    #database#analytics#sql
    Pythonstdio

Tools that use this server

All tools

Skills built around it

All skills