Create Oracle Analytics Cloud (OAC) agents directly from your favorite AI coding tool, such as Codex, Claude, Cursor, or any other tool that supports skills.
Skills are reusable packages of instructions, scripts, and references that guide an AI assistant through a specific workflow. In this case, the OAC Agent Builder Skill helps your AI coding tool generate OAC agents using a consistent, repeatable process aligned with best practices. The Skill can push and save the generated agent directly into your OAC instance.
What The Skill Does
The skill helps automate the main steps required to create an effective Oracle Analytics Cloud agent:
- Indexes the selected dataset.
- Analyzes sample data to better understand the business context.
- Generates supplemental instructions for the agent.
- Builds a polished welcome message.
- Adds document knowledge.
- Helps draft, refine, and iterate on the final agent configuration.
- Saves the generated agent directly in Oracle Analytics Instance.
Instead of manually preparing every part of the OAC agent, you can describe what you want, provide your dataset name, and let the skill guide your AI coding tool through the process.
How To Use It
To create an agent, provide two key pieces of information:
- The name of the dataset you want to use.
- The goal of the agent you want to create.
Create an OAC agent using the “Sales Orders” dataset. The goal is to help sales managers analyze revenue, margins, customers, and product performance…
The skill will search for the dataset in your OAC instance, inspect its structure, query sample rows, and use that context to propose a draft version of the agent. The more context you provide, the better the results. Consider including business goals, target users, preferred terminology, custom calculations, examples of questions users are likely to ask and other relevant details.
Once you approve the draft, the skill can create and save the agent directly in your OAC instance, including its instructions, welcome message, dataset indexing configuration, and document knowledge.
Final Thought
The Oracle Analytics Agent Builder Skill gives you a faster and more reliable way to create OAC agents. It brings together dataset discovery, instruction generation, welcome message creation, and few-shot knowledge setup into one guided workflow.
You still stay in control of the final result, but the repetitive work is handled for you. That means more time spent refining the agent experience and less time wiring everything together manually.
This document is intended solely for community knowledge sharing and demonstration purposes. It is not official Oracle documentation and should not be considered as formal Oracle guidance or support documentation.
