Skip to main content
Glama
silviosotelo

Oracle APEX MCP Server

by silviosotelo

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
TNS_ADMINNoDirectory containing tnsnames.ora
ORACLE_HOMENoOracle home directory (fallback for TNS lookup)
ORACLE_HOSTNoOracle DB hostnamelocalhost
ORACLE_PORTNoOracle DB port1521
TNS_NAMES_FILENoExplicit path to tnsnames.ora
ORACLE_PASSWORDNoDatabase password
ORACLE_POOL_MAXNoMaximum pool connections10
ORACLE_POOL_MINNoMinimum pool connections1
ORACLE_USERNAMENoDatabase username (also reads ORACLE_USER)hr
ORACLE_TNS_ALIASNoTNS alias to use from tnsnames.ora
ORACLE_FETCH_SIZENoFetch array size100
ORACLE_OLD_CRYPTONoSet true to enable Thick mode (required for pre-12c databases)false
ORACLE_POOL_TIMEOUTNoPool timeout in seconds60
ORACLE_SERVICE_NAMENoOracle service nameXE
ORACLE_CLIENT_LIB_DIRNoPath to Oracle Instant Client (Thick mode only)
ORACLE_STMT_CACHE_SIZENoStatement cache size30
ORACLE_CONNECTION_STRINGNoFull TNS connect string (overrides host/port/service)

Capabilities

Server capabilities have not been inspected yet.

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/silviosotelo/oracle-apex-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server