Skip to main content
Glama

propose_fix

Creates a reviewable unified diff or SQL fix for Databricks cost-waste issues—idle clusters, warehouse auto-stop, and Delta maintenance—without applying changes.

Instructions

Propose a fix as a unified diff (Asset Bundle YAML) or reviewable SQL — never applied. issue: 'all_purpose_job' (move tasks off existing_cluster_id onto a job cluster), 'no_autotermination' (set resources.clusters..autotermination_minutes), 'warehouse_autostop' (set resources.sql_warehouses..auto_stop_mins, default 10), or Delta (delta_optimize|delta_vacuum|delta_zorder|delta_predictive_optimization| delta_overfrequent_optimize) which returns SQL (resource_key = catalog.schema.table; for delta_zorder pass columns as comma-separated node_type_id; for delta_vacuum pass retention hours as minutes, default 168 / min 7 days). Pass cluster_id from find_waste for cluster fixes — a deleted cluster is refused. bundle_yaml may be empty for Delta issues.

Input Schema

NameRequiredDescriptionDefault
pathNodatabricks.yml
issueYes
minutesNo
cluster_idNo
bundle_yamlYes
num_workersNo
node_type_idNo
resource_keyYes
spark_versionNo

Output Schema

NameRequiredDescriptionDefault
resultYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A4.3/5.0
Behavior4/5

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

With no annotations, the description carries the full burden and delivers the key traits: output is a diff/SQL proposal, 'never applied' (non-mutating), and deleted clusters are refused. It omits permission/rate-limit details, but for a proposal-only tool the core safety profile is disclosed.

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?

The opening sentence front-loads purpose and the non-applied nature; the dense subsequent text earns its place by mapping issue values to behaviors and parameter quirks. It's information-dense rather than padded, though the nested parenthetical structure is heavy.

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

Completeness4/5

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

The output is a proposal (diff/SQL) and an output schema exists, so return values needn't be explained. The description covers the tricky parameters and safety behavior, leaving only a few auxiliary params (path, num_workers, spark_version) unaddressed.

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

Parameters4/5

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

At 0% schema coverage, the description compensates well: it explains the issue enum, tells that delta_zorder overloads node_type_id as column list, that delta_vacuum uses minutes (default 168/min 7 days), resource_key as catalog.schema.table, and that bundle_yaml may be empty. It leaves path, num_workers, and spark_version undocumented, so not fully complete.

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

Purpose5/5

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

States a specific verb and resource ('Propose a fix as a unified diff ... or reviewable SQL') plus a critical behavioral qualifier ('never applied'). This clearly distinguishes it from siblings like find_waste, cost_summary, and top_cost_drivers, which are analysis/reporting tools rather than fix generation.

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

Usage Guidelines4/5

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

Enumerates issue types with their intent, tells the agent to pass cluster_id 'from find_waste' for cluster fixes, and notes a deleted cluster is refused. It establishes the routing from find_waste and the delta-issue path, but doesn't explicitly say when NOT to use it or name every alternative.

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