apex-mcp is a Model Context Protocol (MCP) server that gives AI assistants 116 tools to build Oracle APEX 24.2 applications programmatically. Instead of navigating the APEX App Builder UI, you describe what you want and your AI assistant does the work — creating apps, generating CRUD pages, adding JET charts, configuring auth schemes, and more.Documentation Index
Fetch the complete documentation index at: https://mintlify.com/TechFernandesLTDA/apex-mcp/llms.txt
Use this file to discover all available pages before exploring further.
Quickstart
Install apex-mcp and connect your first AI client to Oracle APEX in minutes.
Configuration
Set up Oracle connection credentials, APEX workspace, and transport options.
AI Client Setup
Connect Claude, GPT, Gemini, Cursor, VS Code, or any MCP-compatible client.
Tool Reference
Browse all 116 tools across connection, apps, pages, components, and generators.
What you can build
apex-mcp connects to Oracle Autonomous Database via theoracledb thin driver (mTLS wallet — no Oracle Instant Client required) and generates APEX applications by executing the same wwv_flow_imp_page.* PL/SQL API that APEX uses internally.
Full Apps from Schema
Generate a complete app with CRUD pages, dashboard, and navigation from a list of tables in one command.
Charts & Dashboards
Add Oracle JET charts, metric cards, gauges, funnels, and 10 advanced chart types to any page.
REST Endpoints
Generate ORDS REST endpoints (GET/POST/PUT/DELETE) for any table with a single tool call.
Interactive Components
Add Interactive Grids, master-detail regions, faceted search, wizards, and modal forms.
20 UI Components
Hero banners, KPI rows, leaderboards, heatmaps, activity streams, and more via rich HTML regions.
DevOps Tools
Export pages as SQL, generate Markdown docs, diff app structure, and run batch operations.
Get started
Set environment variables
Configure your Oracle connection and APEX workspace credentials — see the Configuration guide for all required variables.
Connect your AI client
Add apex-mcp to your AI client’s MCP configuration. Pick your client from the AI Client Setup guides.
Build your first app
Ask your AI assistant: “Connect to Oracle and list all APEX applications in the workspace.” Then follow the Build Your First App guide.
Supported AI clients
| Client | Transport | Setup Guide |
|---|---|---|
| Claude Code / Desktop | stdio | Setup guide |
| Cursor IDE | stdio | Setup guide |
| VS Code / GitHub Copilot | stdio or HTTP | Setup guide |
| Google Gemini CLI | stdio | Setup guide |
| GPT / OpenAI Agents SDK | streamable-HTTP | Setup guide |
| ZAI (visual companion) | n/a | Setup guide |
apex-mcp requires Python 3.11+, Oracle APEX 24.2 (Universal Theme 42), and an Oracle Autonomous Database with mTLS wallet access.