mcp-server-duckdb vs filesystem

Side-by-side comparison to help you pick between these two MCP servers.

	mcp-server-duckdb by ktanaka101	filesystem by modelcontextprotocol
Stars	★ 176	★ 85,748
30d uses	—	—
Score	42	77
Official	—	✓
Categories	DatabaseDeveloper ToolsAI / LLM Tools	File SystemDeveloper ToolsProductivity
Language	Python	TypeScript
Last commit	13 mo ago	this month

mcp-server-duckdb · Summary

MCP server for DuckDB database interaction, enabling SQL query execution through MCP tools.

filesystem · Summary

A feature-rich MCP server for filesystem operations with dynamic directory access control.

mcp-server-duckdb · Use cases

Enabling LLMs to query and analyze local DuckDB databases without direct database access
Facilitating data exploration and analysis through natural language SQL generation
Providing a secure read-only interface for database inspection in sensitive environments

filesystem · Use cases

Enable AI models to read and write project files during development
Allow Claude or other MCP clients to browse and analyze codebases
Provide secure sandboxed access to specific directories for content generation

mcp-server-duckdb · Install

Installation

Via Smithery

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

Claude Desktop Integration

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "duckdb": {
      "command": "uvx",
      "args": [
        "mcp-server-duckdb",
        "--db-path",
        "~/mcp-server-duckdb/data/data.db"
      ]
    }
  }
}

Requirements

Python with uv package manager
DuckDB Python package

filesystem · Install

Installation

Using NPX

{
  "mcpServers": {
    "filesystem": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-filesystem",
        "/path/to/allowed/directory"
      ]
    }
  }
}

Using Docker

{
  "mcpServers": {
    "filesystem": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "--mount", "type=bind,src=/path/to/allowed/dir,dst=/projects/allowed/dir",
        "mcp/filesystem",
        "/projects"
      ]
    }
  }
}

VS Code Extension

Click the installation buttons in the README to install directly in VS Code.

Comparison generated from public README + GitHub signals. Last updated automatically.