list_foreign_tables

What list_foreign_tables does on Mcpg

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

Why list_foreign_tables is rated Low

The 'list_' prefix and 'foreign_tables' object indicate this tool retrieves metadata about foreign tables in PostgreSQL. Listing or querying metadata has no side effects and is a typical Read operation. Despite the empty description, the tool name provides sufficient evidence that this is a non-destructive retrieval function with minimal blast radius if misused.

From the tool's definition Tool name 'list_foreign_tables' indicates a retrieval operation that queries and lists foreign tables without modifying data. The naming convention ('list_') is consistent with Read category tools.

The rule that runs list_foreign_tables safely

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

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

Questions about list_foreign_tables