APEXREST FOR CODEX / OPEN-SOURCE PLUGIN

Oracle APEX.
Built with
Codex.

Create and change Oracle APEX applications in your Codex conversation. APEXREST brings the APEX tools, source checks and controlled imports into the same workflow.

Install the plugin Read the docs

01Your current Codex session

02Readable, versioned source

03Imports within your approval

FROM REQUEST TO CHECKED SOURCE

You describe. Codex builds.APEXREST / ORACLE APEX

Illustrative workflow. No live execution.

YOUR CODEX CHATAPEXREST TOOLSORACLE APEXYOUR SCOPE · YOUR RELEASE DECISION

01 / EVERYDAY APEX WORK

Start from a task you already have.

For APEX developers and teams building business applications on Oracle Database: a new app, an existing page, a dashboard or a change that needs checking.

01 / CREATE

Start a new application

Generate APEXlang from a blank app or customer CRM template, then adapt it to your requirements.

02 / ADOPT

Work on the app you have

Export into a new project while preserving Oracle IDs and application metadata. Keep the source in version control.

03 / EDIT

Change pages and components

Update forms, reports and shared components with changes scoped to your request.

04 / DATA

Build useful dashboards

Use real database queries, native APEX regions and filters that submit values and refresh the relevant content.

05 / DELIVER

Plan and import a change

Check the named target, bind the plan to the reviewed source and back up an existing application before import.

06 / VERIFY

Test and diagnose

Run the configured SQL, API or browser checks. Inspect diagnostics and repair failures with the evidence available.

02 / WHY APEXREST

APEX knowledge.
Tools that check the work.

APEXREST gives Codex specialist skills and tools for Oracle APEX. The application definition lives in readable .apx files; Oracle SQLcl checks it before an authorized import.

Keep the request, source changes and verification in one conversation.

How Oracle APEX works

Component and pattern catalogs
Offline catalogs cover 109 component families and 58 reusable UX patterns with compiler-checked APEXlang recipes. Codex retrieves only what the change needs.
Focused context, less repetition
Project summaries, metadata batches and bounded job waiting help avoid repeated discovery and oversized tool replies.
Your database, your connection
Use a saved direct SQLcl connection or ORDS over HTTPS when the database listener is unavailable.
A real application platform
Oracle APEX supplies forms, reports, authentication and workflow on Oracle Database: a production-grade foundation for your application.

03 / THE WORKFLOW

From a request
to a checked change.

EXAMPLE / EXISTING APP

Add an order status report. Preserve the existing pages and authentication. Import into the named test app and verify the filter.

01
SCOPE
Identify the application.
Describe the change and name the project and environment. Codex checks the available app and database context.
02
BUILD
Edit readable source.
Create or adopt the application, then make bounded changes in APEXlang. Keep schema and data migrations versioned alongside the app.
03
CHECK
Validate before import.
Run the relevant source and compiler checks. The deployment plan records the source, toolchain and target.
04
AUTHORIZE
Keep the target explicit.
Your request to update an identified development or test app can authorize that scoped import. An existing app is backed up first.
05
VERIFY
Check the running result.
After import, run the configured tests and relevant browser checks. Report failures and missing checks so you can assess the result.

PRODUCTION IS A SEPARATE GATE

Production requires externally signed approval on a protected runner. AI output still needs review and testing; compiler validation alone does not prove runtime correctness.

Read the deployment safeguards

04 / YOUR WAY OF WORKING

Your conversation.
A panel when you need it.

APEXREST works in the Codex conversation you already have. Codex keeps the model and permissions; APEXREST supplies the Oracle APEX operations.

HOW YOU WORKCHAT

Your current Codex session

Describe the change in the open conversation. Implementation starts there, with its existing context, model and permissions. No extra agents and no plugin startup call.

Describe the task or use $apexrest-work
Show all functions with $apexrest-menu
Continue edits in the same conversation

Read the chat workflow

WHEN USEFULPANEL

The development panel

Open $apexrest-panel for project and connection settings, Oracle/APEX jobs and diagnostics. The panel cannot grant authorization or apply a plan on its own.

Direct Oracle listener or ORDS HTTP(S)
Actual job results and diagnostics
In-app or external verification browser

Explore the panel

05 / GET STARTED

NPM LATEST · 1.2.0

Bring APEX
into Codex.

Install the CLI. Register the plugin. Start with a setup check.

The public npm package includes the runtime and resources. Use Node 24 LTS and a Codex host with native plugin support.

Open the terminal menu
Run the commands shown here. npm installs the CLI; plugin registration is the next step.
Prepare tools and register
Choose Install tools for missing dependencies, review the Oracle terms, then choose Install plugin.
Start a new Codex task
Restart Codex, open a new task and ask APEXREST to check your setup before your first application change.

Full installation guide View source on GitHub

INSTALL FROM NPMAPACHE-2.0

A short path to your first task.

npm install -g apexrest
apexrest --version
apexrest

This installs the npm latest release, 1.2.0 at the time of writing; pin it with [email protected]. Installing the CLI does not register the Codex plugin or deploy an application.

YOUR FIRST REQUEST

Use APEXREST to check my setup. Report the compiler, connection and target checks that still need attention.

For connected Oracle work

Java 21 and reviewed SQLcl 26.1.2
An existing Oracle APEX 26.1+ target
A saved SQLcl connection or private ORDS credentials

Keep passwords in the local connection settings, outside chat prompts.

Already have the tools? Register directly

codex plugin marketplace add apexrest-dev/apexrest-codex
codex plugin add apexrest-apex@apexrest

Using Codex Cloud?

A separate guide covers command-line tools with ORDS over HTTPS. Native Cloud plugin discovery, MCP and panel support are not established; the full Cloud workflow still needs end-to-end verification.

Read the Cloud setup guide

Released, with visible limits.

Version 1.2.0 is the npm latest release; 1.3.0-beta.1 previews experimental Composer and working-copy workflows. The project records local tests, compiler evidence and Oracle checks separately. Connected imports, recovery and broader platform checks remain open.

Review verification status

06 / DOCUMENTATION & SOURCE

Go deeper where
you need to.

apexrest / npm

STARTInstallation and first application GUIDESAll plugin documentation CONNECTSQLcl and ORDS connections CONTROLImport and release safeguards STATUSEvidence and remaining checks CHANGESWhat changed in each release

YOUR NEXT APEX CHANGE

Bring a real task to Codex.

Start with a development or test application, describe the change and let APEXREST guide the source checks, authorized import and verification.

Install the plugin Discuss your project ↗

Oracle APEX.Built with Codex.

Start from a task you already have.

Start a new application

Work on the app you have

Change pages and components

Build useful dashboards

Plan and import a change

Test and diagnose

APEX knowledge.Tools that check the work.

Component and pattern catalogs

Focused context, less repetition

Your database, your connection

A real application platform

From a requestto a checked change.

Identify the application.

Edit readable source.

Validate before import.

Keep the target explicit.

Check the running result.

Your conversation.A panel when you need it.

Your current Codex session

The development panel

Bring APEXinto Codex.

Open the terminal menu

Prepare tools and register

Start a new Codex task