Medium Risk

insert

Insert multiple records into a table. Use

How to control insert ↓

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

Medium Risk

The insert operation creates new records in the database, which is a Write action. It is reversible (records can be deleted later) and has no permanent destructive effects.

From the tool's definition Tool name is 'insert' and description states 'Insert multiple records into a table.' This performs reversible creation of data without deletion or financial operations.

Documented attack patterns abuse exactly the kind of access insert gives an agent:

PolicyLayer is an MCP gateway — it sits between your AI agents and SurrealDB MCP Server, and nothing reaches the server without passing your rules. This is the rule we recommend for insert:

policy.json
{
  "version": "1",
  "default": "deny",
  "tools": {
    "insert": {
      "limits": [
        {
          "counter": "insert_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

insert 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.

  1. Create a free account and register SurrealDB MCP Server — nothing to install.
  2. Add this policy — paste it, or build it visually.
  3. Point your MCP client (Claude, Cursor, anything) at your gateway URL.
LIMIT THIS TOOL →

Free to start. No card required.

Go deeper

What does the insert tool do? +

Insert multiple records into a table. Use. It is categorised as a Write tool in the SurrealDB MCP Server MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

How do I enforce a policy on insert? +

Register the SurrealDB MCP Server MCP server in PolicyLayer and add a rule for insert: 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 SurrealDB MCP Server. Nothing to install.

What risk level is insert? +

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

Can I rate-limit insert? +

Yes. Add a rate_limit block to the insert 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 insert completely? +

Set action: deny in the PolicyLayer policy for insert. 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 insert? +

insert is provided by the SurrealDB MCP Server MCP server (nsxdavid/surrealdb-mcp-server). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

Enforce policy on every SurrealDB MCP Server tool call.

Deterministic rules across all 10 SurrealDB MCP Server tools. Per-identity grants. Full audit log. Live in minutes. Nothing to install.

Free to start. No card required.

10 SurrealDB MCP Server tools catalogued and risk-classified — across an index of 42,500+ MCP servers.

// GET IN TOUCH

Have a question or want to learn more? Send us a message.

Message sent.

We'll get back to you soon.