Skip to main content
Glama

apex-mcp — Oracle APEX MCP Server

Build, inspect, and modify Oracle APEX 24.2 applications via natural language. Works with Claude, GPT, Gemini, Cursor, VS Code, and any MCP-compatible AI client.

Python FastMCP Oracle APEX Version License: MIT


Overview

apex-mcp is a Model Context Protocol (MCP) server that exposes 86 tools for building Oracle APEX 24.2 applications through AI assistants. Built on FastMCP 3.x and Python 3.11+, it connects to Oracle Autonomous Database via the oracledb thin driver (mTLS wallet — no Oracle Instant Client required).

Instead of navigating the APEX App Builder UI, you describe what you want and the AI does the work: create apps, generate CRUD pages, add JET charts, configure auth schemes, export pages, generate REST endpoints, and more.

┌─────────────────────────────────────────────────────────────────┐
│  AI Client (Claude / GPT / Gemini / Cursor / VS Code)           │
│                                                                  │
│  "Create a full HR app from the EMPLOYEES table"                 │
└────────────────────────────┬────────────────────────────────────┘
                             │ MCP (stdio or HTTP)
                             ▼
┌─────────────────────────────────────────────────────────────────┐
│  apex-mcp server (FastMCP 3.x, Python 3.11+)                    │
│  86 tools across 15 categories                                   │
└────────────────────────────┬────────────────────────────────────┘
                             │ oracledb (mTLS)
                             ▼
┌─────────────────────────────────────────────────────────────────┐
│  Oracle Autonomous Database 23ai                                 │
│  wwv_flow_imp_page → APEX 24.2 App Builder                      │
└─────────────────────────────────────────────────────────────────┘

Related MCP server: Salesforce MCP Server

Supported AI Clients

Client

Transport

Config File

Setup Guide

Claude Code

stdio

.mcp.json

docs/setup-claude.md

Claude Desktop

stdio

claude_desktop_config.json

docs/setup-claude.md

GPT / OpenAI Agents SDK

streamable-http

Python code

docs/setup-gpt.md

Google Gemini CLI

stdio

.gemini/settings.json

docs/setup-gemini.md

Cursor IDE

stdio

.cursor/mcp.json

docs/setup-cursor.md

VS Code / GitHub Copilot

stdio or http

.vscode/mcp.json

docs/setup-vscode.md

ZAI (visual companion)

n/a

side-by-side

docs/setup-zai.md


Quick Start

1. Install

git clone https://github.com/your-org/apex-mcp
cd apex-mcp
pip install -e .

2. Configure

Copy and edit the config file for your AI client:

Claude Code — create .mcp.json in your project root:

{
  "mcpServers": {
    "apex-mcp": {
      "command": "python",
      "args": ["-m", "apex_mcp"],
      "cwd": "/path/to/apex-mcp",
      "env": {
        "ORACLE_DB_USER": "YOUR_SCHEMA",
        "ORACLE_DB_PASS": "YOUR_PASSWORD",
        "ORACLE_DSN": "YOUR_DSN",
        "ORACLE_WALLET_DIR": "/path/to/wallet",
        "ORACLE_WALLET_PASSWORD": "YOUR_WALLET_PW",
        "APEX_WORKSPACE_ID": "YOUR_WORKSPACE_ID",
        "APEX_SCHEMA": "YOUR_SCHEMA",
        "APEX_WORKSPACE_NAME": "YOUR_WORKSPACE"
      }
    }
  }
}

For other clients see Supported AI Clients above.

3. Verify

In Claude Code:

/mcp

You should see apex-mcp connected with 86 tools.

Then:

Connect to Oracle and list all APEX applications in the workspace.

Transport Modes

apex-mcp supports three transport modes, controlled via --transport flag or environment variables.

stdio (default — local clients)

python -m apex_mcp                        # default
python -m apex_mcp --transport stdio      # explicit
apex-mcp                                  # if installed via pip

Best for: Claude Code, Claude Desktop, Cursor, VS Code, Gemini CLI.

Streamable HTTP (remote / multi-client)

apex-mcp --transport streamable-http --port 8000
# Server available at: http://127.0.0.1:8000/mcp

Best for: OpenAI Agents SDK, Codespaces, remote setups, multiple clients.

SSE (Server-Sent Events)

apex-mcp --transport sse --port 9000
# Server available at: http://127.0.0.1:9000/sse

Best for: clients that specifically require SSE transport.

Environment Variables

All CLI flags have environment variable equivalents (lower priority than CLI args):

Variable

CLI flag

Default

