MCP Server — ktanaka101/mcp-server-duckdb

A DuckDB MCP server

Local serverstdioPython

What is the MCP Server?

A DuckDB MCP server

What it actually does

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities through MCP tools. It would be interesting to have LLM analyze it. DuckDB is suitable for local analysis.

This server enables interaction with a DuckDB database through the Model Context Protocol, allowing for database operations like querying, table creation, and schema inspection.

Configuration

  • Python with uv package manager - DuckDB Python package - MCP server dependencies

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
queryExecute any SQL query on the DuckDB database

Configuration

  • Python with uv package manager - DuckDB Python package - MCP server dependencies

Example prompts to try

  • “Use MCP to query.”
  • “Use MCP to Input.”
  • “Use MCP to Output.”

Frequently asked questions

A DuckDB MCP server Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.