PostgreSQL_list_foreign_key_references

What PostgreSQL_list_foreign_key_references does on Postgres

AI agents call PostgreSQL_list_foreign_key_references 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_list_foreign_key_references is rated Low

This tool performs a read-only query of PostgreSQL's catalog to enumerate foreign key relationships. It has no side effects, makes no modifications, and poses minimal risk even if an AI agent calls it with arbitrary table names. The blast radius is limited to information disclosure of non-sensitive schema structure. Classification: Read.

From the tool's definition Tool name and description indicate it 'List[s] all tables that reference the specified table via foreign keys' — a query operation that retrieves metadata about database schema relationships without modifying or executing any code.

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

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

Questions about PostgreSQL_list_foreign_key_references