apex-mcp
Allows building, inspecting, and modifying Oracle APEX 24.2 applications via natural language using GitHub Copilot in VS Code.
Allows building, inspecting, and modifying Oracle APEX 24.2 applications via natural language using Google Gemini AI.
Allows building, inspecting, and modifying Oracle APEX 24.2 applications via natural language using GPT (OpenAI) AI.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@apex-mcp Create a full HR app from the EMPLOYEES table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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.
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 |
| |
Claude Desktop | stdio |
| |
GPT / OpenAI Agents SDK | streamable-http | Python code | |
Google Gemini CLI | stdio |
| |
Cursor IDE | stdio |
| |
VS Code / GitHub Copilot | stdio or http |
| |
ZAI (visual companion) | n/a | side-by-side |
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:
/mcpYou 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 pipBest 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/mcpBest 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/sseBest 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 |
|
|
|
|
|
|
|
|
|
|
|
|
Oracle Connection Variables
Variable | Description |
| Oracle schema name |
| Oracle schema password |
| TNS alias or connect string |
| Directory containing wallet files ( |
| Wallet encryption password |
| Numeric APEX workspace ID |
| Schema that owns APEX objects |
| APEX workspace name |
Tool Reference
86 tools across 15 categories.
Connection & SQL
Tool | Description |
| Connect to Oracle ADB (mTLS wallet) |
| Execute any SELECT/DML/DDL statement |
| Show connection status and session info |
Applications
Tool | Description |
| Create a new APEX application (starts import session) |
| Finalize and commit the application |
| List all apps in the workspace |
| Delete an application |
| Get full app configuration |
| Validate app structure (home page, orphan items, etc.) |
| Toggle dry-run mode (log SQL without executing) |
| Describe a page's components in human-readable form |
Pages
Tool | Description |
| Add a new page to the app |
| List all pages |
| Get full page details |
| Update page properties |
| Delete a page |
| Copy a page to a new ID |
| Compare app structure before/after changes |
Regions & Components
Tool | Description |
| Add a region (HTML, IR, report, etc.) |
| List regions on a page |
| Update region properties |
| Delete a region |
| Add an Interactive Grid region |
| Add a master-detail region pair |
| Add a notification/alert region |
| Add a timeline region |
| Add a breadcrumb navigation region |
| Add a faceted search region |
| Add a file upload component |
| Add a search bar component |
Items (Form Fields)
Tool | Description |
| Add a form item (text, select, date, etc.) |
| List items on a page |
| Update item properties |
| Delete an item |
| Add multiple items in one call |
| Add server-side validation to an item |
| Add a computation to set item value |
Buttons & Processes
Tool | Description |
| Add a button to a page/region |
| Delete a button |
| Add a page process (PL/SQL, DML, branch) |
| List page processes |
Dynamic Actions
Tool | Description |
| Add a dynamic action (client-side event handler) |
| List dynamic actions on a page |
Charts & Visualizations
Tool | Description |
| Add an Oracle JET chart (bar, line, pie, etc.) |
| Add a gauge/dial chart |
| Add a funnel chart |
| Add a sparkline chart |
| Add metric/KPI cards with gradient styling |
| Add a calendar region |
| Add drill-down behavior to a chart |
Shared Components
Tool | Description |
| Add a List of Values (static or dynamic) |
| List all LOVs in the app |
| Add an authorization scheme |
| List authorization schemes |
| Add a navigation menu item |
| Add an application-level item (global variable) |
| Add an application-level process |
Schema Inspection
Tool | Description |
| List Oracle tables/views in the schema |
| Describe columns, types, PKs, FKs (with cache) |
| Auto-detect FK relationships between tables |
Generators (High-Level)
Tool | Description |
| Generate full CRUD (list + form pages) for a table |
| Generate a dashboard with charts |
| Generate a login page |
| Generate a formatted report page |
| Generate a multi-step wizard |
| Generate an analytics page with multiple charts |
| Generate a full app from multiple tables |
| Generate a modal form dialog |
| Generate ORDS REST endpoints for tables |
JavaScript
Tool | Description |
| Add page-level JavaScript |
| Add app-level global JavaScript |
| Add app-level CSS |
| Add page-level CSS |
| Generate an AJAX callback process |
DevOps & Batch
Tool | Description |
| Export a page as SQL (for version control) |
| Generate Markdown documentation for an app |
| Begin a batch operation (queue multiple SQL statements) |
| Execute the batch queue in one round-trip |
| Preview page structure (without opening browser) |
Setup & Validation
Tool | Description |
| Get setup instructions for this workspace |
| Verify all requirements are met |
| Verify Oracle grants and APEX access |
| Auto-fix common permission issues |
Users
Tool | Description |
| Create an APEX workspace user |
| 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 secondsExample 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 errorExample 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 |
No HTTP authentication | Bind HTTP transport to |
APEX 24.2 only |
|
Oracle mTLS required | TLS direct connections are not supported (wallet required) |
Licensed instrument content |
|
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 |
| Wrong DSN | Check |
| Wrong wallet path |
|
| Wallet password wrong | Check |
| Not installed | Run |
APEX issues
Error | Cause | Solution |
| Wrong app_id or workspace | Check |
| Missing | Fixed in v0.2.0 — update to latest |
| Wrong process parameter name | Use |
Buttons not showing on Standard pages | Wrong region position | Use content region positions (CLOSE/CREATE), not dialog footer |
HTTP transport issues
Problem | Solution |
| Start server with |
| Default path is |
OpenAI SDK can't connect | Ensure |
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/ -vThe test suite has 51 unit tests covering tools, validators, and generators.
Demo Scripts
Script | Description |
| TEA clinical assessment app (15 pages, 46 items) |
| Analytics dashboard with JET charts + metric cards |
| Backoffice from schema (8 tables, 17 pages, score 100/100) |
| Assessment wizard (4-step wizard, CRUD, dashboard, 9s build) |
| 5 tables → 25 ORDS endpoints in 1 second |
| Auto-generate Markdown docs for an app |
Run any demo (requires live Oracle connection):
python demos/build_app205.pyContributing
Fork the repository
Create a feature branch
Add tests for new tools in
tests/Ensure
pytest tests/ -m "not integration"passesSubmit a pull request
Adding a new tool
Add the function to the appropriate
tools/*.pymoduleRegister it in
server.pywithmcp.tool()(function_name)Add unit tests in
tests/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 toolsapex_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_faceted_searchA
Add faceted search: filter SELECT_LISTs + IR. Facets: [{column, label, type}].
Inputs: facets (required), page_id (required), sql_query (required), region_name (required), +1 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_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_quick_linksC
Add a grid of quick-link cards. Each: {label, page_id, icon, color}.
Inputs: links (required), page_id (required), region_name (required), columns, +2 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_search_barA
Add a search bar that filters an IR region on keystroke via Dynamic Action.
Inputs: page_id (required), region_name (required), target_region_name (required), sequence, +3 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_batchAIdempotent
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_permissionsARead-onlyIdempotent
Check Oracle grants and APEX object access permissions.
Inputs: no named parameters. Returns: result
apex_check_requirementsARead-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_connectAIdempotent
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_appADestructive
Delete an APEX application permanently.
Inputs: app_id (required). Returns: result
apex_delete_buttonBDestructive
Delete a button from an existing app.
Inputs: app_id (required), page_id (required), button_name (required). Returns: result
apex_delete_itemADestructive
Delete an item from an existing app.
Inputs: app_id (required), page_id (required), item_name (required). Returns: result
apex_delete_pageADestructive
Delete a page from an existing app.
Inputs: app_id (required), page_id (required). Returns: result
apex_delete_regionADestructive
Delete a region from an existing app.
Inputs: app_id (required), page_id (required), region_name (required). Returns: result
apex_describe_pageARead-onlyIdempotent
Describe a page's components in human-readable text.
Inputs: app_id (required), page_id (required). Returns: result
apex_describe_tableARead-onlyIdempotent
Describe table columns, types, PKs, and FKs. Cached per session.
Inputs: table_name (required), force_refresh. Returns: result
apex_detect_relationshipsARead-onlyIdempotent
Auto-detect FK relationships between a list of tables.
Inputs: tables (required). Returns: result
apex_diff_appARead-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_previewAIdempotent
Toggle dry-run mode: log PL/SQL without executing. Returns log when disabled.
Inputs: enabled. Returns: result
apex_export_appARead-onlyIdempotent
Export an app as SQL install script.
Inputs: app_id (required), output_path. Returns: result
apex_export_pageARead-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_permissionsAIdempotent
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_docsARead-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_detailsARead-onlyIdempotent
Get full metadata for an existing APEX app (pages, auth, theme).
Inputs: app_id (required). Returns: result
apex_get_audit_logARead-onlyIdempotent
Get audit log of recent MCP operations in this session.
Inputs: limit. Returns: result
apex_get_page_detailsARead-onlyIdempotent
Get all components on a page (regions, items, buttons, processes).
Inputs: app_id (required), page_id (required). Returns: result
apex_health_checkARead-onlyIdempotent
Run APEX health check: score 0-100 with issues list.
Inputs: no named parameters. Returns: result
apex_list_appsARead-onlyIdempotent
List all APEX applications in the workspace.
Inputs: no named parameters. Returns: result
apex_list_auth_schemesARead-onlyIdempotent
List authorization schemes in an existing app.
Inputs: app_id (required). Returns: result
apex_list_dynamic_actionsARead-onlyIdempotent
List dynamic actions on a page of an existing app.
Inputs: app_id (required), page_id (required). Returns: result
apex_list_itemsARead-onlyIdempotent
List items on a page of an existing app.
Inputs: app_id (required), page_id (required), region_name. Returns: result
apex_list_lovsARead-onlyIdempotent
List all LOVs (Lists of Values) in an existing app.
Inputs: app_id (required). Returns: result
apex_list_pagesARead-onlyIdempotent
List all pages in the current session or an existing app.
Inputs: app_id. Returns: result
apex_list_processesARead-onlyIdempotent
List page processes of an existing app.
Inputs: app_id (required), page_id (required). Returns: result
apex_list_regionsARead-onlyIdempotent
List regions on a page of an existing app.
Inputs: app_id (required), page_id (required). Returns: result
apex_list_tablesARead-onlyIdempotent
List all tables/views in the current Oracle schema with row counts.
Inputs: pattern, object_type, include_columns. Returns: result
apex_list_usersARead-onlyIdempotent
List all users in the APEX workspace.
Inputs: workspace_id. Returns: result
apex_preview_pageARead-onlyIdempotent
Get the preview URL for a page (f?p=APP:PAGE).
Inputs: app_id, page_id. Returns: result
apex_refresh_templatesAIdempotent
Refresh Universal Theme 42 template IDs from the live database.
Inputs: no named parameters. Returns: result
apex_run_sqlBRead-onlyIdempotent
Execute any SQL statement (SELECT/DML/DDL). Returns rows or affected count.
Inputs: sql (required), max_rows, bind_params. Returns: result
apex_setup_guideBRead-onlyIdempotent
Show setup requirements and instructions for this APEX MCP server.
Inputs: no named parameters. Returns: result
apex_statusARead-onlyIdempotent
Show current connection status, session state, and active app.
Inputs: no named parameters. Returns: result
apex_undo_lastADestructive
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_appARead-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
Scored across 120 tools
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.
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.
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).
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
Query your team's drift, vulnerability, and upgrade data from any AI assistant. OAuth 2.1, 51 tools.
33 tools that make AI write, implement, and verify intent against explicit, testable constraints.
Make your own apps and tools: build, edit and publish web apps from a conversation.
62 real-world tools for agents: search, scraping, social, enrichment, image, video, voice.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables 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.3MIT
- AlicenseBqualityBmaintenanceEnables AI assistants to interact with Salesforce organizations, allowing them to execute Apex code, query data, describe objects, and manage org connections through natural language.47641 npm38MIT
- FlicenseNot gradedqualityDmaintenanceEnables AI-powered database operations on Oracle Autonomous Database via natural language, including SQL translation, schema exploration, and API orchestration.4-
- AlicenseCqualityBmaintenanceEnables AI assistants to interact with LogicMonitor monitoring data through 306 structured tools, 15 workflow prompts, and 26 resources, covering alerts, devices, metrics, dashboards, and AI-driven analytics.150444 PyPI2MIT