Skip to main content
Glama
Coalesce-Software-Inc

coalesce-transform-mcp

Official

Propagate Column Change

propagate_column_change
Destructive

Propagate column name or data type changes to all downstream nodes, updating the entire pipeline automatically.

Instructions

⚠️ WRITE operation — Updates all downstream columns that depend on a source column. Use this after renaming a column or changing its data type to propagate the change through the entire pipeline.

Args: workspaceID: Workspace to modify nodeID: Node containing the source column columnID: Column ID that was changed changes: Object with optional columnName and/or dataType to propagate

Returns: Pre-mutation snapshot summary (column-level changes), snapshotPath to a disk file with full node bodies, list of updated nodes/columns, total count, and any errors encountered. The disk snapshot at snapshotPath captures each downstream node's complete nodeBody before mutation, enabling manual reversal of partial failures via set_workspace_node. Each downstream node is fetched, its column updated, and the full node PUT back via API. The lineage cache is invalidated after propagation.

Requires a lineage cache — will fetch all workspace nodes with detail=true on first call. Note: Propagation targets are determined from the cached lineage graph (up to 30 min old). Downstream nodes added after the cache was built will not be included. Refresh lineage first if the workspace structure has changed recently.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
nodeIDYesNode ID containing the source column
changesYesChanges to propagate — at least one of columnName or dataType required
columnIDYesColumn ID that was changed
confirmedNoSet to true after the user explicitly confirms the propagation. Required because this operation modifies multiple downstream nodes.
workspaceIDYesWorkspace ID

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
errorsNo
changesNo
snapshotPathNo
sourceNodeIDNo
totalUpdatedNo
updatedNodesNo
sourceColumnIDNo
preMutationSnapshotNo
Behavior5/5

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

Annotations indicate destructive and not readonly, but description adds extensive behavioral details: performs PUT requests for each downstream node, creates a disk snapshot for reversibility, invalidates cache, and explains partial failure handling. This goes well beyond annotations.

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?

Well-structured with front-loaded warning and purpose. Contains necessary detail without being overly verbose. A few sentences could be tightened, but overall efficient.

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

Completeness5/5

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

Given the tool's complexity (5 params, nested object, output schema), the description covers prerequisites, side effects, return values, error handling, and limitations like cache staleness. Very complete.

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 100% with detailed descriptions. The description's 'Args' section adds little beyond the schema, though it reinforces the required nature of changes. Overall, minimal added value for parameters.

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?

The description clearly states it's a WRITE operation that updates all downstream columns depending on a source column, with specific use cases like renaming a column or changing data type. This clearly distinguishes it from sibling tools.

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?

Provides explicit context for when to use (after column rename/type change), and important prerequisites (lineage cache, staleness up to 30 min, need to refresh). Lacks explicit 'when not to use' but is otherwise clear.

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

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Coalesce-Software-Inc/coalesce-transform-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server