D
DuckDB
Run local analytical SQL with DuckDB.
·No reviews yet
Share:
About
Auto-generated
DuckDB is a Model Context Protocol server in the Data & Databases category. It lets AI assistants that speak MCP call its tools and read its resources over STDIO.
Example tools
Illustrative tool names — the actual tool set is defined by the server at runtime.
query
Run a read-only SQL query
list_tables
List tables in the connected database
describe_table
Return column info for a table
Screenshots
No screenshots yet.
Frequently Asked Questions
Common questions about DuckDB.
- What is the DuckDB MCP?
- This MCP allows you to run analytical SQL queries locally using DuckDB. It leverages DuckDB's in-process OLAP database capabilities to execute SQL directly within your environment.
- How can I install the DuckDB MCP?
- The DuckDB MCP is typically installed and configured as part of a client application like Claude Desktop, Cursor, or Cline. Refer to your client's documentation for specific installation instructions and prerequisites.
- Does the DuckDB MCP require authentication credentials?
- No, the DuckDB MCP does not require an API key, OAuth, or any other authentication. It operates without external authentication as it's designed for local execution.
- What core capabilities does the DuckDB MCP provide?
- The DuckDB MCP provides core SQL analytics capabilities. It allows you to execute SQL queries for data analysis and manipulation against local data sources.
- Are there any known limitations or prerequisites for using the DuckDB MCP?
- A key prerequisite for the DuckDB MCP is that it runs locally and is designed for in-process analytics. Therefore, it might not be suitable for large-scale, distributed data processing or multi-user environments without further orchestration.
Install DuckDB
Claude Desktop
Add this to claude_desktop_config.json.
{
"mcpServers": {
"duckdb": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-duckdb"
]
}
}
}Cursor
Add this to ~/.cursor/mcp.json.
{
"mcpServers": {
"duckdb": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-duckdb"
]
}
}
}VS Code
Add this to your workspace settings.json.
{
"mcp.servers": {
"duckdb": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-duckdb"
]
}
}
}Reviews
Sign in to leave a review.
No reviews yet. Be the first!
Discussion(0)
No comments yet.