Leverage the data regions already defined in your on-premise APEX applications — no duplicated SQL, no new models. Each region becomes a documented, token-secured REST endpoint, discoverable through an OpenAPI 3.0 catalog and ready to plug into Claude, ChatGPT, and enterprise integrations.
Every time you need to expose APEX data externally, you face the same tedious work. There's a better way.
A complete API platform for Oracle APEX — from data exposure to security, documentation, and monitoring.
Query Interactive Reports, Interactive Grids, Classic Reports, Charts, and any SQL-based region by static ID. No hardcoded SQL required.
Every region gets a dedicated /schema endpoint returning JSON Schema with column names, data types, and formats. Self-documenting APIs.
Built-in offset/limit pagination with navigation links, hasMore detection, and configurable page sizes up to 1,000 rows per request.
Pass APEX page items and values through the API to drive filters, computations, and conditional logic — just like a real APEX session.
Access named saved reports and alternative views — REPORT, CHART, GROUP_BY, and PIVOT modes — all through the same endpoint.
Choose from Simple, ORDS-compatible, or JSON:API response formats with full pagination metadata and navigation links.
A single /catalog endpoint returns a full OpenAPI 3.0 document describing every REST-enabled region, saved report, view mode, and bind variable — scoped to your bearer token.
Ships with a ready-to-use apex-rest-query skill plus an OpenAI agent manifest. Drop it into Claude or ChatGPT and agents can discover, introspect, and query your APEX data autonomously.
Generate short-lived preview tokens for safe demos and testing. Centralized configuration table lets you tune defaults — page size, JSON format, host — without redeploying code.
APEX REST Services ships with a packaged AI skill and an OpenAI agent manifest — so modern LLMs can discover, introspect, and query your APEX regions the moment they're exposed.
Agents start by calling /catalog to find the right application, page, region, saved report, and view mode — no guessing, no prompt engineering.
The apex-rest-query skill bundles a Python CLI (catalog, find, schema, data, query) that Claude invokes to answer data questions safely.
A ready agents/openai.yaml exposes the skill as a ChatGPT agent with allow-implicit-invocation — plug it into an Assistants workflow in minutes.
Tokens are loaded from environment, local .env, or the OS keychain — never hardcoded. Every agent call flows through the same AES-256 token + application whitelist.
Get up and running in under 15 minutes with a single SQL install script.
Run @install.sql in your Oracle schema. Packages, views, and ORDS module are deployed automatically.
Register API tokens, set allowed applications, and choose your preferred JSON response format.
Call /apex/regions/catalog to fetch an OpenAPI 3.0 document listing every region, saved report, and view mode available to your token.
Hit /data from any frontend, BI tool, or AI agent — or drop in the bundled Claude skill / OpenAI manifest and let the agent do it.
Choose the format that fits your client — from minimal arrays to fully compliant JSON:API structures.
AES-256 encrypted tokens, application whitelisting, full audit trails, and integration with APEX authorization schemes.
Cryptographically generated 32-byte tokens stored with AES-256-CBC encryption and PKCS5 padding.
Control exactly which APEX applications each API token can access. Granular per-token restrictions.
Every token creation, modification, and API request is logged with timestamps, users, and context.
Set expiration dates on tokens for temporary access grants. Expired tokens are rejected automatically.
From mobile apps to AI-powered dashboards — ARS fits wherever your data needs to go.
Build React, Angular, or Flutter apps powered by your existing APEX regions. No backend rewrite needed — your APEX SQL is the API.
Ship the bundled Claude skill and OpenAI agent manifest and let agents auto-discover regions through the OpenAPI catalog — no custom tool wiring required.
Connect Power BI, Tableau, or custom dashboards directly to APEX data via standard REST. Real-time data, no ETL pipelines required.
Expose APEX data to ERP, CRM, and third-party systems using standard HTTP and JSON. Works with any integration platform.
Decouple your data layer from the APEX UI. Serve the same data to web, mobile, IoT, and partner channels from a single source of truth.
Automated test suites can validate APEX region data through REST calls. Includes a ready-made test harness with 12+ test scenarios.
Built on proven Oracle technologies. No external dependencies. Installs in your existing environment.