DuckDB MCP Server
by boettiger-lab
SQL analytics capabilities for local and S3-backed DuckDB databases, enabling AI assistants to perform complex data queries.
What it does
This server connects AI assistants to DuckDB, providing powerful SQL analytics capabilities for local database files, in-memory databases, or data stored in Amazon S3. It allows the AI to execute complex queries and analyze large datasets directly.
Tools
query: Execute a SQL query on the DuckDB database to retrieve or manipulate data.
Installation
Add the following to your claude_desktop_config.json:
{
"mcpServers": {
"duckdb": {
"command": "uvx",
"args": [
"mcp-server-duckdb",
"--db-path",
":memory:"
]
}
}
}
Supported hosts
- Claude Desktop
- Cursor
- VS Code
- Claude Code
Quick install
uvx mcp-server-duckdb --db-path :memory:Information
- Pricing
- free
- Published
- 6/9/2026
- stars
- 0
Categories
Choose your AI client and follow the steps below.
Cursor
{
"mcpServers": {
"duckdb": {
"command": "uvx",
"args": [
"mcp-server-duckdb",
"--db-path",
":memory:"
]
}
}
}Claude Desktop
{
"mcpServers": {
"duckdb": {
"command": "uvx",
"args": [
"mcp-server-duckdb",
"--db-path",
":memory:"
]
}
}
}VS Code Copilot
{
"mcp": {
"servers": {
"duckdb": {
"command": "uvx",
"args": [
"mcp-server-duckdb",
"--db-path",
":memory:"
]
}
}
}
}Related Apps
DiffSitter MCP
MCP ServerAI-powered structural code navigation using tree-sitter ASTs for semantic understanding across 14+ languages.
OpenAI Apps SDK Examples
MCP AppOfficial example gallery of interactive MCP widgets for ChatGPT — 3D viewers, maps, carousels, shopping carts, and more.
Human MCP
MCP ServerGive AI agents human-like senses: visual analysis, image/video generation, speech synthesis, browser automation, and advanced reasoning — 29 MCP tools in one se
Shopify MCP Server
MCP ServerDirect interaction with Shopify store data via GraphQL API for managing products, customers, and orders.
Git MCP Server
MCP ServerFull-featured Git MCP server exposing 28 tools for AI agents to clone, commit, branch, diff, merge, rebase, and more via STDIO or Streamable HTTP.
CodexPotter
MCP ServerAutonomous reconciliation loop that drives Codex to align your codebase with instructed states.
Smart Coding MCP
MCP ServerSemantic code search for AI assistants using local embeddings — find code by meaning, not just keywords.
Snowflake MCP Server
MCP ServerDirect Snowflake database interaction via MCP, enabling AI to run SQL queries, explore schemas, and manage data insights.