Is MCP PostgreSQL Ops safe to use?

MCP PostgreSQL Ops has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. 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 149 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+.

149 0 tools 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

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

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

61/100across 5 weighted dimensions

How we score →

0255075100

−39

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. It does not require authentication, so any local process can connect — keep this in mind in shared environments. 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 149 GitHub stars.

Similar servers

Others in data / devops

View all →

PostgreSQL MCP Server98

Query and manage PostgreSQL databases directly from AI assistants

86.4k 1

Mcp Gitlab96

MCP server for using the GitLab API

1.6k 12

Firecrawl Mcp Server95

🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.

6.4k 4

Supabase MCP Server95

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

2.7k 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?

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 Server for PostgreSQL Operations and Monitoring

Architecture & Internal (DeepWiki)

Overview

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.

Features

✅ Zero Configuration: Works with PostgreSQL 12-18 out-of-the-box with automatic version detection.
✅ Natural Language: Ask questions like "Show me slow queries" or "Analyze table bloat."
✅ Production Safe: Read-only operations, RDS/Aurora compatible with regular user permissions.
✅ Extension Enhanced: Optional pg_stat_statements and pg_stat_monitor for advanced query analytics.
✅ Comprehensive Database Monitoring: Performance analysis, bloat detection, and maintenance recommendations.
✅ Smart Query Analysis: Slow query identification with pg_stat_statements and pg_stat_monitor integration.
✅ Schema & Relationship Discovery: Database structure exploration with detailed relationship mapping.
✅ VACUUM & Autovacuum Intelligence: Real-time maintenance monitoring and effectiveness analysis.
✅ Multi-Database Operations: Seamless cross-database analysis and monitoring.
✅ Enterprise-Ready: Safe read-only operations with RDS/Aurora compatibility.
✅ Developer-Friendly: Simple codebase for easy customization and tool extension.

🔧 Advanced Capabilities

Version-aware I/O statistics (enhanced on PostgreSQL 16+, byte columns on PG 18+).
Real-time connection and lock monitoring.
Background process and checkpoint analysis.
Replication status and WAL monitoring.
Database capacity and bloat analysis.
Wait event catalog with descriptions (PG 17+).
WAL summarizer monitoring for incremental backups (PG 17+).
Async I/O subsystem monitoring (PG 18+).
Per-backend I/O and WAL statistics (PG 18+).

Tool Usage Examples

📸 More Examples with Screenshots →

⭐ Quickstart (5 minutes)

Note: The postgresql container included in docker-compose.yml is intended for quickstart testing purposes only. You can connect to your own PostgreSQL instance by adjusting the environment variables as needed.

If you want to use your own PostgreSQL instance instead of the built-in test container:

Update the target PostgreSQL connection information in your .env file (see POSTGRES_HOST, POSTGRES_PORT, POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DB).

In `docker-compose.ym

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

61/100across 5 weighted dimensions

How we score →

0255075100

−39

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. It does not require authentication, so any local process can connect — keep this in mind in shared environments. 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 149 GitHub stars.