che-duckdb-mcp
Verified Safeby kiki830621
Overview
Provides an integrated Model Context Protocol (MCP) server for DuckDB documentation search and local database operations.
Installation
~/bin/CheDuckDBMCPSecurity Notes
The `db_query` tool implements a prefix-based validation to restrict query types (SELECT, WITH, SHOW, DESCRIBE, EXPLAIN, PRAGMA) and applies a default row limit (1000). While this prevents direct DDL/DML, it is not a full SQL parser and could potentially allow complex SELECT queries to be resource-intensive or exploit advanced SQL features if not handled by the underlying DuckDB driver. The `db_execute` tool is explicitly for DDL/DML and correctly marked as destructive, requiring explicit intent. Database connections are restricted to local files only, and read-only mode is supported. Documentation is downloaded from a trusted, hardcoded DuckDB URL. No hardcoded secrets or obvious malicious patterns were found in the provided source code.
Similar Servers
apple-health-mcp
Query and analyze personal Apple Health data using SQL for health insights and automated reports.
dbt-mcp
Provides a Model Context Protocol (MCP) server that exposes various dbt-related functionalities (CLI, Semantic Layer, Discovery, Admin API, Code Generation, LSP) as tools for AI agents to interact with dbt projects in Core, Fusion, and Platform environments.
duckdb_mcp
Integrate SQL databases with AI assistants (e.g., Claude) using the Model Context Protocol (MCP) for data querying, tool execution, and resource management.
ddg_search
A Model Context Protocol server for web search using DuckDuckGo and AI-powered answers from IAsk AI, Monica, and Brave AI, designed for integration with AI assistants.