MCP_TRANSPORT

--transport

stdio

MCP_HOST

--host

127.0.0.1

MCP_PORT

--port

8000

MCP_PATH

--path

/mcp (http) or /sse

Oracle Connection Variables

Variable

Description

ORACLE_DB_USER

Oracle schema name

ORACLE_DB_PASS

Oracle schema password

ORACLE_DSN

TNS alias or connect string

ORACLE_WALLET_DIR

Directory containing wallet files (cwallet.sso, etc.)

ORACLE_WALLET_PASSWORD

Wallet encryption password

APEX_WORKSPACE_ID

Numeric APEX workspace ID

APEX_SCHEMA

Schema that owns APEX objects

APEX_WORKSPACE_NAME

APEX workspace name


Tool Reference

86 tools across 15 categories.

Connection & SQL

Tool

Description

apex_connect

Connect to Oracle ADB (mTLS wallet)

apex_run_sql

Execute any SELECT/DML/DDL statement

apex_status

Show connection status and session info

Applications

Tool

Description

apex_create_app

Create a new APEX application (starts import session)

apex_finalize_app

Finalize and commit the application

apex_list_apps

List all apps in the workspace

apex_delete_app

Delete an application

apex_get_app_details

Get full app configuration

apex_validate_app

Validate app structure (home page, orphan items, etc.)

apex_dry_run_preview

Toggle dry-run mode (log SQL without executing)

apex_describe_page

Describe a page's components in human-readable form

Pages

Tool

Description

apex_add_page

Add a new page to the app

apex_list_pages

List all pages

apex_get_page_details

Get full page details

apex_update_page

Update page properties

apex_delete_page

Delete a page

apex_copy_page

Copy a page to a new ID

apex_diff_app

Compare app structure before/after changes

Regions & Components

Tool

Description

apex_add_region

Add a region (HTML, IR, report, etc.)

apex_list_regions

List regions on a page

apex_update_region

Update region properties

apex_delete_region

Delete a region

apex_add_interactive_grid

Add an Interactive Grid region

apex_add_master_detail

Add a master-detail region pair

apex_add_notification_region

Add a notification/alert region

apex_add_timeline

Add a timeline region

apex_add_breadcrumb

Add a breadcrumb navigation region

apex_add_faceted_search

Add a faceted search region

apex_add_file_upload

Add a file upload component

apex_add_search_bar

Add a search bar component

Items (Form Fields)

Tool

Description

apex_add_item

Add a form item (text, select, date, etc.)

apex_list_items

List items on a page

apex_update_item

Update item properties

apex_delete_item

Delete an item

apex_bulk_add_items

Add multiple items in one call

apex_add_item_validation

Add server-side validation to an item

apex_add_item_computation

Add a computation to set item value

Buttons & Processes

Tool

Description

apex_add_button

Add a button to a page/region

apex_delete_button

Delete a button

apex_add_process

Add a page process (PL/SQL, DML, branch)

apex_list_processes

List page processes

Dynamic Actions

Tool

Description

apex_add_dynamic_action

Add a dynamic action (client-side event handler)

apex_list_dynamic_actions

List dynamic actions on a page

Charts & Visualizations

Tool

Description

apex_add_jet_chart

Add an Oracle JET chart (bar, line, pie, etc.)

apex_add_gauge

Add a gauge/dial chart

apex_add_funnel

Add a funnel chart

apex_add_sparkline

Add a sparkline chart

apex_add_metric_cards

Add metric/KPI cards with gradient styling

apex_add_calendar

Add a calendar region

apex_add_chart_drilldown

Add drill-down behavior to a chart

Shared Components

Tool

Description

apex_add_lov

Add a List of Values (static or dynamic)

apex_list_lovs

List all LOVs in the app

apex_add_auth_scheme

Add an authorization scheme

apex_list_auth_schemes

List authorization schemes

apex_add_nav_item

Add a navigation menu item

apex_add_app_item

Add an application-level item (global variable)

apex_add_app_process

Add an application-level process

Schema Inspection

Tool

Description

apex_list_tables

List Oracle tables/views in the schema

apex_describe_table

Describe columns, types, PKs, FKs (with cache)

apex_detect_relationships

Auto-detect FK relationships between tables

Generators (High-Level)

Tool

Description

apex_generate_crud

Generate full CRUD (list + form pages) for a table

apex_generate_dashboard

Generate a dashboard with charts

apex_generate_login

Generate a login page

apex_generate_report_page

Generate a formatted report page

apex_generate_wizard

Generate a multi-step wizard

apex_generate_analytics_page

