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.

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
  1. Oracle references, on demand

    Retrieve the relevant syntax and component guidance instead of loading the whole reference into every exchange.

  2. Focused context, less repetition

    Project summaries, metadata batches and programmatic job waiting help avoid repeated discovery and oversized tool replies.

  3. Your database, your connection

    Use a saved direct SQLcl connection or ORDS over HTTPS when the database listener is unavailable.

  4. 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.

  1. 01
    SCOPE

    Identify the application.

    Describe the change and name the project and environment. Codex checks the available app and database context.

  2. 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.

  3. 03
    CHECK

    Validate before import.

    Run the relevant source and compiler checks. The deployment plan records the source, toolchain and target.

  4. 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.

  5. 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

One session by default.
A team when you choose.

Start with the Codex conversation you already have. Enable a reviewed team only when you want separate agents for the work.

DEFAULTSINGLE

Your current Codex session

Single mode works directly in the open conversation, using its model and permissions. It starts no extra agent and opens no panel automatically.

  • Describe the task with $apexrest-work
  • Continue edits in the same conversation
  • Open settings and the panel when needed
Compare the work modes
EXPLICIT OPT-INTEAM

A reviewed agent team

Enable Agent team in Settings to use separate developer sessions, manager code review, independent QA and final manager review.

  • Auto model routing for enabled teams
  • Panel for progress, reviews and APEX jobs
  • The reviewed result returns to your conversation
Explore the team workflow

05 / GET STARTED

BETA · 0.4.0-beta.1

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.

  1. Open the terminal menu

    Run the commands shown here. npm installs the CLI; plugin registration is the next step.

  2. Prepare tools and register

    Choose Install tools for missing dependencies, review the Oracle terms, then choose Install plugin.

  3. Start a new Codex task

    Restart Codex, open a new task and ask APEXREST to check your setup before your first application change.

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

Beta, with visible limits.

Version 0.4.0-beta.1 is published on npm. The project records local tests, native-host checks and Oracle evidence separately. Integration, recovery and platform gaps remain before a stable release.

Review verification status

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 ↗