How to Use Select AI Supervisor Agent Teams

Create the agent to serve as the supervisor and designate it as a supervisor, create worker agents, add the supervisor to the team attributes, and run user prompts against the team.

  1. Grant the required privileges. The database user must have EXECUTE privilege on DBMS_CLOUD_AI_AGENT, access to required credentials, and the required network ACLs for external provider calls. See Prerequisites for Using Select AI Agent for more information.
  2. Create the tools that worker agents use, such as PL/SQL functions for lookup, update, notification, or reporting tasks. See DBMS_CLOUD_AI_AGENT Package and Examples of Using Select AI Agent for more information.
  3. Create worker agents and tasks. Keep each worker role specific so the supervisor can select the right worker for each subtask. See CREATE_TASK Procedure and CREATE_AGENT Procedure.
  4. Create a supervisor agent with the supervisor attribute set to true. See CREATE_AGENT Attributes.
  5. Create the team with supervisor_agent set to the supervisor agent name and agents set to the worker agent-task pairs. See CREATE_TEAM Procedure.
  6. Set the team for the session and submit natural language prompts with the Select AI Agent framework. See SET_TEAM Function.
  7. Review history views to confirm worker routing, returned results, worker failures, and human-input wait states. If a worker task requests human input, the team pauses until the user responds. The entire supervisor-led team pauses during this time. Continue the same conversation to provide the requested input. After the user responds, the worker resumes, completes the task, and returns the result to the supervisor. The supervisor then decides the next action. See DBMS_CLOUD_AI_AGENT Views.

Do not include the selected supervisor from the array of worker agents. The supervisor controls the team, while the array lists only worker agent-task pairs available for delegation. A worker task can use its own configured tools; the team attribute does not list tool names.

Note: Supervisor-led teams process worker subtasks sequentially. The supervisor waits for each worker result before delegating another subtask. Parallel worker execution is not part of this release.