Oracle APEX MCP Server
by silviosotelo
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| TNS_ADMIN | No | Directory containing tnsnames.ora | |
| ORACLE_HOME | No | Oracle home directory (fallback for TNS lookup) | |
| ORACLE_HOST | No | Oracle DB hostname | localhost |
| ORACLE_PORT | No | Oracle DB port | 1521 |
| TNS_NAMES_FILE | No | Explicit path to tnsnames.ora | |
| ORACLE_PASSWORD | No | Database password | |
| ORACLE_POOL_MAX | No | Maximum pool connections | 10 |
| ORACLE_POOL_MIN | No | Minimum pool connections | 1 |
| ORACLE_USERNAME | No | Database username (also reads ORACLE_USER) | hr |
| ORACLE_TNS_ALIAS | No | TNS alias to use from tnsnames.ora | |
| ORACLE_FETCH_SIZE | No | Fetch array size | 100 |
| ORACLE_OLD_CRYPTO | No | Set true to enable Thick mode (required for pre-12c databases) | false |
| ORACLE_POOL_TIMEOUT | No | Pool timeout in seconds | 60 |
| ORACLE_SERVICE_NAME | No | Oracle service name | XE |
| ORACLE_CLIENT_LIB_DIR | No | Path to Oracle Instant Client (Thick mode only) | |
| ORACLE_STMT_CACHE_SIZE | No | Statement cache size | 30 |
| ORACLE_CONNECTION_STRING | No | Full TNS connect string (overrides host/port/service) |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |