mcp-server-duckdb

The mcp-server-duckdb is an implementation of the Model Context Protocol designed specifically for DuckDB, enabling seamless database interactions. Users can perform various database operations such as querying, table creation, and schema inspection through a unified query function. This simplifies the process of executing SQL commands without the need for multiple endpoints, leveraging modern language models' capabilities to generate appropriate SQL for any operation. In readonly mode, the server enforces DuckDB's native readonly protection, ensuring that no write operations can be performed. This feature maintains data integrity and prevents unintended changes, making it suitable for environments where data security is a priority. Overall, this server provides a robust solution for those looking to utilize DuckDB within the Model Context Protocol framework.

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