PostgreSQL_get_top_heavy_queries

What PostgreSQL_get_top_heavy_queries does on Postgres

AI agents call PostgreSQL_get_top_heavy_queries to retrieve information from Postgres without modifying anything. It is typically the context-gathering step in research, monitoring, and reporting workflows, before the agent takes action elsewhere.

Why PostgreSQL_get_top_heavy_queries is rated Low

This tool reads performance statistics from PostgreSQL's built-in pg_stat_statements extension. It retrieves aggregated query metrics (total time, call counts, mean time) for analysis and monitoring purposes. There are no side effects, no data modification, and no code execution triggered by the tool itself. The worst-case misuse is information disclosure of query patterns, which is a low severity read risk.

From the tool's definition Tool queries pg_stat_statements to retrieve statistics on top queries; description indicates data retrieval ('Get top queries') with no modification, deletion, or execution of arbitrary code.

The rule that runs PostgreSQL_get_top_heavy_queries safely

PolicyLayer is an MCP gateway: it sits between your AI agents and Postgres, and checks every tool call against a rule you set before the call runs. Nothing changes on the server itself. For PostgreSQL_get_top_heavy_queries, this is the rule to start with:

{
  "version": "1",
  "default": "deny",
  "tools": {
    "PostgreSQL_get_top_heavy_queries": {}
  }
}

Questions about PostgreSQL_get_top_heavy_queries