Generate applications you can trust
To facilitate the AI generation of Oracle APEX applications, we are introducing new open application specification language (APEXlang) that allows developers generate secure, scalable modern applications with their favorite AI agent. Applications generated with APEXlang are built on Oracle APEX’s proven model-based design and secure, high-performance engine.
Open Specification Application Language (APEXlang)
APEXlang is Oracle’s open specification application language designed for AI-assisted application development for data centric business applications with Oracle APEX. It provides a structured, human-readable format for describing applications, business logic and user experiences that AI agents can generate. By using APEXlang, developers can create secure, scalable modern applications faster while also leveraging Oracle APEX’s proven model-driven architecture and high-performance runtime engine.
Generate Oracle APEX apps with your favorite AI agent
Getting started with APEXlang
1
Download & install Oracle APEX 26.1
Oracle APEX 26.1 introduces support for APEXlang and generative development workflows, making it easier to build AI-assisted enterprise applications. Oracle APEX provides the secure, scalable low-code platform and proven runtime engine used to develop and deploy modern applications.
Oracle APEXlang requires Oracle APEX 26.1. Previous versions of Oracle APEX are not supported, so be sure you've upgraded your instance.
2
Download and install SQL Developer or SQLcl
SQL Developer for VS Code and SQLcl provide the tools needed to manage database objects, work with application exports, and interact with APEXlang specifications. Either is needed to install & compile APEXlang-based applications.
Note: version 26.1.2 or greater is required
3
Clone the APEXlang Skills
The APEXlang Skills repository includes reusable prompts, workflows, and AI-assisted development patterns designed for Oracle APEXlang. These skills help AI agents better understand application structure, business logic, and development best practices.
To install APEXlang skills:
- Run SQLcl: sql /nolog
- Enter the following command: skills sync
- All Skills will download and be available in all popular AI agents
4
Generate your applications
APEXlang enables developers to use their preferred AI agent to generate applications, pages, business logic, and user experiences from structured specifications or ad-hoc statements.
To generate your application:
- Start up your preferred AI agent
- Ensure that your SQLcl MCP server is installed & configured
- Enter prompts or provide specs to the AI agent and watch as it generates APEXlang files
- Connect to your schema and import the APEXlang
APEXlang Skills: What can you do?
Translations
"Translate my application to Spanish"
Generate and manage application translations across pages, labels, messages, and user interface components using Oracle APEX 26.1's new message-based translations. APEXlang helps AI agents understand application context, making multilingual updates faster, more accurate, and easier to maintain.
Help text
"Add help text to my forms"
Automatically create clear, contextual help text for pages, regions, items, and business processes. AI-generated help content improves usability and helps users understand application workflows without manual documentation effort.
PL/SQL refactoring
"Refactor my PL/SQL processes to a package"
Modernize and refactor PL/SQL code for readability, maintainability, and performance, including migrating it from APEX processes to PL/SQL packages. APEXlang enables AI agents to understand application logic and safely recommend or generate improvements while preserving business functionality.
PII identification and protection
"Identify items and columns that contain PII and secure them with a role"
Identify sensitive personally identifiable information (PII) in items and report columns and apply corresponding authorization schemes. AI-assisted analysis can quickly fortify an application and protect sensitive data from unauthorized users.
Page layout
"Move the sales chart down one row"
Generate and optimize page layouts using nothing more than plain English. AI agents can translate the request into APEX-specific attributes to reorder or rearrange content on a page.
Cross page changes
"Add a breadcrumb region to all of my pages"
Apply updates across multiple pages or components from a single specification-driven change. APEXlang helps developers automate repetitive modifications while maintaining consistency throughout the application.
Spec to application with APEXlang
Spec-to-application development with APEXlang transforms ideas, requirements, and business processes into secure, scalable Oracle APEX applications using AI-assisted workflows. By combining structured specifications with Oracle APEX’s proven platform, teams can accelerate development while maintaining transparency, consistency, and control throughout the entire application lifecycle.
Requirements
The requirements phase focuses on gathering and organizing all available information about the application, regardless of format. Teams can use existing documentation, spreadsheets, screenshots, whiteboard photos, meeting notes, mockups, and business process descriptions to help AI agents understand the desired outcome. The LLM helps refine and structure these inputs into clear, actionable requirements that can be used throughout the application development lifecycle.
Data model and sample data
Once requirements are refined, the next phase is building the application’s data model and foundational prerequisites. AI agents can identify business entities, relationships, validation rules, and required database objects from the requirements and convert them into a structured schema design. This creates a strong foundation for secure, scalable application generation while ensuring consistency between business requirements and underlying data structures.
Specifications
The specification phase transforms requirements and data models into a complete application specification that will be consumed by APEXlang. These specifications define pages, components, workflows, business rules, security requirements, and user experiences in a structured, AI-friendly format. By creating a clear application specification, development teams can align business stakeholders, developers, and AI agents around a single source of truth before generation begins.
Generation
During application generation, AI agents use the specification to generate an application by embedding business logic, user interfaces, and supporting components into APEXlang files. Because APEXlang is built around Oracle APEX’s model-driven architecture, generated applications follow established best practices for scalability, maintainability, performance, and security. This phase dramatically accelerates development while still producing enterprise-ready applications developers can fully understand and maintain.
Refinement
Application refinement is an iterative phase focused on improving and evolving the generated application after initial delivery. Developers and stakeholders can identify missing functionality, adjust layouts, refine workflows, or incorporate new requirements, then use APEXlang to quickly apply those changes consistently across the application. This approach enables rapid iteration and continuous improvement without requiring large-scale manual redevelopment.