// MCP TOOL REFERENCE

previewDelete

Preview which rows would be deleted without actually deleting them

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

// WHEN AI AGENTS USE THIS TOOL

AI agents may call previewDelete to permanently remove or destroy resources in Postgres Scout. Without a policy, an autonomous agent could delete critical data in a loop with no way to undo the damage. Intercept blocks destructive tools by default and requires explicit human approval before enabling them.

// WHY ENFORCE A POLICY ON PREVIEWDELETE

Without a policy, an AI agent could call previewDelete in a loop, permanently destroying resources in Postgres Scout. There is no undo for destructive operations. Intercept blocks this tool by default and only allows it when a human explicitly approves the action.

// RECOMMENDED POLICY

Destructive tools permanently remove data. Block by default. Only enable with explicit approval workflows.

io-github-bluwork-postgres-scout-mcp.yaml

tools:
  previewDelete:
    rules:
      - action: deny
        reason: "Blocked by default — enable with approval"

See the full Postgres Scout policy for all 38 tools.

// DETAILS

Tool Name previewDelete

Category Destructive

MCP Server Postgres Scout MCP Server

Risk Level Critical

// MORE POSTGRES SCOUT TOOLS

Destructive safeDelete Execute executeQuery Write exportTable Write generateInsertStatements Write previewUpdate Write safeInsert Write safeUpdate Read analyzeForeignKeys

View all 38 tools →

// WHAT CAN GO WRONG

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

Browse the full MCP Attack Database →

// OTHER DESTRUCTIVE TOOLS ACROSS MCP SERVERS

Other tools in the Destructive risk category across the catalogue. The same policy patterns (deny, require_approval) apply to each.

AbraFlexi contact_delete AbraFlexi evidence_delete AbraFlexi invoice_issued_delete AbraFlexi product_delete Agent Passport System — Cryptographic Identity for AI Agents remove_intent_card Agent Passport System — Cryptographic Identity for AI Agents revoke_delegation

// IN CONTEXT OF CRITICAL RISK

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

// RELATED READING

// FAQ

What does the previewDelete tool do? +

Preview which rows would be deleted without actually deleting them. It is categorised as a Destructive tool in the Postgres Scout MCP Server, which means it can permanently delete or destroy data. Block by default and require explicit approval.

How do I enforce a policy on previewDelete? +

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

What risk level is previewDelete? +

previewDelete is a Destructive tool with critical risk. Critical-risk tools should be blocked by default and only enabled with explicit human approval.

Can I rate-limit previewDelete? +

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

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

previewDelete is provided by the Postgres Scout MCP server (postgres-scout-mcp). Intercept sits as a proxy in front of this server to enforce policies before tool calls reach the server.

previewDelete

Enforce policies on Postgres Scout