duckdb
pipStandardMCP server for DuckDB. Provides SQL query execution, table management, and data retrieval. Connects directly to DuckDB databases. Useful for developers needing embedded analytics, local data processing, or lightweight database operations.
173230Updated 9 months ago
Overview
MCP server for DuckDB. Provides SQL query execution, table management, and data retrieval. Connects directly to DuckDB databases. Useful for developers needing embedded analytics, local data processing, or lightweight database operations.
Installation
1Install the package
pip
pip install mcp-server-duckdb2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"ktanaka101-mcp-server-duckdb-github": {
"command": "uvx",
"args": [
"pip install mcp-server-duckdb"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from duckdb?"
Prerequisites
- Python 3.10 or higher
- pip or uv package manager
- Claude Desktop or Claude API access
Configuration
No configuration required. This server works out of the box.
Usage Examples
List Resources
"What resources are available in duckdb?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in duckdb"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in duckdb with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with duckdb
Related skills
Browse all skillsNeed help with MCP integration?
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.