Show setup requirements and instructions for this APEX MCP server.

Verify Oracle connection, APEX workspace, and grants are configured.

Check Oracle grants and APEX object access permissions.

Auto-fix common Oracle permission issues (grants, synonyms).

Refresh Universal Theme 42 template IDs from the live database.

Run APEX health check: score 0-100 with issues list.

Get audit log of recent MCP operations in this session.

Connect to Oracle ADB via mTLS wallet. Must be called first.

Execute any SQL statement (SELECT/DML/DDL). Returns rows or affected count.

Show current connection status, session state, and active app.

List all APEX applications in the workspace.

Create a new APEX app and start an import session. Call apex_finalize_app() when done.

Finalize and commit the app. Must be called after all pages/components are added.

Delete an APEX application permanently.

Export an app as SQL install script.

Describe a page's components in human-readable text.

Toggle dry-run mode: log PL/SQL without executing. Returns log when disabled.

Undo the last created component (region, item, button, etc.).

Add a new page to the app. page_mode: Normal or Modal Dialog.

List all pages in the current session or an existing app.

Add a region to a page. Types: STATIC, IR (Interactive Report), PLSQL, chart, blank.

Add a form item. Types: text, number, date, select, textarea, hidden, yes_no, display_only. Auto-prefixed P{page_id}_.

Add a button to a region (CREATE, SAVE, DELETE, CANCEL, or custom).

Add a page process: PL/SQL block, DML on table, or branch redirect.

Add a dynamic action (client-side event handler). Actions: execute_javascript, set_value, refresh, show, hide, submit.

Create a List of Values (LOV) — static or SQL-based — for select items.

Create an authorization scheme (IS_ADMIN, IS_MANAGER, etc.).

Add a navigation menu item linking to a page.

Create an application-level item (global variable available on all pages).

Create an application-level process (runs on every page load or session init).

List all tables/views in the current Oracle schema with row counts.

Describe table columns, types, PKs, and FKs. Cached per session.

Auto-detect FK relationships between a list of tables.

Generate full CRUD: IR list page + form page with DML processes for a table.

Generate a dashboard page with KPI metric cards and JET charts.

Generate a login page (page 101) with APEX authentication.

Create an APEX workspace user with role (ADMIN/DEVELOPER/END_USER).

List all users in the APEX workspace.

Add inline JavaScript to a specific page.

Add global JavaScript to all pages via Page 0.

Create an AJAX callback process (PL/SQL) callable from client-side JS.

Get full metadata for an existing APEX app (pages, auth, theme).

Get all components on a page (regions, items, buttons, processes).

List regions on a page of an existing app.

List items on a page of an existing app.

List page processes of an existing app.

List dynamic actions on a page of an existing app.

List all LOVs (Lists of Values) in an existing app.

List authorization schemes in an existing app.

Update a region's SQL source, title, or template in an existing app.

Update an item's LOV, label, type, or default in an existing app.

Delete a page from an existing app.

Delete a region from an existing app.

Delete an item from an existing app.

Delete a button from an existing app.

Update page properties (title, mode, auth) in an existing app.

Copy a page to a new page ID within the same app.

Compare app structure before/after changes (diff of pages, regions, items).

Add server-side validation to a page item (NOT_NULL, REGEX, SQL, PL/SQL).

Add a computation to set an item's value (STATIC, SQL, PL/SQL, ITEM).

Add an Oracle JET chart region. Types: bar, line, pie, donut, area. SQL must alias LABEL + VALUE.

Add a gauge/dial chart with min/max/thresholds. SQL must return a VALUE column.

Add a funnel chart. SQL must alias LABEL + VALUE ordered by sequence.

Add sparkline mini-charts with trend lines. Provide metrics list with sql + trend_sql.

Add styled KPI metric cards (gradient/flat/outline). Each metric: label + sql + icon + color.

Add a calendar region. SQL must include a date column and a title column.

Generate a full analytics page with metric cards + multiple JET charts in one call.

Generate an IR report page with optional filter items (text/select/date).

Generate a multi-step wizard (2-6 steps) with progress bar, items, and navigation buttons.

Add an inline notification/alert (info/success/warning/error) with optional dismiss.

Add inline CSS to a specific page via a hidden PL/SQL region.

Add global CSS to ALL pages via Page 0. Use for branding and theme overrides.

Add an Interactive Grid (editable spreadsheet). Supports inline editing + add row.

Add multiple form items in one call. Each: {name, type, label, lov, required, default}.

Validate an APEX app: check SQL, page refs, missing items. Returns score 0-100 + issues.

Get the preview URL for a page (f?p=APP:PAGE).

Add a search bar that filters an IR region on keystroke via Dynamic Action.

Generate a complete app from a list of tables: CRUD pages + dashboard + navigation.

Create an inline modal popup form (no separate page). Returns region_static_id for JS open.

Create master IR + detail IR on same page. Row click in master refreshes detail.

Add a vertical timeline region. SQL must return date_col, title_col, body_col.

Add breadcrumb navigation with ordered entries [{label, page_id}].

Add faceted search: filter SELECT_LISTs + IR. Facets: [{column, label, type}].

Add chart drilldown: click chart series → set hidden item → refresh IR.

Add a FILE_BROWSE item + after-submit process to store uploads as BLOB.

Generate ORDS REST endpoints (GET/POST/PUT/DELETE) for a table.

Export a single page as SQL install script.

Auto-generate Markdown documentation for an app (pages, regions, items).

Start batch mode: queue PL/SQL operations for a single DB round-trip.

Execute all queued batch operations. rollback_on_error=True (default) rolls back on failure.

Add a hero banner with title, subtitle, CTA button, and gradient background.

Add a horizontal row of KPI cards. Each: {label, sql, icon, color}.

Add a step progress tracker (horizontal steps with active state).

Add a styled alert box (info/success/warning/error) with title and message.

Add a stat card with current value, delta, and trend arrow (up/down).

Add a grid of quick-link cards. Each: {label, page_id, icon, color}.

Add a ranked leaderboard table. SQL must alias RANK, NAME, VALUE.

Add a tag/word cloud from SQL (TAG + WEIGHT columns).

Add horizontal percent bars. Each: {label, value, max, color}.

Add an icon list with labels. Each: {icon, label, description, page_id}.