avhrst/apex-component-modifier
Developer toolsこのページは AI により自動翻訳されています。技術的な詳細は原文をご確認ください。 原文を見る
AI CLI Skills for Oracle APEX
概要
A that exports Oracle APEX components, modifies the exported files, applies DB changes, and imports everything back — using . The skill gives Claude Code the ability to directly modify your Oracle APEX application by: 1. a component (page, region, LOV, etc.) via SQLcl split export 2. bundled APEX 24.2 import-API reference docs to understand the export format 3. (CREATE TABLE, ALTER, PL/SQL packages) via SQLcl 4. the exported SQL files with the requested modifications 5. the patched component back into APEX via SQLcl 6. the result (compilation checks, re-export diff) All steps run through SQLcl CLI via the Bash tool — no manual SQL or file editing required. This repo also provides read-only skills for inspection and pattern learning: - Claude Code CLI installed - SQLcl 25.1+ with Java 17 or 21 The skill runs SQLcl commands via the Bash tool. Verify it's available: Open SQLcl and save a connection to your APEX database:
README
以下は原文 README の抜粋です。原文を見る。
Oracle APEX Component Modifier
A Claude Code Skill that exports Oracle APEX components, modifies the exported files, applies DB changes, and imports everything back — using Oracle SQLcl CLI.
What It Does
The skill gives Claude Code the ability to directly modify your Oracle APEX application by:
- Exporting a component (page, region, LOV, etc.) via SQLcl split export
- Reading bundled APEX 24.2 import-API reference docs to understand the export format
- Applying DB changes (CREATE TABLE, ALTER, PL/SQL packages) via SQLcl
- Patching the exported SQL files with the requested modifications
- Importing the patched component back into APEX via SQLcl
- Validating the result (compilation checks, re-export diff)
All steps run through SQLcl CLI via the Bash tool — no manual SQL or file editing required.
Supported Components
| Category | Components |
|---|---|
| Page-level | Pages, regions, page items, buttons, processes, computations, branches |
| Dynamic actions | Events, actions (full DA lifecycle) |
| Validations | Page and item-level validations |
| Reports | Interactive Reports (IR), Interactive Grids (IG), Classic Reports |
| Visualizations | JET Charts (bar, line, pie, etc.), Maps |
| Cards | Cards regions, card components, media, actions, icons |
| Forms | Form regions with DML processes |
| Faceted Search | Faceted search regions and facets |
| Navigation | Navigation menus, lists, breadcrumbs |
| Automation | Automations (actions, schedules) |
| Web sources | REST data sources and web source modules |
| Shared components | LOVs, authorization schemes, list entries, templates, build options, static files |
Companion Skills
This repo also provides read-only skills for inspection and pattern learning:
| Skill | Invocation | Purpose |
|---|---|---|
| apex-describe | /apex-describe PAGE:5 |
Describe an APEX page or component by reading its export |
| apex-export | /apex-export PAGE:5 |
Export a component without modification (read-only) |
| apex-learn | /apex-learn |
Export all components from an app, analyze conventions, and generate pattern files for future patching |
| sqlcl | /sqlcl |
General-purpose Oracle DB operations — SQL, schema inspection, data ops, Liquibase, Data Pump, CI/CD projects |
Prerequisites
- Claude Code CLI installed
- SQLcl 25.1+ with Java 17 or 21
Installation
1. Copy the skill into your project
cd your-project
# Clone the repo into a temp directory and copy the skill
git clone https://github.com/avhrst/apex.git /tmp/apex-skill
mkdir -p .claude/skills推奨ツール
別のキーワードを試すか、フィルタを外してください。
インストール
npx skillfish add avhrst/apex-component-modifier