MCP Server LogoMCP Server
MCPsカテゴリディレクトリ投稿する
投稿する
MCPsカテゴリディレクトリ投稿する
投稿する

MCPサーバー

MCPサーバーのリスト、Awesome MCPサーバーとClaude MCP統合を含む。AIの能力を強化するためのMCPサーバーを検索して発見します。

お問い合わせ

[email protected]

MCPサーバーについて

プライバシーポリシー利用規約

リソース

モデルコンテキストプロトコルMCPスターターガイドClaude MCPサーバー

コミュニティ

GitHub

© 2025 mcpserver.cc © 2025 MCPサーバー. 全著作権所有.

プライバシーポリシー利用規約
  1. Home
  2. /Categories
  3. /Data & Storage
  4. /Mcp Server Duckdb
Mcp Server Duckdb

Mcp Server Duckdb

作成者 ktanaka101•4 months ago
サイトを訪問する

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities

Data & Storage
duckdbmcpmcp-server

mcp-server-duckdb

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities through MCP tools. It would be interesting to have LLM analyze it. DuckDB is suitable for local analysis.

mcp-server-duckdb MCP server

Overview

This server enables interaction with a DuckDB database through the Model Context Protocol, allowing for database operations like querying, table creation, and schema inspection.

Components

Resources

Currently, no custom resources are implemented.

Prompts

Currently, no custom prompts are implemented.

Tools

The server implements the following database interaction tools:

  • read-query: Execute SELECT queries to read data from the database

    • Input: query (string) - Must be a SELECT statement
    • Output: Query results as text
  • write-query: Execute INSERT, UPDATE, or DELETE queries to modify data

    • Input: query (string) - Must be a non-SELECT statement
    • Output: Query results as text
  • create-table: Create new tables in the database

    • Input: query (string) - Must be a CREATE TABLE statement
    • Output: Success confirmation message
  • list-tables: List all tables in the database

    • Input: None required
    • Output: List of tables from information_schema
  • describe-table: Get schema information for a specific table

    • Input: table_name (string) - Name of the table to describe
    • Output: Table schema information

Note: When the server is running in readonly mode, the following tools are disabled to prevent any write operations:

  • write-query
  • create-table

This ensures that the Language Model (LLM) cannot perform any modifications to the database, maintaining data integrity and preventing unintended changes.

Configuration

Required Parameters

  • db-path (string): Path to the DuckDB database file
    • The server will automatically create the database file and parent directories if they don’t exist

Optional Parameters

  • –readonly: Run server in read-only mode
    • Description: When this flag is set, the server operates in read-only mode. This means:
      • The DuckDB database will be opened with read_only=True, preventing any write operations.
      • If the specified database file does not exist, it will not be created.
      • Security Benefit: Prevents the Language Model (LLM) from performing any write operations, ensuring that the database remains unaltered.
    • Reference: For more details on read-only connections in DuckDB, see the DuckDB Python API documentation.

Installation

Installing via Smithery

To install DuckDB Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install mcp-server-duckdb --client claude

Claude Desktop Integration

Configure the MCP server in Claude Desktop’s configuration file:

MacOS

Location: ~/Library/Application Support/Claude/claude_desktop_config.json

Windows

Location: %APPDATA%/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "duckdb": {
      "command": "uvx",
      "args": [
        "mcp-server-duckdb",
        "--db-path",
        "~/mcp-server-duckdb/data/data.db"
      ]
    }
  }
}
  • Note: ~/mcp-server-duckdb/data/data.db should be replaced with the actual path to the DuckDB database file.

Development

Prerequisites

  • Python with uv package manager
  • DuckDB Python package
  • MCP server dependencies

Debugging

Debugging MCP servers can be challenging due to their stdio-based communication. We recommend using the MCP Inspector for the best debugging experience.

Using MCP Inspector

  1. Install the inspector using npm:
npx @modelcontextprotocol/inspector uv --directory ~/mcp-server-duckdb run mcp-server-duckdb
  1. Open the provided URL in your browser to access the debugging interface

The inspector provides visibility into:

  • Request/response communication
  • Tool execution
  • Server state
  • Error messages

前提条件

  • •サーバーのドメインに精通している
  • •関連技術の基本的な理解
  • •Data & Storageの知識

おすすめのサーバー

Mcp Qdrant Memory

Mcp Qdrant Memory

MCP server providing a knowledge graph implementation with semantic search capabilities powered by Qdrant vector database

Ragdocs

Ragdocs

MCP server for RAG-based document search and management

Logseq Mcp

Logseq Mcp

simple logseq mcp server

もっと見る → →

詳細

作成日

March 07, 2025

最終更新日

March 07, 2025

カテゴリー

Data & Storage

作成者

ktanaka101

シェアする

もっと見る

Mcp Gmail Gas

Mcp Gmail Gas

Mcp Taskwarrior

Mcp Taskwarrior

A simple MCP Server for Taskwarrior

Mcp Pubmed Server

Mcp Pubmed Server

PubMed MCP Server for accessing research papers

Sourcesyncai Mcp

Sourcesyncai Mcp