uc-apx – APEXlang CLI

uc-apx is a CLI that parses Oracle APEX applications exported in the APEXlang (.apx) format and produces structured output for developers, scripts, and AI agents. It ships as a single static binary with no runtime dependencies.

Key Features

Read Any Component

Query pages, regions, items, LOVs, processes, validations, branches — any construct in the APEXlang tree — by ID, name, or kind.

Scaffold Fast

Create pages, regions, buttons, validations, computations, branches, and more from bundled templates with a single command. Every output passes Oracle’s official apex validate.

Official Validation

Wrap SQLcl’s apex validate to verify your app against Oracle’s full MMD schema — not just structural checks, but real semantic validation.

LLM & Agent Friendly

TOON output is compact and readable by AI agents. Use --json for structured JSON. Both formats are always in sync.

Single Binary

Written in Go. No runtime, no Node.js, no Python. One binary, drop it on your PATH and start using it.

Cross-Reference Aware

refs, deps, and lov commands follow @-references across files so you can trace what uses what across your entire application.

Edit in Place

edit column and edit region rewrite existing constructs without rescaffolding the whole page. Combined with delete, you can surgically reshape any part of the app.

APEXlang 26.1 Native

Built for the APEXlang format that ships with Oracle APEX 26.1. Handles both the GA 26.1.0+3102 and pre-release 26.1.0-62 export formats.

What uc-apx Does

uc-apx has two main responsibilities:

Read — inspect any part of an exported APEX application:

uc-apx --app-dir my-app overview          # summary: pages, component counts
uc-apx --app-dir my-app pages             # list all pages
uc-apx --app-dir my-app page 1            # full detail for page 1
uc-apx --app-dir my-app tree 1            # hierarchical outline
uc-apx --app-dir my-app search "DEPTNO"   # full-text search
uc-apx --app-dir my-app lov EMP_DEPTNO    # LOV + where it's used
uc-apx --app-dir my-app schema            # tables/columns referenced in SQL

Scaffold & verify — add constructs and validate the result:

uc-apx --app-dir my-app create page --id 10 --name "Employees" --type interactive-report
uc-apx --app-dir my-app create region interactive-report --page 10 --name "Employees" --sql "select * from emp"
uc-apx --app-dir my-app validate --official   # wraps SQLcl apex validate

Who It’s For

• APEX developers who want a fast command-line way to explore and modify exported apps without opening APEX Builder
• AI coding agents that need structured, parseable output to understand and modify APEX applications programmatically
• CI pipelines that want to validate APEXlang exports before committing or deploying

Support

Need a hand? See Support for community help via GitHub issues, plus enterprise support, training, and consulting from United Codes.