show_create_table

What show_create_table does on Mysql

AI agents call show_create_table 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_create_table is rated Low

This tool queries and returns the CREATE TABLE DDL statement for inspection purposes. It retrieves existing schema information without any side effects, data modification, or destructive operations. The server's stated purpose includes 'read-only queries' which aligns with this classification. No data is created, modified, deleted, or executed—only metadata is read.

From the tool's definition Tool name 'show_create_table' and description 'Show the CREATE TABLE statement for a table' indicate retrieval of schema metadata with no modification or deletion of data.

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

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

Questions about show_create_table