How do I connect MCP PostgreSQL Ops MCP Server to Claude?

Run `claude mcp add mcp-postgresql-ops -- uvx --python 3.12 mcp-postgresql-ops` in Claude Code, or add the same command and arguments under mcpServers in Cursor's mcp.json or Claude Desktop's claude_desktop_config.json, then restart the client. The blocks above are ready to paste.

Is MCP PostgreSQL Ops MCP Server free?

The listed licence is MIT. Check the upstream terms for permitted use and commercial requirements; a public repository does not by itself mean the software is free or open source. Connected APIs and hosted services may have separate charges.

What can MCP PostgreSQL Ops MCP Server do?

MCP PostgreSQL Ops MCP Server documents 37 tools to the agent, including get_active_connections, get_all_tables_stats, get_async_io_status. The descriptions above come from project documentation. A live handshake does not test individual tool behavior.

MCP PostgreSQL Ops

Unclaimed

by call518

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

Set up this server

Compare servers My Stack

01 / Choose your client

02 / Before you connect

Authentication is not specified. Check the project instructions before connecting.

Install the runtime required by the project and make it available to your client.

Project instructionsEnvironment variable names (optional)

Use names from the project instructions, separated by commas. Enter names only, never secret values.

03 / Add the configuration

Source: generated from public install instructions

claude mcp add --transport stdio 'mcp-postgresql-ops' -- 'uvx' '--python' '3.12' 'mcp-postgresql-ops'

Run in your terminal after replacing any placeholders.

04 / Check it in your client

Open your client’s MCP settings and confirm the server connects and lists its tools. A copied configuration does not confirm a working connection.

agentagentic-aiaiclaudedatabasedatabase-toolsdbafastmcpllmmanagementmcpmcp-servermonitoringopenwebuiperformance-monitoringpostgrespostgresqlpostgresql-diagnosticspythonsql

Is this your MCP server?

This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.

Claim this server

Security profile

Claimed and verified servers get a weekly static scan that shows what the code can reach: external services, environment variables, shell commands, agent configuration folders, plus any dependencies with known advisories. Claim this listing to get one. How the security profile works

37 of 37 tools

Documented tools (37)

From project documentation. A server handshake does not verify each tool’s description or behavior.

get_active_connections

❌ None

get_all_tables_stats

❌ None

get_async_io_status

❌ None

get_autovacuum_activity

❌ None

get_autovacuum_status

❌ None

get_bgwriter_stats

❌ None

get_current_database_info

❌ None

get_database_bloat_overview

❌ None

get_database_conflicts_stats

❌ None

get_database_list

❌ None

get_database_schema_info

❌ None

get_database_size_info

❌ None

get_database_stats

❌ None

get_index_io_stats

❌ None

get_index_usage_stats

❌ None

get_io_stats

❌ None

get_lock_monitoring

❌ None

get_per_backend_io_stats

❌ None

get_pg_stat_monitor_recent_queries

pgstatmonitor

get_pg_stat_statements_top_queries

pgstatstatements

get_postgresql_config

❌ None

get_replication_status

❌ None

get_running_vacuum_operations

❌ None

get_server_info

❌ None

get_table_bloat_analysis

❌ None

get_table_io_stats

❌ None

get_table_list

❌ None

get_table_relationships

❌ None

get_table_schema_info

❌ None

get_table_size_info

❌ None

get_user_functions_stats

⚙️ Config Required

get_user_list

❌ None

get_vacuum_analyze_stats

❌ None

get_vacuum_effectiveness_analysis

❌ None

get_wait_events

❌ None

get_wal_status

❌ None

get_wal_summarizer_status

❌ None

Tool change history

Compared across complete checks of the same configuration. Tools were listed, not invoked. Input-schema changes are not measured here.

No complete tool checks yet.

FAQ

Questions about MCP PostgreSQL Ops MCP Server

How do I connect MCP PostgreSQL Ops MCP Server to Claude?: Run `claude mcp add mcp-postgresql-ops -- uvx --python 3.12 mcp-postgresql-ops` in Claude Code, or add the same command and arguments under mcpServers in Cursor's mcp.json or Claude Desktop's claude_desktop_config.json, then restart the client. The blocks above are ready to paste.
Is MCP PostgreSQL Ops MCP Server free?: The listed licence is MIT. Check the upstream terms for permitted use and commercial requirements; a public repository does not by itself mean the software is free or open source. Connected APIs and hosted services may have separate charges.
What can MCP PostgreSQL Ops MCP Server do?: MCP PostgreSQL Ops MCP Server documents 37 tools to the agent, including get_active_connections, get_all_tables_stats, get_async_io_status. The descriptions above come from project documentation. A live handshake does not test individual tool behavior.