Generate an analytics page with multiple charts

apex_generate_from_schema

Generate a full app from multiple tables

apex_generate_modal_form

Generate a modal form dialog

apex_generate_rest_endpoints

Generate ORDS REST endpoints for tables

JavaScript

Tool

Description

apex_add_page_js

Add page-level JavaScript

apex_add_global_js

Add app-level global JavaScript

apex_add_global_css

Add app-level CSS

apex_add_page_css

Add page-level CSS

apex_generate_ajax_handler

Generate an AJAX callback process

DevOps & Batch

Tool

Description

apex_export_page

Export a page as SQL (for version control)

apex_generate_docs

Generate Markdown documentation for an app

apex_begin_batch

Begin a batch operation (queue multiple SQL statements)

apex_commit_batch

Execute the batch queue in one round-trip

apex_preview_page

Preview page structure (without opening browser)

Setup & Validation

Tool

Description

apex_setup_guide

Get setup instructions for this workspace

apex_check_requirements

Verify all requirements are met

apex_check_permissions

Verify Oracle grants and APEX access

apex_fix_permissions

Auto-fix common permission issues

Users

Tool

Description

apex_create_user

Create an APEX workspace user

apex_list_users

List workspace users


Code Examples

Example 1: Full app from schema (single command)

# Uses apex_generate_from_schema internally
# Prompt: "Generate a full app from tables EMPLOYEES, DEPARTMENTS, JOBS"
# Result: App with CRUD pages, dashboard, navigation — in ~10 seconds

Example 2: Incremental build

1. apex_connect()
2. apex_create_app(app_id=200, app_name="Inventory", home_page=1)
3. apex_add_page(page_id=1, page_name="Dashboard", page_mode="Normal")
4. apex_add_region(page_id=1, region_name="KPIs", region_type="STATIC")
5. apex_add_metric_cards(page_id=1, region_id=..., metrics=[...])
6. apex_generate_crud(table_name="PRODUCTS", start_page_id=10)
7. apex_add_nav_item("Dashboard", app_id=200, page_id=1, icon="fa-home")
8. apex_add_nav_item("Products", app_id=200, page_id=10, icon="fa-box")
9. apex_finalize_app()

Example 3: OpenAI Agents SDK

import asyncio
from agents import Agent, Runner
from agents.mcp import MCPServerStreamableHttp

async def main():
    # apex-mcp must be running: apex-mcp --transport streamable-http
    async with MCPServerStreamableHttp(url="http://127.0.0.1:8000/mcp") as apex:
        agent = Agent(
            name="APEX Developer",
            instructions="Build Oracle APEX apps using apex-mcp tools.",
            mcp_servers=[apex],
        )
        result = await Runner.run(
            agent,
            "Connect to Oracle and generate a CRUD app for the ORDERS table."
        )
        print(result.final_output)

asyncio.run(main())

Example 4: Batch operations

apex_begin_batch()
# ... add many regions, items, processes ...
apex_commit_batch(rollback_on_error=True)
# All statements execute in one round-trip; rolls back on any error

Example 5: Dry-run mode

apex_dry_run_preview(enabled=True)
apex_generate_crud(table_name="EMPLOYEES")
# Logs all SQL without executing — useful for review before committing
apex_dry_run_preview(enabled=False)

Architecture

apex_mcp/
├── server.py          Entry point — FastMCP 3.x, argparse (stdio/http/sse)
├── __main__.py        Enables `python -m apex_mcp`
├── __init__.py        Version: 0.2.0
├── config.py          Constants (APEX version, workspace ID, date format)
├── db.py              ConnectionManager singleton — mTLS, retry, batch, dry-run
├── ids.py             Sequential ID generator (base 8_900_000_000_000_000)
├── session.py         ImportSession — tracks pages, regions, items, buttons
├── templates.py       Hardcoded Universal Theme 42 template IDs
├── validators.py      Input validation (page IDs, SQL, chart types, table names)
├── utils.py           Shared helpers (_esc, _blk, _sql_to_varchar2)
└── tools/
    ├── sql_tools.py       apex_connect, apex_run_sql, apex_status
    ├── app_tools.py       apex_create_app, apex_finalize_app, ...
    ├── page_tools.py      apex_add_page, apex_list_pages
    ├── component_tools.py apex_add_region, apex_add_item, apex_add_button, ...
    ├── shared_tools.py    apex_add_lov, apex_add_auth_scheme, ...
    ├── schema_tools.py    apex_list_tables, apex_describe_table, ...
    ├── generator_tools.py apex_generate_crud, apex_generate_dashboard, ...
    ├── js_tools.py        apex_add_page_js, apex_add_global_js, ...
    ├── inspect_tools.py   apex_get_app_details, apex_update_*, apex_delete_*, ...
    ├── user_tools.py      apex_create_user, apex_list_users
    ├── setup_tools.py     apex_setup_guide, apex_check_requirements, ...
    ├── validation_tools.py apex_add_item_validation, apex_add_item_computation
    ├── visual_tools.py    apex_add_jet_chart, apex_add_gauge, ...
    ├── advanced_tools.py  apex_generate_report_page, apex_generate_wizard, ...
    └── devops_tools.py    apex_generate_rest_endpoints, apex_export_page, ...

