MCP PostgreSQL Ops

Name: MCP PostgreSQL Ops
Author: call518

mcp-postgresql-ops · by call518

🔍Professional MCP server for PostgreSQL operations & monitoring: 30+ extension-independent tools for performance analysis, table bloat detection, autovacuum monitoring, schema introspection, and database management. Supports PostgreSQL 12+.

160 GitHub PyPI

No known CVEs

MIT license

Actively maintained

Last commit 10d ago

Works with most clients

Transport: stdio, sse, http

0 tools

Grade F

MCPpedia last refreshed this data 1d ago

Edit this pageView history

MCP PostgreSQL Ops is an MCP server that 🔍Professional MCP server for PostgreSQL operations & monitoring: 30+ extension-independent tools for performance analysis, table bloat detection, autovacuum monitoring, schema introspection, and database management. Supports PostgreSQL 12+. Its tool list has not been published yet over stdio, sse and http, requires no API key, and scores 63/100 on MCPpedia's security, maintenance and efficiency rubric.

Data DevOps

Step 1

Install in your client

Config is the same across clients - only the file and path differ.

Supported in Claude Desktopstdio, sse, http · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mcp-postgresql-ops": {
      "env": {
        "POSTGRES_DB": "ecommerce",
        "POSTGRES_HOST": "127.0.0.1",
        "POSTGRES_PORT": "15432",
        "POSTGRES_USER": "postgres",
        "POSTGRES_PASSWORD": "changeme!@34"
      },
      "args": [
        "--python",
        "3.12",
        "mcp-postgresql-ops"
      ],
      "command": "uvx"
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/mcp-postgresql-ops)](https://mcppedia.org/s/mcp-postgresql-ops)

Read me

What MCP PostgreSQL Ops does

MCP-PostgreSQL-Ops is a professional MCP server for PostgreSQL database operations, monitoring, and management. Supports PostgreSQL 12-18 with comprehensive database analysis, performance monitoring, and intelligent maintenance recommendations through natural language queries. Most features work independently, but advanced query analysis capabilities are enhanced when pg_stat_statements and (optionally) pg_stat_monitor extensions are installed.

Test This Server

This server supports HTTP transport. Be the first to test it - help the community know if it works.

Scored, not listed

Why this score

Five weighted categories - click any category to see the underlying evidence.

Score breakdown

63/100across 5 weighted dimensions

How we score →

0255075100

−37

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

No known CVEs.

Checked mcp-postgresql-ops against OSV.dev.

Community

Reviews

Be the first to review

Have you used this server?

Share your experience - it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is MCP PostgreSQL Ops safe to use?: MCP PostgreSQL Ops has no known CVEs as of the latest MCPpedia security scan. Authentication requirements were not detected automatically - check the project's documentation before connecting in a shared environment. Licensed under MIT.
How do I install MCP PostgreSQL Ops?: MCP PostgreSQL Ops supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.
What AI clients work with MCP PostgreSQL Ops?: MCP PostgreSQL Ops is compatible with claude-desktop, cursor, claude-code. It uses stdio and sse and http transport.
Is MCP PostgreSQL Ops actively maintained?: MCP PostgreSQL Ops is actively maintained - last commit was 10 days ago. It has 160 GitHub stars.

Similar servers

Others in data / devops

View all →

Supabase MCP Server96

Manage Supabase projects — databases, auth, storage, and edge functions

2.9k 4

Mcp Gitlab96

MCP server for using the GitLab API

2.0k 12

Dbhub96

Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite

3.6k 2

Firecrawl Mcp Server95

MCP server for Firecrawl — web search, scraping, and biomedical/arXiv paper search.

7.5k 4

MCP Security Weekly

Get CVE alerts and security updates for MCP PostgreSQL Ops and similar servers.

Community

Discussion

Start a conversation

Ask a question, share a tip, or report an issue.

Has anyone used this with Cursor?How do you handle auth?Any alternatives?

{ "mcpServers": { "mcp-postgresql-ops": { "env": { "POSTGRES_DB": "ecommerce", "POSTGRES_HOST": "127.0.0.1", "POSTGRES_PORT": "15432", "POSTGRES_USER": "postgres", "POSTGRES_PASSWORD": "changeme!@34" }, "args": [ "--python", "3.12", "mcp-postgresql-ops" ], "command": "uvx" } } }

Frequently Asked Questions

Is MCP PostgreSQL Ops safe to use?

MCP PostgreSQL Ops has no known CVEs as of the latest MCPpedia security scan. Authentication requirements were not detected automatically - check the project's documentation before connecting in a shared environment. Licensed under MIT.

How do I install MCP PostgreSQL Ops?

MCP PostgreSQL Ops supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.

What AI clients work with MCP PostgreSQL Ops?

MCP PostgreSQL Ops is compatible with claude-desktop, cursor, claude-code. It uses stdio and sse and http transport.

Is MCP PostgreSQL Ops actively maintained?

MCP PostgreSQL Ops is actively maintained - last commit was 10 days ago. It has 160 GitHub stars.