run_aggregate_query · ServiceNow- MCP: Risk & Policy

WHAT IT DOES

What run_aggregate_query does on ServiceNow-MCP

AI agents invoke run_aggregate_query to trigger actions in ServiceNow-MCP. What it does depends on the arguments the agent supplies, and its effects often reach beyond the immediate call — builds kicked off, notifications sent, workflows started.

WHY IT NEEDS A POLICY

Why run_aggregate_query needs a policy

This tool executes queries against ServiceNow tables with user-controlled parameters. While read-only in nature (aggregation queries don't modify data), the Execute category applies because it runs code/queries whose effects and results are argument-dependent.

From the tool's definition Tool description states 'Run a grouped aggregate (COUNT, SUM, AVG) query on any table' with access to `/api/now/stats/{table}`.

Attacks that exploit this kind of access

Recommended rule Ready

Verdict

run_aggregate_query Rate-limited

run_aggregate_query stays usable, but rate-capped — a runaway agent can't fire it dozens of times a minute. Everything else on the server is denied unless you say otherwise.

View as policy code

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "run_aggregate_query": {
      "limits": [
        {
          "counter": "run_aggregate_query_rate",
          "window": "minute",
          "max": 10,
          "scope": "grant"
        }
      ]
    }
  }
}

RATE-LIMIT THIS TOOL →

Instant setup, no code required.

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

FAQ

Questions about run_aggregate_query

What does the run_aggregate_query tool do? +

Run a grouped aggregate (COUNT, SUM, AVG) query on any table (latest release: /api/now/stats/{table}). It is categorised as a Execute tool in the ServiceNow-MCP MCP Server, which means it can trigger actions or run processes. Use rate limits and argument validation.

How do I enforce a policy on run_aggregate_query? +

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

What risk level is run_aggregate_query? +

run_aggregate_query is a Execute tool with high risk. Execute tools should be rate-limited and have argument validation enabled.

Can I rate-limit run_aggregate_query? +

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

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

run_aggregate_query is provided by the ServiceNow- MCP server (tedorigawa001/servicenow-mcp). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.