deploy_sp · MSSQL MCP Server MCP: Risk & Policy

WHAT IT DOES

What deploy_sp does on MSSQL MCP Server

AI agents invoke deploy_sp to trigger actions in MSSQL MCP Server. 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 deploy_sp needs a policy

deploy_sp triggers execution of code changes in a production environment. Although rollback is available (making it technically reversible), deployment is an Execute action because it runs external operations (stored procedure activation in production) whose effects depend on the procedure being deployed.

From the tool's definition Tool description states 'Deploy a tested draft to production' — this executes a stored procedure deployment that modifies production database code.

Attacks that exploit this kind of access

Recommended rule Ready

Verdict

deploy_sp Rate-limited

deploy_sp 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": {
    "deploy_sp": {
      "limits": [
        {
          "counter": "deploy_sp_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 MSSQL MCP Server, so you can run agents against it safely.

FAQ

Questions about deploy_sp

What does the deploy_sp tool do? +

Deploy a tested draft to production. This backs up the current version automatically and can be rolled back. It is categorised as a Execute tool in the MSSQL MCP Server MCP Server, which means it can trigger actions or run processes. Use rate limits and argument validation.

How do I enforce a policy on deploy_sp? +

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

What risk level is deploy_sp? +

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

Can I rate-limit deploy_sp? +

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

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

deploy_sp is provided by the MSSQL MCP Server MCP server (jpcanter/sql-server-mcp). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.