// MCP TOOL REFERENCE

ExecuteSqlQueryTool

Execute SQL on a Prisma Postgres database

Runs arbitrary SQL including writes

Part of the Prisma MCP server. Enforce policies on this tool with Intercept, the open-source MCP proxy.

@prisma Execute Risk 5/5

// WHEN AI AGENTS USE THIS TOOL

AI agents invoke ExecuteSqlQueryTool to trigger processes or run actions in Prisma. Execute operations can have side effects beyond the immediate call -- triggering builds, sending notifications, or starting workflows. Rate limits and argument validation are essential to prevent runaway execution.

// WHY ENFORCE A POLICY ON EXECUTESQLQUERYTOOL

ExecuteSqlQueryTool can trigger processes with real-world consequences. An uncontrolled agent might start dozens of builds, send mass notifications, or kick off expensive compute jobs. Intercept enforces rate limits and validates arguments to keep execution within safe bounds.

// RECOMMENDED POLICY

Execute tools trigger processes. Rate-limit and validate arguments to prevent unintended side effects.

prisma.yaml

tools:
  ExecuteSqlQueryTool:
    rules:
      - action: allow
        rate_limit:
          max: 10
          window: 60
        validate:
          required_args: true

See the full Prisma policy for all 17 tools.

// DETAILS

Tool Name ExecuteSqlQueryTool

Category Execute

MCP Server Prisma MCP Server

Risk Level High

// MORE PRISMA TOOLS

Destructive DeleteConnectionStringTool Destructive DeleteDatabaseTool Destructive migrate-reset Write Create-Prisma-Postgres-Database Write CreateBackupTool Write CreateConnectionStringTool Write CreateRecoveryTool Write migrate-dev

View all 17 tools →

// WHAT CAN GO WRONG

Agents calling execute-class tools like ExecuteSqlQueryTool have been implicated in these attack patterns. Read the full case and prevention policy for each:

Browse the full MCP Attack Database →

// OTHER EXECUTE TOOLS ACROSS MCP SERVERS

Other tools in the Execute risk category across the catalogue. The same policy patterns (rate-limit, validate) apply to each.

Agent Passport System — Cryptographic Identity for AI Agents commerce_preflight Agent Passport System — Cryptographic Identity for AI Agents execute_with_context Agent Passport System — Cryptographic Identity for AI Agents gateway_execute_approval Agent Passport System — Cryptographic Identity for AI Agents governance_360 Agent Passport System — Cryptographic Identity for AI Agents parse_governance_block_html AgentClear — API Marketplace for AI Agents call_service

// IN CONTEXT OF HIGH RISK

ExecuteSqlQueryTool is one of the high-risk operations in Prisma. For the full severity-focused view — only the high-risk tools with their recommended policies — see the breakdown for this server, or browse all high-risk tools across every MCP server.

// RELATED READING

// FAQ

What does the ExecuteSqlQueryTool tool do? +

Execute SQL on a Prisma Postgres database. It is categorised as a Execute tool in the Prisma MCP Server, which means it can trigger actions or run processes. Use rate limits and argument validation.

How do I enforce a policy on ExecuteSqlQueryTool? +

Add a rule in your Intercept YAML policy under the tools section for ExecuteSqlQueryTool. You can allow, deny, rate-limit, or validate arguments. Then run Intercept as a proxy in front of the Prisma MCP server.

What risk level is ExecuteSqlQueryTool? +

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

Can I rate-limit ExecuteSqlQueryTool? +

Yes. Add a rate_limit block to the ExecuteSqlQueryTool rule in your Intercept 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 ExecuteSqlQueryTool completely? +

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

ExecuteSqlQueryTool is provided by the Prisma MCP server (@prisma). Intercept sits as a proxy in front of this server to enforce policies before tool calls reach the server.

ExecuteSqlQueryTool

Enforce policies on Prisma