// MCP TOOL REFERENCE

drop_object

Drop a Snowflake database object permanently

Destroys database/schema/table

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

@snowflake-labs-mcp Destructive Risk 5/5

// WHEN AI AGENTS USE THIS TOOL

AI agents may call drop_object to permanently remove or destroy resources in Snowflake. 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 DROP_OBJECT

Without a policy, an AI agent could call drop_object in a loop, permanently destroying resources in Snowflake. 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.

snowflake.yaml

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

See the full Snowflake policy for all 10 tools.

// DETAILS

Tool Name drop_object

Category Destructive

MCP Server Snowflake MCP Server

Risk Level Critical

// MORE SNOWFLAKE TOOLS

Execute run_query Write create_object Write create_or_alter_object Read describe_object Read list_objects Read list_semantic_views Read query_cortex_agent Read query_cortex_analyst

View all 10 tools →

// WHAT CAN GO WRONG

Agents calling destructive-class tools like drop_object 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

drop_object is one of the critical-risk operations in Snowflake. 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 drop_object tool do? +

Drop a Snowflake database object permanently. It is categorised as a Destructive tool in the Snowflake 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 drop_object? +

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

What risk level is drop_object? +

drop_object 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 drop_object? +

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

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

drop_object is provided by the Snowflake MCP server (@snowflake-labs-mcp). Intercept sits as a proxy in front of this server to enforce policies before tool calls reach the server.

drop_object

Enforce policies on Snowflake