Skip to content
uc-apx

Changelog

v26.1 — First public release (2026-06-02)

Section titled “v26.1 — First public release (2026-06-02)”

The first public release of uc-apx, the command-line companion for Oracle APEX applications exported in the APEXlang (.apx) format that ships with Oracle APEX 26.1.

uc-apx is a single static Go binary — no runtime, no Node.js, no Python. Drop it on your PATH and start reading, scaffolding, and validating APEXlang apps, whether you’re a developer at the terminal or an AI agent driving it programmatically. Output is minified JSON by default (directly parseable), with --json-pretty for humans and --toon for token-efficient agent workflows.

Read

Section titled “Read”

Inspect any part of an exported app without opening APEX Builder:

  • overview — app summary with file and component counts by kind.
  • pages / page / tree — list pages, drill into a single page, or render its hierarchy. Page detail is summary-by-default with a --detail flag for the full recursive property tree.
  • search — case-insensitive full-text search across names, IDs, SQL, and PL/SQL.
  • lov, component, list — resolve any construct by id, name, or kind.
  • refs / deps — follow @-references across files to trace what uses what, upstream and downstream.
  • schema — static database-dependency analysis. Scans every SQL/PL-SQL fragment and reports the DB objects referenced (with per-object usage sites), refined by any local CREATE DDL the app ships.
  • page-groups — list groups and their member pages; flags empty groups and phantom references.
  • auth schemes / usage / audit — whole-app authorization insights, including negation-aware (!@scheme) usage counts.
  • shape — observed property/block/child shape of any construct kind, plus embedded reference templates for every creatable region, column, and page-item type.

Scaffold

Section titled “Scaffold”

Create constructs from bundled templates, with every output verified against Oracle’s official validator:

  • create page — seven page types (blank, form, classic-report, interactive-report, interactive-grid, dashboard, modal-dialog).
  • create region — interactive grid, interactive/classic report, form, cards, chart, faceted-search, flexbox-container, and the Universal-Theme components (avatar, comments, content-row, timeline, metric-card, media-list).
  • create for buttons, page-items, dynamic actions (refresh-on-dialog-close, toggle, run-js, set-value, execute-plsql), processes (PL/SQL, close-dialog, clear-session-state), validations, computations, branches, LOVs, lists, breadcrumbs, page-groups, and authorizations.

Edit & Delete

Section titled “Edit & Delete”

Surgically reshape an app without re-scaffolding whole pages:

  • edit column / edit page-item — switch type, attach an LOV, add a default, toggle read-only/required, set help text, convert to avatar/badge.
  • edit authorization / edit page — rewrite schemes or assign page-groups and page-level authorization in place.
  • delete <kind> — remove any construct, with a reference-safety check that blocks deletion when something still points at the target (override with --force); every write reparses and rolls back on failure.

Validate

Section titled “Validate”
  • validate — fast local structural checks (duplicate IDs, broken references, missing names, empty pages).
  • validate --official — wraps SQLcl’s apex validate for authoritative, full-MMD-schema validation. Everything uc-apx scaffolds passes it.

Skills

Section titled “Skills”
  • skills list / skills sync — discover and install bundled Claude Code skills for reading, editing, and verifying APEXlang apps.

Format support

Section titled “Format support”

Built for APEXlang as it ships in Oracle APEX 26.1. Handles both the GA 26.1.0+3102 export format and the earlier 26.1.0-62 pre-release format.