sqlserver_update_statistics · Multi-Database MCP Server MCP

WHAT IT DOES

What sqlserver_update_statistics does on Multi-Database MCP Server

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

WHY IT NEEDS A POLICY

Why sqlserver_update_statistics needs a policy

This tool modifies database statistics, which is a reversible write operation. It does not delete data (not Destructive), execute arbitrary code (not Execute), move money (not Financial), or merely read data (not Read). While statistics updates can affect query performance if misconfigured, they are metadata modifications rather than data modifications, and the operation is reversible or can be recomputed.

From the tool's definition 'Update statistics for a table' indicates a write operation that modifies database metadata. The description specifies a FULL mode parameter, suggesting a maintenance/administrative write operation on table statistics.

Attacks that exploit this kind of access

Recommended rule Ready

Verdict

sqlserver_update_statistics Rate-limited

sqlserver_update_statistics 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": {
    "sqlserver_update_statistics": {
      "limits": [
        {
          "counter": "sqlserver_update_statistics_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 Multi-Database MCP Server, so you can run agents against it safely.

FAQ

Questions about sqlserver_update_statistics

What does the sqlserver_update_statistics tool do? +

Update statistics for a table (requires FULL mode). It is categorised as a Write tool in the Multi-Database 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 sqlserver_update_statistics? +

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

What risk level is sqlserver_update_statistics? +

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

Can I rate-limit sqlserver_update_statistics? +

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

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

sqlserver_update_statistics is provided by the Multi-Database MCP Server MCP server (nam088/mcp-server). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.