MCP Tool Reference Critical Risk

drop_object

Drop a Snowflake object

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

snowflake-labs-mcp Destructive

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

describe_object Read
Describe the structure of a Snowflake object
list_objects Read
List Snowflake objects such as databases, schemas, tables
list_semantic_views Read
List and query Snowflake Semantic Views
query_cortex_search Read
Query a Cortex Search Service for semantic search
query_cortex_analyst Read
Query Cortex Analyst for natural language to SQL conversion
query_cortex_agent Read
Query a Cortex Agent Service for agentic orchestration
create_object Write
Create a new Snowflake object
create_or_alter_object Write
Create or alter a Snowflake object

View all 10 tools →

SIMILAR DESTRUCTIVE TOOLS ON OTHER SERVERS

delete_record Airtable
Remove a record
delete_session Appium
Delete the current session and clean up
appium_uninstallApp Appium
Uninstall an app from the device
deleteCompassComponent Atlassian Rovo
Delete a Compass component
deleteConfluencePage Atlassian Rovo
Delete a Confluence page
delete_resource AWS
Delete AWS resources

RELATED READING

FREQUENTLY ASKED QUESTIONS

What does the drop_object tool do?

Drop a Snowflake object. 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.

ENFORCE POLICIES ON SNOWFLAKE

Open source. One binary. Zero dependencies.

VIEW ON GITHUB Full Snowflake policy →