Wraps DuckDB's Python API to give Claude direct SQL execution capabilities against local database files. Exposes a single query tool that accepts any DuckDB SQL statement, from SELECT queries to table creation and schema modifications. Supports read-only mode for safe data exploration and persistent connection mode for working with temporary objects. Best reached when you need Claude to analyze local datasets, build data pipelines, or perform complex SQL operations without external database dependencies. Integrates with Claude Desktop via uvx and includes MCP Inspector support for debugging query execution.
claude mcp add --transport stdio ktanaka101-mcp-server-duckdb uvx mcp-server-duckdb