MCP-PostgreSQL-Ops
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_stats | Enhanced 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_queries | pgstatstatements |
| get_pg_stat_monitor_recent_queries | pgstatmonitor |
Tool names from the README, checked 16 Nov 2026.
MCP-PostgreSQL-Ops compared with other Postgres servers
| Server | Licence | Tools | Last commit | Stars |
|---|---|---|---|---|
| MCP-PostgreSQL-Ops | MIT | 37 | 14 Nov 2026 | 164 |
| postgres-mcp | MIT | 9 | 17 Aug 2026 | 3,476 |
| PostgreSQL | MIT | 6 | 16 Sept 2026 | 25 |
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.
