Idea Summary
APEX Assistant works with hardcoded System Prompts. There are now few in use - SQL, PL/SQL, Javascript, CSS, HTML specific ones, depending on the type of region developers are getting help on. We need a way to replace the System Prompt with another one (DeveloperAdmin defined).
We would also benefit from being able to use custom skills, similar to the experience we have in VSCode or other tools. This can be achieved by attaching a file or picking from a list of predefined list of skill files. There could be an option to sync the Skills, similar again to how we sync them in VSCode, Claude Code, etc.
And since using Skills would increase the token usage, this option should be available to tun on/off by the developer.
Use Case
The Hardcoded System prompts are no longer the only option to guide the AI Agents. Skills have been very beneficial and provide far better final results. That's why I think they should be integrated into the APEX Assistant if we want to make it really useful for developers.
Preferred Solution (Optional)
Add two new options for the APEX AI Assistant:
-
Developers (and/or Workspace Admins) can define new System prompts for SQL, PL/SQL, Javascript, CSS and HTML regions, replacing the hardcoded ones.
-
Developers (and/or Workspace Admins) can define a number of skills to be used by the APEX AI Assistants - either directly or by providing a URL or link to Application/Workspace files.
-
Developers should be able to turn ON/OFF the Skills feature.