MCP Public
Sign in
D

DuckDB

Run local analytical SQL with DuckDB.

·No reviews yet
Repo
Share:

About

Auto-generated

DuckDB is a Model Context Protocol server in the Data & Databases category. It lets AI assistants that speak MCP call its tools and read its resources over STDIO.

Example tools

Illustrative tool names — the actual tool set is defined by the server at runtime.

query
Run a read-only SQL query
list_tables
List tables in the connected database
describe_table
Return column info for a table

Screenshots

No screenshots yet.

Frequently Asked Questions

Common questions about DuckDB.

What is the DuckDB MCP?
This MCP allows you to run analytical SQL queries locally using DuckDB. It leverages DuckDB's in-process OLAP database capabilities to execute SQL directly within your environment.
How can I install the DuckDB MCP?
The DuckDB MCP is typically installed and configured as part of a client application like Claude Desktop, Cursor, or Cline. Refer to your client's documentation for specific installation instructions and prerequisites.
Does the DuckDB MCP require authentication credentials?
No, the DuckDB MCP does not require an API key, OAuth, or any other authentication. It operates without external authentication as it's designed for local execution.
What core capabilities does the DuckDB MCP provide?
The DuckDB MCP provides core SQL analytics capabilities. It allows you to execute SQL queries for data analysis and manipulation against local data sources.
Are there any known limitations or prerequisites for using the DuckDB MCP?
A key prerequisite for the DuckDB MCP is that it runs locally and is designed for in-process analytics. Therefore, it might not be suitable for large-scale, distributed data processing or multi-user environments without further orchestration.

Install DuckDB

Claude Desktop

Add this to claude_desktop_config.json.

{
  "mcpServers": {
    "duckdb": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-duckdb"
      ]
    }
  }
}

Cursor

Add this to ~/.cursor/mcp.json.

{
  "mcpServers": {
    "duckdb": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-duckdb"
      ]
    }
  }
}

VS Code

Add this to your workspace settings.json.

{
  "mcp.servers": {
    "duckdb": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-duckdb"
      ]
    }
  }
}

Reviews

Sign in to leave a review.

No reviews yet. Be the first!

Discussion(0)

Sign in to join the discussion.

No comments yet.