apex — Claude Code & Codex skill: Oracle APEX development
A skill set for APEXlang work in Oracle APEX: generation, compilation, deployment and inventory. Useful when your agent needs to know how an APEX project is laid out.
npx skills add oracle/skills --skill apex -a claude-codeWhat apex does
The apex skill is a domain with routing by Oracle APEX version. Two branches live inside: apex/apexlang/26.1 and apex/apexlang/26.2. The 26.1 branch covers APEXlang generation, compilation, deployment, inventory and example applications. The 26.2 branch has no generation — only compilation, deployment, inventory and examples.
Everything starts at apex/apexlang/SKILL.md. From there the agent routes into the matching version and reads only the file or category the task needs. The skill lists its own entry points: apex/apexlang/26.1/SKILL.md, apex/apexlang/26.2/SKILL.md, and the reference files under apexlang-generation/references.
Ask for APEXlang generation on an APEX 26.2 project and the agent hits an empty branch, because that category isn't there. Check which APEX version your project runs before you call the skill.
What it helps with
- generate APEXlang for an APEX 26.1 application
- compile APEXlang files against the right APEX version
- deploy an application from APEXlang to an environment
- build an inventory of APEX application objects
- walk through the structure of an APEXlang example application
Example prompts for the agent
- show me the structure of the apex skill and which branches exist for APEX 26.1 and 26.2
- generate APEXlang for my APEX 26.1 application
- compile the APEXlang under
apex/apexlang/26.2and deploy it
How to install apex
1Skills CLI (Vercel)
npx skills add oracle/skills --skill apex -a claude-code2Manually: put the files in place
~/.claude/skills/apex/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/apex/
1Skills CLI (Vercel)
npx skills add oracle/skills --skill apex -a codex2Manually: put the files in place
.agents/skills/apex/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add oracle/skills --skill apex -a cursor2Manually: put the files in place
.cursor/skills/apex/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install oracle/skills apex2Manually: put the files in place
.github/skills/apex/SKILL.md1Skills CLI (Vercel)
npx skills add oracle/skills --skill apex -a gemini-cli2Platform CLI
gemini skills install https://github.com/oracle/skills --path apexManually: put the files in place
.devin/skills/apex/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add oracle/skills --skill apex -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about apex
How do I install apex in Claude?
Run npx skills add oracle/skills --skill apex -a claude-code. The skill file then sits at ~/.claude/skills/apex/SKILL.md.
What does the apex skill do?
It gives the agent version routing for Oracle APEX plus tasks around APEXlang: generation, compilation, deployment, inventory and example applications.
How do the 26.1 and 26.2 branches differ?
The 26.1 branch includes the apexlang-generation category; 26.2 does not. Compilation, deployment, inventory and example applications appear in both.