show_triggers

What show_triggers does on Mysql

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

Why show_triggers is rated Low

This tool retrieves metadata about database triggers without creating, modifying, or deleting any data or structures. It is purely informational, consistent with the server's stated purpose of 'read-only queries' and 'server monitoring'. The blast radius of misuse is minimal—exposure of trigger definitions may reveal business logic but cannot cause data loss or system compromise.

From the tool's definition Tool name 'show_triggers' and description 'Show triggers for a table or all triggers' indicate a query/retrieval operation with no modification capability.

The rule that runs show_triggers safely

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

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

Questions about show_triggers