Description

PostgreSQL operations MCP server by JungJungIn that provides AI assistants with direct database access through asyncpg and psycopg2 connections, offering query execution, database introspection, and performance monitoring capabilities. The implementation includes specialized functions for PostgreSQL extensions like pg_stat_statements and pg_stat_monitor for query performance analysis, along with utility functions for formatting database results into human-readable tables with automatic byte and duration formatting. Built with Docker support and both stdio and HTTP transport options, it serves developers needing conversational database administration, data analysts requiring ad-hoc query capabilities, and database administrators who want AI-assisted performance monitoring and troubleshooting workflows.

🔬 Playground

Try PostgreSQL Ops live in the browser with security context.
⚪
Unverified
No automated security scan has been run on this server yet.

Installation 

npx -y mcp-postgresql-ops
npm install mcp-postgresql-ops
git clone https://github.com/call518/mcp-postgresql-ops

Claude Desktop Configuration

Add this configuration to your Claude Desktop config file to enable this MCP server:

Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json

Config file location: %APPDATA%\Claude\claude_desktop_config.json

Config file location: ~/.config/Claude/claude_desktop_config.json

claude_desktop_config.json 
{
  "mcpServers": {
    "postgresql-ops": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-postgresql-ops"
      ]
    }
  }
}

Community Reviews

Authenticated reviews from GitHub users. No anonymous submissions. Your experience helps others choose wisely.

—
★★★★★
0 reviews
5★
0
4★
0
3★
0
2★
0
1★
0

No reviews yet. Be the first to share your experience.