Build Pipeline from Intent
build_pipeline_from_intentTranslate natural language pipeline descriptions into executable Coalesce pipeline nodes by parsing intent, matching entities, and selecting node types.
Instructions
Build a Coalesce pipeline from a natural language description. Describe what you want in plain English and this tool resolves workspace nodes, selects node types, and creates the pipeline nodes.
Examples:
"combine customers and orders by customer_id, aggregate total revenue by region"
"stage the raw payments table"
"join products with inventory on product_id"
The tool parses the intent, fuzzy-matches entity names to existing workspace nodes, and selects appropriate node types. When confirmed, it creates the pipeline nodes directly. Alternatively, set dryRun=true to get the plan without creating nodes, then pass it to create_pipeline_from_plan.
If entity names cannot be resolved or the intent is ambiguous, the tool returns clarification questions instead of a plan.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dryRun | No | When true, return the generated plan without creating nodes. | |
| intent | Yes | Natural language description of the pipeline to build. Mention table/node names, join keys, aggregations, and filters. | |
| schema | No | Optional target schema | |
| database | No | Optional target database | |
| repoPath | No | Optional local committed Coalesce repo path for repo-first node-type ranking. Falls back to COALESCE_REPO_PATH or `repoPath` in the active ~/.coa/config profile when omitted. | |
| confirmed | No | Set to true only after presenting the plan to the user and receiving explicit approval. | |
| targetName | No | Optional target node name override | |
| workspaceID | Yes | The workspace ID | |
| locationName | No | Optional target locationName | |
| targetNodeType | No | Optional node type override. When omitted, the planner selects the best type automatically. | |
| confirmationToken | No | The token returned in the STOP_AND_CONFIRM response. Required when confirmed=true. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| plan | No | ||
| error | No | ||
| dryRun | No | ||
| reason | No | ||
| created | No | ||
| warning | No | ||
| cancelled | No | ||
| nodeCount | No | ||
| incomplete | No | ||
| workspaceID | No | ||
| createdNodes | No | ||
| cleanupFailures | No | ||
| STOP_AND_CONFIRM | No | ||
| failedPlanNodeID | No | ||
| cleanupFailedNodeIDs | No |