Skip to main content
Glama

Schemas Drop Schema

schemas_drop_schema
Destructive

Drops a Snowflake schema only after the confirmation flag is set, supporting controlled cleanup of obsolete schemas by name.

Instructions

Drop a schema in Snowflake. Requires confirmation flag.

Input Schema

NameRequiredDescriptionDefault
nameYesQuote names that aren't all uppercase, exactly as list tools return them.
confirmNo
databaseNoQuote names that aren't all uppercase, exactly as list tools return them.

Output Schema

NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed2 schema fields changedv3.0.0
    • addedInput schema / properties / database / description
      Added value: +"Quote names that aren't all uppercase, exactly as list tools return them."
    • addedInput schema / properties / name / description
      Added value: +"Quote names that aren't all uppercase, exactly as list tools return them."
  2. Addedv2.0.4

TDQS

B3.2/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare destructiveHint=true, idempotentHint=false and openWorldHint=true, so the safety profile is carried. The description adds one genuinely useful behavioral fact — that a confirmation flag is needed to proceed — but omits whether the drop is CASCADE (destroying contained tables) and whether it is recoverable via schemas_undrop_schema.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two short sentences with the action front-loaded and no filler. The confirmation sentence is terse to the point of ambiguity (required? defaulted?), slightly under- rather than over-specified.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Output schema and annotations cover the return shape and the destructive nature, so the description needn't repeat those. However, for an irreversible-seeming destructive operation with a sibling undrop tool, the missing note on cascade behavior and recoverability leaves an agent without information it needs before calling.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 67%; name and database are documented in the schema, while confirm has no schema description. The description partially compensates by signaling that confirmation is mandatory, but doesn't state the behavior when confirm is false (error vs. dry-run) or why database is optional (current connection context).

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb and resource (drop a schema) scoped to Snowflake, which is clear on its own. It does not distinguish itself from the relevant siblings such as schemas_undrop_schema (recovery) or databases_drop_database (parent scope), nor does it say what happens to contained tables/views.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

'Requires confirmation flag' implies a precondition but never states when to use this versus undrop, or that it should be used only after verifying the schema contents. There is no explicit when-to-use or when-not-to-use guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Deploy Server

Other Tools