PostgreSQL_get_estimated_row_counts

What PostgreSQL_get_estimated_row_counts does on Postgres

AI agents call PostgreSQL_get_estimated_row_counts 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_estimated_row_counts is rated Low

This tool queries PostgreSQL statistics to retrieve estimated row counts. It performs no data modifications, deletions, or external operations. The word 'estimated' and 'statistics' confirm it reads pre-computed metadata rather than executing potentially expensive operations. This is a standard read operation with minimal blast radius if misused—worst case, an agent repeatedly calls it, causing minor I/O overhead.

From the tool's definition Tool description states it 'Get estimated row counts for all tables using statistics', which retrieves data without modification. The method uses statistical estimates rather than executing aggregate queries, making it a non-invasive read operation.

The rule that runs PostgreSQL_get_estimated_row_counts 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_estimated_row_counts, this is the rule to start with:

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

Questions about PostgreSQL_get_estimated_row_counts