Skip to content

MCP-PostgreSQL-Ops

MIT★ 164updated 14 Nov 2026

Give AI assistants full PostgreSQL DBA superpowers — 30+ tools for performance analysis, bloat detection, lock/deadlock monitoring, autovacuum & schema inspection. No extensions required. PG 12-18.

What can you do with MCP-PostgreSQL-Ops?

  • get_database_stats — Enhanced I/O timing with trackiotiming = on
  • get_user_functions_stats — ⚙️ Config Required
  • get_pg_stat_statements_top_queries — pgstatstatements
  • get_pg_stat_monitor_recent_queries — pgstatmonitor

Tool descriptions from the project's README, checked 16 Nov 2026.

Install

{
  "mcpServers": {
    "mcp-postgresql-ops": {
      "command": "uv",
      "args": [
        "run",
        "python",
        "-m",
        "mcp_postgresql_ops"
      ],
      "env": {
        "POSTGRES_HOST": "127.0.0.1",
        "POSTGRES_PORT": "15432",
        "POSTGRES_USER": "postgres",
        "POSTGRES_PASSWORD": "changeme",
        "POSTGRES_DB": "ecommerce"
      }
    }
  }
}

Config as documented in its source, checked 16 Nov 2026. Placeholders such as API keys are the project's own: replace them with your values.

Setup documented for

Tools (37)

get_server_info
get_active_connections
get_postgresql_config
get_database_list
get_table_list
get_table_schema_info
get_database_schema_info
get_table_relationships
get_user_list
get_index_usage_stats
get_database_size_info
get_table_size_info
get_vacuum_analyze_stats
get_current_database_info
get_table_bloat_analysis
get_database_bloat_overview
get_autovacuum_status
get_autovacuum_activity
get_running_vacuum_operations
get_vacuum_effectiveness_analysis
get_lock_monitoring
get_wal_status
get_database_statsEnhanced I/O timing with trackiotiming = on
get_table_io_stats
get_index_io_stats
get_database_conflicts_stats
get_io_stats
get_bgwriter_stats
get_replication_status
get_all_tables_stats
get_user_functions_stats⚙️ Config Required
get_wait_events
get_wal_summarizer_status
get_async_io_status
get_per_backend_io_stats
get_pg_stat_statements_top_queriespgstatstatements
get_pg_stat_monitor_recent_queriespgstatmonitor

Tool names from the README, checked 16 Nov 2026.

MCP-PostgreSQL-Ops compared with other Postgres servers

ServerLicenceToolsLast commitStars
MCP-PostgreSQL-OpsMIT3714 Nov 2026164
postgres-mcpMIT917 Aug 20263,476
PostgreSQLMIT616 Sept 202625

Every value is a checked fact on that server's own page. This is a comparison of facts, not a ranking.

Verified facts

Maintainer
call518

Source · checked 16 Nov 2026

Licence
MIT

Source · checked 16 Nov 2026

Setup documented for
  • Claude Desktop

Source · checked 16 Nov 2026

Repository
github.com/call518/MCP-PostgreSQL-Ops

Source · checked 16 Nov 2026

Last commit
14 Nov 2026

Source · checked 16 Nov 2026

GitHub stars
164

Source · checked 16 Nov 2026

Open issues
0

Source · checked 16 Nov 2026

Each value links to where it was found and shows the date it was checked. How we verify

Frequently asked questions

What does MCP-PostgreSQL-Ops do?

Give AI assistants full PostgreSQL DBA superpowers — 30+ tools for performance analysis, bloat detection, lock/deadlock monitoring, autovacuum & schema inspection. No extensions required. PG 12-18.

Which MCP clients does MCP-PostgreSQL-Ops document setup for?

Its README documents setup for Claude Desktop.

How do I install MCP-PostgreSQL-Ops?

Add the install config shown on this page to your MCP client's configuration. Check the README for client-specific steps.

What licence is MCP-PostgreSQL-Ops under?

MIT, as reported by the repository on 16 Nov 2026.

Is MCP-PostgreSQL-Ops still maintained?

The last commit was on 14 Nov 2026, and the repository had 0 open issues.

What tools does MCP-PostgreSQL-Ops expose?

37 tools: get_server_info, get_active_connections, get_postgresql_config, get_database_list, get_table_list, get_table_schema_info, get_database_schema_info, get_table_relationships, get_user_list, get_index_usage_stats, get_database_size_info, get_table_size_info, and more.

More Postgres MCP servers