pg_topological_sort

What pg_topological_sort does on PostgreSQL MCP Server

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

Why pg_topological_sort is rated Low

This tool analyzes table dependencies and returns them in a sorted order for informational purposes. It does not execute DDL, modify tables, delete data, or move money. It is purely a read operation that queries schema metadata to determine execution order. Even in a PostgreSQL context where DDL execution is possible, this tool only retrieves the sorted order—execution is the responsibility of downstream operations.

From the tool's definition Tool name 'pg_topological_sort' and description 'Get tables in safe DDL execution order' indicate a query/analysis operation that retrieves ordering information without modifying data. The verb 'Get' suggests data retrieval.

The rule that runs pg_topological_sort safely

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

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

Questions about pg_topological_sort