MCP Tool Reference High Risk

execute_write_query

Execute a write SQL query against a PlanetScale database

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

planetscale-mcp Execute

WHEN AI AGENTS USE THIS TOOL

AI agents invoke execute_write_query to trigger processes or run actions in PlanetScale. 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 EXECUTE_WRITE_QUERY

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

planetscale.yaml 
tools:
  execute_write_query:
    rules:
      - action: allow
        rate_limit:
          max: 10
          window: 60
        validate:
          required_args: true

See the full PlanetScale policy for all 5 tools.

DETAILS

Tool Name

execute_write_query

Category

Execute

MCP Server

PlanetScale MCP Server

Risk Level

High

MORE PLANETSCALE TOOLS

execute_read_query Read
Execute a read-only SQL query against a PlanetScale database
get_insights Read
Get query performance insights and analytics
list_cluster_sizes Read
List available cluster sizes and pricing
search_documentation Read
Search PlanetScale documentation

SIMILAR EXECUTE TOOLS ON OTHER SERVERS

call-actor Apify
Call an Actor and get its run results
boot_simulator Appium
Boot an iOS simulator
setup_wda Appium
Download and setup WebDriverAgent for iOS simulators
install_wda Appium
Install and launch WebDriverAgent on an iOS simulator
auth0_deploy_action Auth0
Deploy an Auth0 action
auth0_publish_form Auth0
Publish an Auth0 form

RELATED READING

FREQUENTLY ASKED QUESTIONS

What does the execute_write_query tool do?

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

How do I enforce a policy on execute_write_query?

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

What risk level is execute_write_query?

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

Can I rate-limit execute_write_query?

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

Set action: deny in the Intercept policy for execute_write_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 execute_write_query?

execute_write_query is provided by the PlanetScale MCP server (planetscale-mcp). Intercept sits as a proxy in front of this server to enforce policies before tool calls reach the server.

ENFORCE POLICIES ON PLANETSCALE

Open source. One binary. Zero dependencies.

VIEW ON GITHUB Full PlanetScale policy →