filesystem vs pgmcp

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

	filesystem by modelcontextprotocol	pgmcp by subnetmarco
Stars	★ 85,748	★ 529
30d uses	—	—
Score	77	49
Official	✓	—
Categories	File SystemDeveloper ToolsProductivity	DatabaseDeveloper ToolsAI / LLM Tools
Language	TypeScript	Go
Last commit	this month	8 mo ago

filesystem · Summary

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

pgmcp · Summary

PGMCP is a production-ready MCP server that enables natural language queries to any PostgreSQL database with proper security controls.

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

pgmcp · Use cases

Business analysts can query e-commerce databases using natural language instead of writing complex SQL
Developers can quickly explore unfamiliar database schemas during development and debugging
Teams can share database access with non-technical stakeholders through AI assistants

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.

pgmcp · Install

Installation

Download Pre-compiled Binaries

Go to [GitHub Releases](https://github.com/subnetmarco/pgmcp/releases)
Download the binary for your platform (Linux, macOS, Windows)
Extract and run:

# Example for macOS/Linux
tar xzf pgmcp_*.tar.gz
cd pgmcp_*
./pgmcp-server

Homebrew (macOS/Linux)

brew tap subnetmarco/homebrew-tap
brew install pgmcp

Environment Variables

export DATABASE_URL="postgres://user:password@localhost:5432/your-existing-db"
export OPENAI_API_KEY="your-api-key"
./pgmcp-server

Claude Desktop Integration

Edit ~/.config/claude-desktop/claude_desktop_config.json:

{
  "mcpServers": {
    "pgmcp": {
      "transport": {
        "type": "http",
        "url": "http://localhost:8080/mcp"
      }
    }
  }
}

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