Skill: source retrieval

[Case 2]

• Initial Environment: A multi-database environment contains several semantically similar schemas. The agent receives a user request but the target database is not explicitly named.
• Real Question: which semester the master and the bachelor both got enrolled in
• Real Trajectory: Retrieve candidate databases, inspect returned schema fragments, notice that a required degree_program relation is missing from the current candidate set, expand retrieval, and only then write the final SQL.
• Real Answer: A correct answer requires bringing the missing target database schema into context before composing SQL.
• Why this demonstrates the capability: The question is deceptively short and underspecified. It demonstrates source retrieval because the key failure mode is not merely choosing the wrong column but failing to recall the correct database at all. The successful trajectory therefore begins with retrieval repair rather than immediate SQL drafting.

Pipeline Execution Instructions

To synthesize data for this capability, you must strictly follow a 3-phase pipeline. Do not hallucinate steps. Read the corresponding reference file for each phase sequentially:

1. Phase 1: Environment Exploration Read the exploration guidelines to discover raw knowledge seeds: references/EXPLORATION.md

2. Phase 2: Trajectory Selection Once Phase 1 is complete, read the selection criteria to evaluate the trajectory: references/SELECTION.md

3. Phase 3: Data Synthesis Once a trajectory passes Phase 2, read the synthesis instructions to generate the final data: references/SYNTHESIS.md