create_table · MySQL- MCP: Risk & Policy

WHAT IT DOES

What create_table does on MySQL-MCP

AI agents use create_table to create or update resources in MySQL-MCP — usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your MySQL-MCP environment.

WHY IT NEEDS A POLICY

Why create_table needs a policy

Creating a table is a reversible Write operation—it modifies the database schema by adding a new table, but the action can be undone by dropping the table. While significant, it does not irreversibly destroy existing data like a Destructive action would.

From the tool's definition Tool name 'create_table' and description 'Create a new table in the database' indicate schema modification that adds new data structures.

Attacks that exploit this kind of access

Recommended rule Ready

Verdict

create_table Rate-limited

create_table stays usable, but capped — an agent stuck in a loop can't make hundreds of changes a minute. Everything else on the server is denied unless you say otherwise.

View as policy code

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "create_table": {
      "limits": [
        {
          "counter": "create_table_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

LIMIT THIS TOOL →

Instant setup, no code required.

PolicyLayer is an MCP gateway: every tool call is checked against your rule before it reaches MySQL-MCP, so you can run agents against it safely.

FAQ

Questions about create_table

What does the create_table tool do? +

Create a new table in the database. It is categorised as a Write tool in the MySQL-MCP MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

How do I enforce a policy on create_table? +

Register the MySQL- MCP server in PolicyLayer and add a rule for create_table: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches MySQL-MCP. Nothing to install.

What risk level is create_table? +

create_table is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Can I rate-limit create_table? +

Yes. Add a rate_limit block to the create_table rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block create_table completely? +

Set action: deny in the PolicyLayer policy for create_table. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides create_table? +

create_table is provided by the MySQL- MCP server (zajtools/zaj-mysql-mcp). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.