// SCAN REPORT

Coalesce Transform

100 tools. 75 can modify or destroy data without limits.

10 destructive tools with no built-in limits. Policy required.

Last updated: 6 Jun 2026

75 can modify or destroy data

25 read-only

100 tools total

Free to start. No card required.

TOOL MAP

Read (25) Write / Execute (65) Destructive / Financial (10)

WHAT CAN GO WRONG

Destructive tools (`cancel_run`, `delete_env_role`, `delete_environment`) permanently delete resources. There is no undo. An agent calling these in a retry loop causes irreversible damage.

Write operations (`analyze_impact`, `analyze_workspace_patterns`, `apply_join_condition`) modify state. Without rate limits, an agent can make hundreds of changes in seconds — faster than any human can review or revert.

Execute tools (`build_pipeline_from_intent`, `cache_runs`, `create_pipeline_from_plan`) trigger processes with side effects. Builds, notifications, workflows — all fired without throttling.

RECOMMENDED RULES

Deny destructive operations

{
  "`cancel_run`": {
    "deny_if": [
      {
        "conditions": [],
        "on_deny": "Blocked by default. Requires approval."
      }
    ]
  }
}

Destructive tools should never be available to autonomous agents without human approval.

Rate limit write operations

{
  "`analyze_impact`": {
    "limits": [
      {
        "counter": "`analyze_impact`_per_hour",
        "window": "hour",
        "max": 30,
        "scope": "grant"
      }
    ]
  }
}

Prevents bulk unintended modifications from agents caught in loops.

Cap read operations

{
  "`clear_data_cache`": {
    "limits": [
      {
        "counter": "`clear_data_cache`_per_minute",
        "window": "minute",
        "max": 60,
        "scope": "grant"
      }
    ]
  }
}

Controls API costs and prevents retry loops from exhausting upstream rate limits.

ALL 100 COALESCE TRANSFORM TOOLS

DESTRUCTIVE 10 tools

Destructive `cancel_run` Destructive `delete_env_role` Destructive `delete_environment` Destructive `delete_git_account` Destructive `delete_project_role` Destructive `delete_project` Destructive `delete_workspace_job` Destructive `delete_workspace_node` Destructive `delete_workspace_subgraph` Destructive `serialize_workspace_node_to_disk_yaml`

EXECUTE 13 tools

Execute `build_pipeline_from_intent` Execute `cache_runs` Execute `create_pipeline_from_plan` Execute `diagnose_run_failure` Execute `get_environment_health` Execute `get_job_run_details_by_name` Execute `get_run_details` Execute `get_run_results` Execute `get_run` Execute `retry_and_wait` Execute `retry_run` Execute `run_and_wait` Execute `start_run`

WRITE 52 tools

Write `analyze_impact` Write `analyze_workspace_patterns` Write `apply_join_condition` Write `apply_sql_to_workspace_node` Write `audit_documentation_coverage` Write `cache_environment_nodes` Write `cache_org_users` Write `cache_workspace_nodes` Write `complete_node_configuration` Write `convert_join_to_aggregation` Write `create_environment` Write `create_git_account` Write `create_node_from_external_schema` Write `create_pipeline_from_sql` Write `create_project` Write `create_workspace_job` Write `create_workspace_node_from_predecessor` Write `create_workspace_node_from_scratch` Write `create_workspace_subgraph` Write `diagnose_setup` Write `find_jobs_by_name` Write `generate_set_workspace_node_template_from_variant` Write `generate_set_workspace_node_template` Write `get_column_lineage` Write `get_downstream_nodes` Write `get_node_type_variant` Write `get_repo_node_type_definition` Write `get_upstream_nodes` Write `get_workspace_subgraph` Write `list_job_nodes` Write `parse_disk_node_to_workspace_body` Write `parse_sql_structure` Write `personalize_skills` Write `pipeline_workshop_close` Write `pipeline_workshop_instruct` Write `pipeline_workshop_open` Write `plan_pipeline` Write `propagate_column_change` Write `replace_workspace_node_columns` Write `review_pipeline` Write `run_status` Write `search_node_type_variants` Write `select_pipeline_node_type` Write `set_env_role` Write `set_org_role` Write `set_project_role` Write `set_workspace_node` Write `update_git_account` Write `update_project` Write `update_workspace_job` Write `update_workspace_node` Write `update_workspace_subgraph`

FAQ

Can an AI agent delete data through the Coalesce Transform MCP server? +

Yes. The Coalesce Transform server exposes 10 destructive tools including `cancel_run`, `delete_env_role`, `delete_environment`. These permanently remove resources with no undo. PolicyLayer blocks destructive tools by default so they never reach the upstream server.

How do I prevent bulk modifications through Coalesce Transform? +

The Coalesce Transform server has 52 write tools including `analyze_impact`, `analyze_workspace_patterns`, `apply_join_condition`. Set a rate limit in your policy -- for example, 10 calls per hour prevents an agent from making more than 10 modifications per hour. PolicyLayer enforces this at the gateway, before calls reach Coalesce Transform.

How many tools does the Coalesce Transform MCP server expose? +

100 tools across 4 categories: Destructive, Execute, Read, Write. 25 are read-only. 75 can modify, create, or delete data.

How do I enforce a policy on Coalesce Transform? +

Register the Coalesce Transform MCP server in PolicyLayer, apply the suggested rules above (adjust the limits to your use case), and point your AI client at the PolicyLayer proxy URL instead of the server directly. Your agents keep the same tools; PolicyLayer evaluates every call against policy before it executes. Nothing to install, live in minutes.

// RELATED SERVERS

Other MCP servers with similar tools.

Starter policies for each. Same risk classification, live on your fleet in minutes.

Enforce policy on every Coalesce Transform tool call.

Deterministic rules across all 100 Coalesce Transform tools. Per-identity grants. Full audit log. Live in minutes. Nothing to install.

SECURE COALESCE TRANSFORM →

Free to start. No card required.

4,600+ MCP servers and 31,000+ tools scanned and risk-classified.

Coalesce Transform

// TOOL MAP

// WHAT CAN GO WRONG

// RECOMMENDED RULES

// ALL 100 COALESCE TRANSFORM TOOLS

// FAQ