mcp-server-duckdb
Overview
what is mcp-server-duckdb?
The mcp-server-duckdb is a Model Context Protocol (MCP) server implementation for DuckDB, designed to facilitate database interactions through various MCP tools. It allows users to perform operations such as querying, table creation, and schema inspection on a DuckDB database.
how to use mcp-server-duckdb?
To use the mcp-server-duckdb, install it via Smithery and configure it in the Claude Desktop application. You can execute SQL commands through the provided tools to interact with the DuckDB database.
key features of mcp-server-duckdb?
- Execute SELECT, INSERT, UPDATE, and DELETE queries.
- Create new tables and list existing tables in the database.
- Retrieve schema information for specific tables.
- Operate in read-only mode to maintain data integrity.
use cases of mcp-server-duckdb?
- Performing data analysis using SQL queries on DuckDB.
- Integrating with applications that require database interactions.
- Debugging and inspecting database operations through the MCP Inspector.
FAQ from mcp-server-duckdb?
- Can I run the server in read-only mode?
Yes! You can run the server in read-only mode to prevent any write operations.
- What are the prerequisites for installation?
You need Python with the
uvpackage manager and the DuckDB Python package.
- How can I debug the server?
Use the MCP Inspector for a better debugging experience.
Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.
Playwright McpPlaywright MCP server
Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题；
Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code
TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.
WindsurfThe new purpose-built IDE to harness magic
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.
Amap Maps高德地图官方 MCP Server
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs
Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.
Context7Context7 MCP Server -- Up-to-date code documentation for LLMs and AI code editors
ChatWiseThe second fastest AI chatbot™
CursorThe AI Code Editor
BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.
Serper MCP ServerA Serper MCP Server
Tavily Mcp
Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.
DeepChatYour AI Partner on Desktop