mcp-server-duckdb

[](https://pypi.org/project/mcp-server-duckdb/) [](LICENSE) [](https://smithery.ai/server/mcp-server-duckdb)

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.

<a href="https://glama.ai/mcp/servers/fwggl49w22"></a>

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

Currently, no custom resources are implemented.

Currently, no custom prompts are implemented.

The server implements the following database interaction tool:

• query: Execute any SQL query on the DuckDB database
• Input: query (string) - Any valid DuckDB SQL statement
• Output: Query results as text (or success message for operations like CREATE/INSERT)

> [!NOTE] > The server provides a single unified query function rather than separate specialized functions, as modern LLMs can generate appropriate SQL for any database operation (SELECT, CREATE TABLE, JOIN, etc.) without requiring separate endpoints.

> [!NOTE] > When the server is running in readonly mode, DuckDB's native readonly protection is enforced. > This ensures that the Language Model (LLM) cannot perform any write operations (CREATE, INSERT, UPDATE, DELETE), maintaining data integrity and preventing unintended changes.

• db-path (string): Path to the DuckDB database file
• The server will