How APEX creation works

apex-mcp creates APEX applications by generating and executing wwv_flow_imp_page.* PL/SQL calls directly against the Oracle database — the same mechanism used by APEX's own import/export system. This bypasses the App Builder UI entirely and is fully compatible with APEX 24.2.13 / Universal Theme 42.

HTTP transport note

When using --transport streamable-http or --transport sse, apex-mcp is a single-user server: the ImportSession singleton means only one active import session exists at a time. For multi-user scenarios, run separate server instances on different ports.


Known Limitations

Limitation

Details

Single import session

Only one apex_create_app → apex_finalize_app sequence at a time

No HTTP authentication

Bind HTTP transport to 127.0.0.1 (default); add a reverse proxy for remote access

APEX 24.2 only

wwv_flow_imp_page API is version-specific; not tested on APEX 23.x or 25.x

Oracle mTLS required

TLS direct connections are not supported (wallet required)

Licensed instrument content

TEA_QUESTOES / TEA_OPCOES_RESPOSTA tables are empty (content is licensed)


Requirements

Component

Version

Python

3.11+

FastMCP

3.0.0+

oracledb

2.0.0+

Oracle APEX

24.2 (Universal Theme 42)

Oracle DB

19c+ (tested on ADB 23ai)

Oracle Wallet

Required for mTLS connections

No Oracle Instant Client required — the oracledb thin driver handles mTLS natively.


Troubleshooting

Connection issues

Error

Cause

Solution

ORA-12541: no listener

Wrong DSN

Check ORACLE_DSN matches the TNS alias in tnsnames.ora

ORA-28759: failure to open file

Wrong wallet path

ORACLE_WALLET_DIR must contain cwallet.sso

DPY-6005: cannot connect to database

Wallet password wrong

Check ORACLE_WALLET_PASSWORD

ModuleNotFoundError: apex_mcp

Not installed

Run pip install -e . from apex-mcp directory

APEX issues

Error

Cause

Solution

ORA-20987: APEX - Application not found

Wrong app_id or workspace

Check APEX_WORKSPACE_ID and run apex_list_apps

ORA-01403: no data found in item creation

Missing p_attributes on DatePicker

Fixed in v0.2.0 — update to latest

PLS-00306: wrong number of arguments

Wrong process parameter name

Use p_process_success_message not p_success_message

Buttons not showing on Standard pages

Wrong region position

Use content region positions (CLOSE/CREATE), not dialog footer

HTTP transport issues

Problem

Solution

ConnectionRefusedError

Start server with apex-mcp --transport streamable-http first

404 Not Found at /

Default path is /mcp; use curl http://127.0.0.1:8000/mcp

OpenAI SDK can't connect

Ensure MCPServerStreamableHttp URL matches --path setting


Running Tests

cd apex-mcp
pip install -e ".[dev]"

# Unit tests (no database required)
pytest tests/ -v -m "not integration"

# All tests including integration (requires live Oracle connection)
pytest tests/ -v

The test suite has 51 unit tests covering tools, validators, and generators.


Demo Scripts

Script

Description

demos/build_app100.py

TEA clinical assessment app (15 pages, 46 items)

demos/build_app203.py

Analytics dashboard with JET charts + metric cards

demos/build_app204.py

Backoffice from schema (8 tables, 17 pages, score 100/100)

demos/build_app205.py

Assessment wizard (4-step wizard, CRUD, dashboard, 9s build)

demos/demo_rest_endpoints.py

5 tables → 25 ORDS endpoints in 1 second

demos/demo_generate_docs.py

Auto-generate Markdown docs for an app

Run any demo (requires live Oracle connection):

python demos/build_app205.py

Contributing

  1. Fork the repository

  2. Create a feature branch

  3. Add tests for new tools in tests/

  4. Ensure pytest tests/ -m "not integration" passes

  5. Submit a pull request

