Oracle APEX MCP Server

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.

→ silviosotelo/oracle-apex-mcp-server · listed on glama

Install from

Glama

M8ven verifies MCPs across every public registry — install directly from whichever one you prefer.

// key findings

⚠️

Known vulnerabilities in dependencies: 2 high

Affects packages this MCP installs at runtime. Upgrade or remove the affected dependency.

✅

No credential exfiltration, no sensitive file access, no obfuscation

Static analysis found nothing flowing your secrets to unexpected places.

🔐

You'll be asked for 1 credential: ORACLE_PASSWORD

These are read from process.env at runtime. Make sure you trust where they’ll be sent.

// required environment variables

This server reads these from process.env. You'll be asked to provide them before it can run.

configORACLE_CLIENT_LIB_DIR— _(none)_ Path to Oracle Instant Client (Thick mode only)

configORACLE_CONNECTION_STRING— _(auto-built)_ Full TNS connect string (overrides host/port/service)

configORACLE_FETCH_SIZE— 100 Fetch array size

configORACLE_HOME— TNS names: auto-discovers tnsnames.ora from , TNS_ADMIN, or common paths

configORACLE_HOST— localhost Oracle DB hostname

configORACLE_OLD_CRYPTO— false Set true to enable Thick mode (required for pre-12c databases)

🔐 secretORACLE_PASSWORD— _(empty)_ Database password

configORACLE_POOL_MAX— 10 Maximum pool connections

configORACLE_POOL_MIN— 1 Minimum pool connections

configORACLE_POOL_TIMEOUT— 60 Pool timeout in seconds

configORACLE_PORT— 1521 Oracle DB port

configORACLE_SERVICE_NAME— XE Oracle service name

configORACLE_STMT_CACHE_SIZE— 30 Statement cache size

configORACLE_TNS_ALIAS— _(none)_ TNS alias to use from tnsnames.ora

configORACLE_USER— ORACLE_USERNAME hr Database username (also reads )

configORACLE_USERNAME— hr Database username (also reads ORACLE_USER)

configTNS_ADMIN— TNS names: auto-discovers tnsnames.ora from ORACLE_HOME, , or common paths

configTNS_NAMES_FILE— _(auto-detected)_ Explicit path to tnsnames.ora

// full audit trail

The full breakdown of what we checked, the deductions that landed, the network hosts, the dependency advisories, and concrete fix guidance is available to verified publishers.

// improvement guidance — verified publishers only

We have 7 concrete improvements we can share with the publisher of this MCP. Each comes with specific guidance to raise the trust score.

// embed badge in your README

[![M8ven Score](https://m8ven.ai/badge/mcp/silviosotelo-oracle-apex-mcp-server-s7pzyb)](https://m8ven.ai/mcp/silviosotelo-oracle-apex-mcp-server-s7pzyb)

commit: 9cce4664c1b60be8def6d7eadbd2cd100a70c49f

code hash: 07cad33d8e27b2c07d9704e0b3abf9882cd145d4f78d704bd3d0f8ff79124d32

verified: 4/11/2026, 2:51:18 PM

view raw JSON →