PostgreSQL_list_indexes

What PostgreSQL_list_indexes does on Postgres

AI agents call PostgreSQL_list_indexes 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_indexes is rated Low

This tool retrieves metadata about database indexes on a table. It performs a query operation that returns information without creating, modifying, or deleting any data or schema objects. The blast radius of misuse is minimal—an agent could at worst retrieve index information it shouldn't see, but cannot alter the database state. This is a classic Read category tool.

From the tool's definition Tool name 'list_indexes' and description 'List all indexes on a specific table' indicate a retrieval operation with no modification or destructive capability.

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

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

Questions about PostgreSQL_list_indexes