MCP-PostgreSQL-Ops

Overview

MCP-PostgreSQL-Ops is a professional MCP server offering PostgreSQL database operations, monitoring, and management capabilities. It provides comprehensive database analysis, performance monitoring, and intelligent maintenance recommendations through natural language queries. The server supports PostgreSQL versions 12-18 with automatic version detection and works with regular user permissions while offering enhanced functionality when using optional extensions like pg_stat_statements and pg_stat_monitor.

Try asking AI

After installing, here are 6 things you can ask your AI assistant:

• get_server_info

  Get PostgreSQL server information and version details

  Try:What version of PostgreSQL is running?Try:Show me server information
• get_active_connections

  Monitor current database connections and their status

  Try:Show me current active connectionsTry:How many connections are active?
• get_table_bloat_analysis

  Analyze table bloat across all databases

  Try:Which tables have the most bloat?Try:Analyze table bloat across all databases
• get_slow_queries

  Identify slow queries in the system

  Try:What are the slowest queries?Try:Find queries with high execution time
• get_database_size_info

  Get database size information and storage usage

  Try:Show me database size informationTry:How much storage is each database using?
• get_vacuum_analyze_stats

  Get statistics about VACUUM and ANALYZE operations

  Try:Show me VACUUM statisticsTry:Which tables need maintenance?
• get_lock_monitoring

  Monitor database locks and potential deadlocks

  Try:Show me current locksTry:Are there any deadlock issues?
• get_table_schema_info

  Get detailed table schema information

  Try:Show schema for the orders tableTry:What columns are in the customers table?
• get_autovacuum_status

  Check autovacuum configuration and status

  Try:Show autovacuum statusTry:Is autovacuum enabled?
• get_replication_status

  Check PostgreSQL replication status and health

  Try:Show replication statusTry:Is replication working properly?
• get_index_usage_stats

  Get index usage statistics and effectiveness

  Try:Show index usage statisticsTry:Which indexes are not being used?
• get_wait_events

  Check database wait events for performance analysis

  Try:Show wait eventsTry:What is causing database waits?

Comparable tools

Installation

pip install mcp-postgresql-ops

mcp-server-postgresql-ops

{
  "mcpServers": {
    "postgresql-ops": {
      "command": "mcp-server-postgresql-ops",
      "args": []
    }
  }
}

git clone https://github.com/call518/MCP-PostgreSQL-Ops.git
cd MCP-PostgreSQL-ops
docker-compose up -d

FAQ

What permissions are required to use this MCP server?

The server works with regular user permissions for basic monitoring tasks. Superuser privileges provide access to all databases and system information, but are not required for most operations.

Can this be used with cloud databases like Amazon RDS?

Yes, the MCP server is compatible with RDS and Aurora and designed for production-safe read-only operations with regular user permissions.

What PostgreSQL versions are supported?

The server supports PostgreSQL versions 12-18 with automatic version detection and version-aware features.

On Hacker News

Recent discussion from the developer community.

• Show HN: MCP Server for PostgreSQL Monitoring/Operations (MCP-PostgreSQL-Ops)▲ 6💬 1
  Story by call518 · 2025-08-20

Compare MCP-PostgreSQL-Ops with