MCP Observatory
46s ago Tracked 52,799 Last 46s ago 24h 2,818
github analyzed 5744f0d

AIops-tools/Postgres-AIops

github

Governed PostgreSQL DBA ops: slow-query RCA, bloat/vacuum & blocking-lock analysis; 33 MCP tools.

maintainer
AIops-tools
license
—
first seen
2026-07-13
last seen
2026-07-13
releases · 30d
0
short id

Drift inferred · capture-to-capture

No drift recorded — single capability capture; advisories appear once its surface changes.

capabilities 35 tools
transport stdio · http verified reported listed in the official MCP registry counts 35 tools · 0 res · 0 prompts permission surface via code analysis

tools

  • autovacuum_status
  • bloat_and_vacuum_analysis
  • blocking_lock_chain_rca
  • cancel_query
  • create_index
  • drop_index
  • explain_query
  • index_bloat
  • invalid_indexes
  • list_activity
  • list_databases
  • list_extensions
  • list_locks
  • list_roles
  • long_running_queries
  • missing_index_hints
  • overview
  • reindex
  • replication_slots
  • replication_status
  • reset_query_stats
  • run_analyze
  • run_vacuum
  • server_version
  • show_settings
  • slow_query_rca
  • table_bloat
  • table_sizes
  • terminate_backend
  • top_queries
  • undo_apply
  • undo_list
  • unused_indexes
  • update_setting
  • wal_status
skills & danger signals github-tarball
prompt-surface shipped agent-instruction files + hidden-content / dangerous-code findings — quoted from the analyzed source

analyzed commit 5744f0d · analyzer v33 · 2d ago

skills & prompt files 1

code evidence vHEAD · github-tarball
evidence-backed findings quoted directly from the published source artifact — not inferred

code files: 85

tool registrations 35

  • list_activity AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/activity.py :10
  • long_running_queries AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/activity.py :30
  • list_locks AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/activity.py :43
  • slow_query_rca AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/analysis.py :13
  • bloat_and_vacuum_analysis AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/analysis.py :55
  • blocking_lock_chain_rca AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/analysis.py :84
  • unused_indexes AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/indexes.py :10
  • missing_index_hints AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/indexes.py :23
  • index_bloat AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/indexes.py :43
  • invalid_indexes AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/indexes.py :56
  • top_queries AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/queries.py :10
  • explain_query AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/queries.py :28
  • reset_query_stats AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/queries.py :45
  • terminate_backend AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/remediation.py :82
  • cancel_query AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/remediation.py :108
  • run_vacuum AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/remediation.py :135
  • run_analyze AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/remediation.py :164
  • create_index AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/remediation.py :186
  • drop_index AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/remediation.py :238
  • reindex AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/remediation.py :264
  • update_setting AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/remediation.py :295
  • replication_status AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/replication.py :10
  • replication_slots AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/replication.py :22
  • wal_status AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/replication.py :34
  • overview AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/server.py :11
  • server_version AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/server.py :27
  • show_settings AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/server.py :39
  • list_extensions AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/server.py :53
  • list_databases AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/server.py :65
  • list_roles AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/server.py :77
  • table_sizes AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/tables.py :10
  • table_bloat AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/tables.py :23
  • autovacuum_status AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/tables.py :36
  • undo_list AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/undo.py :43
  • undo_apply AIops-tools-Postgres-AIops-5744f0d/mcp_server/tools/undo.py :109