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 3 days ago. It has 164 GitHub stars.

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+.

164 GitHub PyPI

No known CVEs

MIT license

Actively maintained

Last commit 3d ago

Works with most clients

Transport: stdio, sse, http

0 tools

Grade F

MCPpedia last refreshed this data 2d 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.

Loading README…

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 3 days ago. It has 164 GitHub stars.

Similar servers

Others in data / devops

View all →

Dbhub96

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

3.9k 2

Supabase MCP Server96

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

3.0k 4

Mcp Gitlab96

MCP server for using the GitLab API

2.1k 12

Vibe Assistant95

A cross-platform desktop application for managing AI Agents and MCP Servers. 一款用于管理AI智能体与MCP服务器的跨平台桌面应用程序。

169 3

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?

Edit this pageView history

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

Test This Server

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

README

MCP-PostgreSQL-Ops

Give Claude and other AI assistants read-only PostgreSQL observability for slow queries, locks, bloat, VACUUM, indexes, replication, WAL, and capacity.

What is MCP-PostgreSQL-Ops?

MCP-PostgreSQL-Ops lets Claude, OpenWebUI, and other MCP clients inspect a PostgreSQL server through natural-language questions. It turns requests such as “Which tables need VACUUM now?” into predefined, read-only SQL queries and returns the evidence needed to diagnose the database.

Read-only tools: no arbitrary SQL execution or data-changing operations.
PostgreSQL 12–18: version-specific views and columns are detected automatically.
Useful without extensions: core monitoring works immediately; pg_stat_statements and pg_stat_monitor add query analytics.
Deployment choice: install a Claude Desktop extension, run with uvx, or connect OpenWebUI directly to the HTTP MCP server.

For an AI-generated code walkthrough, use .

What can you ask?

Show the current active connections and blocked sessions
Which queries consume the most execution time?
Find bloated tables and explain what needs attention first
Which tables need VACUUM or autovacuum tuning?
Show unused or inefficient indexes
Check replication, WAL, checkpoints, and background processes
Summarize database size, growth, and I/O activity
Draw the relationships for the ecommerce schema

More requests to try: see Example Queries for requests by area (performance, health checks, capacity and VACUUM, structure, troubleshooting, multi-step workflows) and per-tool examples.

Core tools work with normal catalog access. Broader cross-database visibility depends on the PostgreSQL role; use a least-privilege monitoring account in production.

Example: slow-query evidence and recommendations

More examples are available in the screenshots and usage wiki.

Quick Start

Choose one path. If you already have PostgreSQL and Claude Desktop, Option A is the shortest. Option B provides a complete local demonstration with sample databases and OpenWebUI.

Option A: Claude Desktop extension (fastest)

Requirements: Claude Desktop with extension support and a PostgreSQL server reachable from the computer running Claude Desktop.

Open the latest GitHub Release and download mcp-postgresql-ops-<version>.mcpb.
In Claude Desktop, open Settings → Extensions → Advanced settings → Install Extension… and select the downloaded file.
Enter the PostgreSQL host, port, use

... View full README on GitHub

Loading README…

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 3 days ago. It has 164 GitHub stars.