Adding a new tool

  1. Add the function to the appropriate tools/*.py module

  2. Register it in server.py with mcp.tool()(function_name)

  3. Add unit tests in tests/

  4. Update the Tool Reference section in this README


License

MIT — see LICENSE for details.


pt-BR: Este servidor MCP foi construído para o projeto Plataforma Desfecho TEA (Unimed Nacional), usando Oracle APEX 24.2 + Oracle ADB 23ai. Para configuração detalhada do ambiente de produção, consulte o CLAUDE.md na raiz do projeto.

Available Tools

120 tools
apex_add_activity_streamB

Add an activity/audit stream. SQL must alias TIMESTAMP, USER_NAME, ACTION.

Inputs: page_id (required), sql_query (required), region_name (required), max_rows, +8 more. Returns: result

apex_add_alert_boxA

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

Inputs: message (required), page_id (required), icon, title, +4 more. Returns: result

apex_add_animated_counterB

Add an animated counting number with label (counts up on page load).

Inputs: label (required), page_id (required), sql_query (required), region_name (required), +10 more. Returns: result

apex_add_app_itemA

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

Inputs: item_name (required), protection, session_state_function. Returns: result

apex_add_app_processA

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

Inputs: plsql_body (required), process_name (required), point, sequence, +2 more. Returns: result

apex_add_area_chartC

Add a filled area chart. SQL: LABEL, VALUE.

Inputs: page_id (required), region_name (required), series_list (required), height, +9 more. Returns: result

apex_add_auth_schemeB

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

Inputs: scheme_name (required), function_body (required), caching, error_message. Returns: result

apex_add_breadcrumbA

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

Inputs: entries (required), page_id (required), region_name (required), sequence. Returns: result

apex_add_bubble_chartB

Add a bubble chart. SQL: X_VALUE, Y_VALUE, BUBBLE_SIZE, optional LABEL.

Inputs: page_id (required), sql_query (required), region_name (required), height, +13 more. Returns: result

apex_add_buttonA

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

Inputs: label (required), page_id (required), button_name (required), region_name (required), +8 more. Returns: result

apex_add_calendarB

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

Inputs: page_id (required), sql_query (required), date_column (required), region_name (required), +5 more. Returns: result

apex_add_chart_drilldownB

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

Inputs: page_id (required), filter_column (required), target_item_name (required), chart_region_name (required), +2 more. Returns: result

apex_add_collapsible_regionA

Add a collapsible/expandable region with toggle.

Inputs: page_id (required), region_name (required), sequence, collapsed, +3 more. Returns: result

apex_add_combo_chartC

Add a combo chart (bar + line on same axes). SQL: LABEL, BAR_VALUE, LINE_VALUE.

Inputs: bar_sql (required), page_id (required), line_sql (required), region_name (required), +15 more. Returns: result

apex_add_comparison_panelB

Add a side-by-side comparison panel (two columns of metrics).

Inputs: page_id (required), left_label (required), region_name (required), right_label (required), +6 more. Returns: result

apex_add_data_card_gridC

Add a responsive grid of data cards. Each: {title, body, icon, badge}.

Inputs: page_id (required), sql_query (required), region_name (required), color, +8 more. Returns: result

apex_add_dynamic_actionA

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

Inputs: da_name (required), page_id (required), event, sequence, +9 more. Returns: result

apex_add_file_uploadA

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

Inputs: label (required), page_id (required), pk_item (required), blob_col (required), +6 more. Returns: result

apex_add_funnelA

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

Inputs: page_id (required), sql_query (required), region_name (required), height, +5 more. Returns: result

apex_add_gaugeB

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

Inputs: page_id (required), sql_query (required), region_name (required), color, +6 more. Returns: result

apex_add_global_cssA

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

Inputs: css_code (required). Returns: result

apex_add_global_jsB

Add global JavaScript to all pages via Page 0.

Inputs: function_name (required), javascript_code (required), description. Returns: result

apex_add_gradient_donutA

Add a gradient donut chart with center label. SQL: LABEL, VALUE.

Inputs: page_id (required), sql_query (required), region_name (required), height, +12 more. Returns: result

apex_add_heatmap_gridA

Add a heatmap grid with color intensity based on values.

Inputs: page_id (required), sql_query (required), region_name (required), color, +5 more. Returns: result

apex_add_hero_bannerB

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

Inputs: title (required), page_id (required), stats, bg_color, +7 more. Returns: result

apex_add_icon_listC

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

Inputs: page_id (required), sql_query (required), region_name (required), color, +6 more. Returns: result

apex_add_interactive_gridA

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

Inputs: page_id (required), table_name (required), region_name (required), add_row, +4 more. Returns: result

apex_add_itemB

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

Inputs: page_id (required), item_name (required), region_name (required), label, +9 more. Returns: result

apex_add_item_computationC

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

Inputs: page_id (required), item_name (required), sequence, condition_item, +3 more. Returns: result

apex_add_item_validationA

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

Inputs: page_id (required), item_name (required), validation_name (required), sequence, +4 more. Returns: result

apex_add_jet_chartA

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

Inputs: page_id (required), region_name (required), height, sequence, +11 more. Returns: result

apex_add_kpi_rowB

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

Inputs: metrics (required), page_id (required), region_name (required), sequence, +2 more. Returns: result

apex_add_leaderboardC

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

Inputs: page_id (required), sql_query (required), region_name (required), color, +6 more. Returns: result

apex_add_lovB

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

Inputs: lov_name (required), lov_type, sql_query, return_column, +2 more. Returns: result

apex_add_master_detailA

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

Inputs: page_id (required), detail_sql (required), master_sql (required), link_column (required), +4 more. Returns: result

apex_add_metric_cardsC

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

Inputs: metrics (required), page_id (required), region_name (required), style, +3 more. Returns: result

apex_add_mini_charts_rowC

Add a row of mini sparkline charts. Each: {label, sql, color}.

Inputs: charts (required), page_id (required), sequence, animation, +1 more. Returns: result

apex_add_nav_itemA

Add a navigation menu item linking to a page.

Inputs: item_name (required), target_page (required), icon, sequence, +2 more. Returns: result

apex_add_notification_regionB

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

Inputs: page_id (required), region_name (required), message, sequence, +4 more. Returns: result

apex_add_pageC

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

Inputs: page_id (required), page_name (required), help_text, page_type, +2 more. Returns: result

apex_add_page_cssA

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

Inputs: page_id (required), css_code (required). Returns: result

apex_add_page_jsC

Add inline JavaScript to a specific page.

Inputs: page_id (required), javascript_code (required), js_file_urls. Returns: result

apex_add_pareto_chartB

Add a Pareto chart (bars + cumulative % line). SQL: LABEL, VALUE.

Inputs: page_id (required), sql_query (required), region_name (required), height, +11 more. Returns: result

apex_add_percent_barsC

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

Inputs: page_id (required), sql_query (required), region_name (required), color, +5 more. Returns: result

apex_add_processC

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

Inputs: page_id (required), process_name (required), point, source, +7 more. Returns: result

apex_add_progress_trackerA

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

Inputs: steps (required), page_id (required), region_name (required), color, +4 more. Returns: result

apex_add_range_chartB

Add a range chart (min-max bars). SQL: LABEL, LOW_VALUE, HIGH_VALUE.

Inputs: page_id (required), sql_query (required), region_name (required), height, +11 more. Returns: result

apex_add_regionB

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

Inputs: page_id (required), region_name (required), labels, sequence, +7 more. Returns: result

apex_add_ribbon_statsA

Add a horizontal ribbon of stat cards with icons and colors.

Inputs: metrics (required), page_id (required), region_name (required), bg_color, +2 more. Returns: result

apex_add_scatter_plotB

Add a scatter plot. SQL: X_VALUE, Y_VALUE, optional LABEL.

Inputs: page_id (required), sql_query (required), region_name (required), height, +12 more. Returns: result

apex_add_sparklineA

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

Inputs: metrics (required), page_id (required), region_name (required), columns, +1 more. Returns: result

apex_add_spotlight_metricC

Add a large spotlight metric with value, label, and optional trend.

Inputs: label (required), page_id (required), sql_query (required), region_name (required), +9 more. Returns: result

apex_add_stacked_chartC

Add a stacked bar/column chart. SQL: LABEL, VALUE, SERIES.

Inputs: page_id (required), region_name (required), series_list (required), height, +9 more. Returns: result

apex_add_stat_deltaA

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

Inputs: metrics (required), page_id (required), region_name (required), columns, +3 more. Returns: result

apex_add_status_matrixA

Add a status matrix grid (rows × columns with colored status cells).

Inputs: page_id (required), sql_query (required), region_name (required), sequence, +4 more. Returns: result

apex_add_tabs_containerC

Add a tabs container with multiple content panels.

Inputs: tabs (required), page_id (required), region_name (required), color, +2 more. Returns: result

apex_add_tag_cloudC

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

Inputs: page_id (required), sql_query (required), region_name (required), sequence, +3 more. Returns: result

apex_add_timelineA

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

Inputs: page_id (required), body_col (required), date_col (required), sql_query (required), +4 more. Returns: result

apex_add_traffic_lightA

Add a traffic light indicator (red/yellow/green) based on SQL value.

Inputs: page_id (required), sql_query (required), region_name (required), sequence, +3 more. Returns: result

apex_begin_batchA
Idempotent

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

Inputs: no named parameters. Returns: result

apex_bulk_add_itemsB

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

Inputs: items (required), page_id (required), region_name (required), start_sequence. Returns: result

apex_check_permissionsA
Read-onlyIdempotent

Check Oracle grants and APEX object access permissions.

Inputs: no named parameters. Returns: result

apex_check_requirementsA
Read-onlyIdempotent

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

Inputs: no named parameters. Returns: result

apex_commit_batchA

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

Inputs: no named parameters. Returns: result

apex_connectA
Idempotent

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

Inputs: dsn, user, password, wallet_dir, +1 more. Returns: result

apex_copy_pageC

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

Inputs: source_app_id (required), target_app_id (required), source_page_id (required), target_page_id (required), +1 more. Returns: result

apex_create_appA

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

Inputs: app_id (required), app_name (required), schema, language, +6 more. Returns: result

apex_create_userB

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

Inputs: password (required), username (required), email, last_name, +2 more. Returns: result

apex_delete_appA
Destructive

Delete an APEX application permanently.

Inputs: app_id (required). Returns: result

apex_delete_buttonB
Destructive

Delete a button from an existing app.

Inputs: app_id (required), page_id (required), button_name (required). Returns: result

apex_delete_itemA
Destructive

Delete an item from an existing app.

Inputs: app_id (required), page_id (required), item_name (required). Returns: result

apex_delete_pageA
Destructive

Delete a page from an existing app.

Inputs: app_id (required), page_id (required). Returns: result

apex_delete_regionA
Destructive

Delete a region from an existing app.

Inputs: app_id (required), page_id (required), region_name (required). Returns: result

apex_describe_pageA
Read-onlyIdempotent

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

Inputs: app_id (required), page_id (required). Returns: result

apex_describe_tableA
Read-onlyIdempotent

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

Inputs: table_name (required), force_refresh. Returns: result

apex_detect_relationshipsA
Read-onlyIdempotent

Auto-detect FK relationships between a list of tables.

Inputs: tables (required). Returns: result

apex_diff_appA
Read-onlyIdempotent

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

Inputs: app_id_1 (required), app_id_2 (required). Returns: result

apex_dry_run_previewA
Idempotent

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

Inputs: enabled. Returns: result

apex_export_appA
Read-onlyIdempotent

Export an app as SQL install script.

Inputs: app_id (required), output_path. Returns: result

apex_export_pageA
Read-onlyIdempotent

Export a single page as SQL install script.

Inputs: app_id (required), page_id (required), output_path. Returns: result

apex_finalize_appA

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

Inputs: no named parameters. Returns: result

apex_fix_permissionsA
Idempotent

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

Inputs: no named parameters. Returns: result

apex_generate_ajax_handlerB

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

Inputs: page_id (required), plsql_code (required), callback_name (required), auto_add_js, +2 more. Returns: result

apex_generate_analytics_pageB

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

Inputs: page_id (required), charts, metrics, page_name, +1 more. Returns: result

apex_generate_crudA

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

Inputs: table_name (required), form_page_id (required), list_page_id (required), editable, +7 more. Returns: result

apex_generate_dashboardB

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

Inputs: page_id (required), ir_sql, ir_title, page_name, +1 more. Returns: result

apex_generate_docsA
Read-onlyIdempotent

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

Inputs: app_id. Returns: result

apex_generate_from_schemaA

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

Inputs: tables (required), nav_icon_map, start_page_id, include_dashboard. Returns: result

apex_generate_loginA

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

Inputs: page_id, app_name, page_name, password_label, +3 more. Returns: result

apex_generate_modal_formA

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

Inputs: page_id (required), table_name (required), region_name (required), pk_item_name (required), +3 more. Returns: result

apex_generate_report_pageA

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

Inputs: page_id (required), page_name (required), sql_query (required), title, +4 more. Returns: result

apex_generate_rest_endpointsA

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

Inputs: table_name (required), schema, base_path, pk_column, +1 more. Returns: result

apex_generate_wizardA

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

Inputs: steps (required), start_page_id (required), auth_scheme, wizard_title, +1 more. Returns: result

apex_get_app_detailsA
Read-onlyIdempotent

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

Inputs: app_id (required). Returns: result

apex_get_audit_logA
Read-onlyIdempotent

Get audit log of recent MCP operations in this session.

Inputs: limit. Returns: result

apex_get_page_detailsA
Read-onlyIdempotent

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

Inputs: app_id (required), page_id (required). Returns: result

apex_health_checkA
Read-onlyIdempotent

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

Inputs: no named parameters. Returns: result

apex_list_appsA
Read-onlyIdempotent

List all APEX applications in the workspace.

Inputs: no named parameters. Returns: result

apex_list_auth_schemesA
Read-onlyIdempotent

List authorization schemes in an existing app.

Inputs: app_id (required). Returns: result

apex_list_dynamic_actionsA
Read-onlyIdempotent

List dynamic actions on a page of an existing app.

Inputs: app_id (required), page_id (required). Returns: result

apex_list_itemsA
Read-onlyIdempotent

List items on a page of an existing app.

Inputs: app_id (required), page_id (required), region_name. Returns: result

apex_list_lovsA
Read-onlyIdempotent

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

Inputs: app_id (required). Returns: result

apex_list_pagesA
Read-onlyIdempotent

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

Inputs: app_id. Returns: result

apex_list_processesA
Read-onlyIdempotent

List page processes of an existing app.

Inputs: app_id (required), page_id (required). Returns: result

apex_list_regionsA
Read-onlyIdempotent

List regions on a page of an existing app.

Inputs: app_id (required), page_id (required). Returns: result

apex_list_tablesA
Read-onlyIdempotent

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

Inputs: pattern, object_type, include_columns. Returns: result

apex_list_usersA
Read-onlyIdempotent

List all users in the APEX workspace.

Inputs: workspace_id. Returns: result

apex_preview_pageA
Read-onlyIdempotent

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

Inputs: app_id, page_id. Returns: result

apex_refresh_templatesA
Idempotent

Refresh Universal Theme 42 template IDs from the live database.

Inputs: no named parameters. Returns: result

apex_run_sqlB
Read-onlyIdempotent

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

Inputs: sql (required), max_rows, bind_params. Returns: result

apex_setup_guideB
Read-onlyIdempotent

Show setup requirements and instructions for this APEX MCP server.

Inputs: no named parameters. Returns: result

apex_statusA
Read-onlyIdempotent

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

Inputs: no named parameters. Returns: result

apex_undo_lastA
Destructive

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

Inputs: steps. Returns: result

apex_update_itemB

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

Inputs: app_id (required), page_id (required), item_name (required), new_label, +7 more. Returns: result

apex_update_pageA

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

Inputs: app_id (required), page_id (required), new_name, new_title, +2 more. Returns: result

apex_update_regionC

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

Inputs: app_id (required), page_id (required), region_name (required), new_name, +6 more. Returns: result

apex_validate_appA
Read-onlyIdempotent

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

Inputs: app_id. Returns: result

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3/5.0

    Scored across 120 tools

    Disambiguation2/5

    There are multiple clusters of near-synonym visual component tools: KPI/stat adders (metric_cards, kpi_row, spot_light_metric, stat_delta, ribbon_stats, animated_counter) and over a dozen chart adders. While descriptions are specific, an agent selecting the right widget from 120 tools will face many unclear boundaries.

    Naming Consistency4/5

    The apex_ prefix and verb_noun pattern is used consistently (add_, list_, update_, delete_, generate_). Minor exceptions like dry_run_preview, undo_last, and status are understandable but break the dominant pattern.

    Tool Count1/5

    120 tools is an extreme count for a single MCP server, far beyond the 50+ threshold. Many chart/KPI variants could be consolidated into parameterized tools (e.g. one add_chart with a type parameter).

    Completeness4/5

    The domain is covered broadly: app/page/region/item lifecycle, CRUD generation, auth, users, SQL, validation, batch ops, REST, export, and diffing. Gaps include update/delete for dynamic actions, LOVs, auth schemes, and some app-level objects, but generic get_page_details and region deletion mitigate them.

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables integration with Oracle Database and Oracle APEX 20.2, allowing LLMs to execute SQL/PL/SQL, manage database objects, and inspect APEX application metadata. It supports full database CRUD operations, object dependency analysis, and detailed page-level inspection of APEX environments.
      3
      MIT
    • A
      license
      B
      quality
      B
      maintenance
      Enables AI assistants to interact with Salesforce organizations, allowing them to execute Apex code, query data, describe objects, and manage org connections through natural language.
      47
      641 npm
      38
      MIT