oracle-mcp-server
by Tommi2Day
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PORT | No | HTTP(S) port. | 3000 |
| ORA_SID | No | SID (instead of service name). | |
| TLS_SAN | No | Extra SANs for the generated self-signed certificate. | |
| ORA_HOST | No | Database host. | localhost |
| ORA_PORT | No | Listener port. | 1521 |
| ORA_USER | No | Oracle database user. | |
| LOG_LEVEL | No | Log level: `debug`, `info`, `warn` or `error`. | info |
| TNS_ADMIN | No | Directory with `*.ora` files and wallets. In the Docker image default is `/opt/oracle/network/admin`. | |
| TRANSPORT | No | Transport mode: `stdio` or `http`. | stdio |
| AUTH_TOKEN | No | Admin bearer token. Empty disables auth (dev only). | |
| TLS_CA_FILE | No | CA for client certificates (enables mTLS on the MCP endpoint). | |
| TLS_ENABLED | No | Enable HTTPS for the MCP endpoint. | false |
| TOKENS_FILE | No | Token store file (in Docker image: `/data/tokens.json`). | ./tokens.json |
| ORA_MAX_ROWS | No | Row limit of the `query` tool. | 200 |
| ORA_PASSWORD | No | Oracle database password. | |
| ORA_POOL_MAX | No | Max connections per pool. | 5 |
| ORA_PROTOCOL | No | Protocol: `tcp` or `tcps`. | tcp |
| TLS_KEY_FILE | No | TLS server key file. | /certs/tls.key |
| ORA_TNS_ALIAS | No | Alias from `tnsnames.ora`. | |
| TLS_CERT_FILE | No | TLS server certificate file. | /certs/tls.crt |
| ORA_PERF_TOOLS | No | Performance analysis tools (`false` hides all of them). | true |
| MCP_SERVER_NAME | No | Name shown in MCP clients and the admin UI. | oracle-mcp-server |
| ORA_DRIVER_MODE | No | Oracle driver mode: `thin` or `thick`. | thin |
| ORA_TLS_CA_FILE | No | Additional trusted CA certificates (PEM bundle). | |
| ORA_TUNING_PACK | No | Enable Tuning Pack tools (`sql_monitor`). | false |
| ORA_SERVICE_NAME | No | Service name. | |
| ORA_PASSWORD_FILE | No | Read the password from a file (Docker/K8s secrets). | |
| ORA_CLIENT_LIB_DIR | No | Instant Client directory for thick mode. In the thick Docker image default is `/opt/oracle/instantclient`. | |
| ORA_CONNECT_STRING | No | Free connect string / JDBC URL. | |
| ORA_CONNECT_TIMEOUT | No | Connect timeout in seconds. | 10 |
| ORA_WALLET_LOCATION | No | Wallet directory. Defaults to `TNS_ADMIN` if it contains `ewallet.pem`. | |
| ORA_WALLET_PASSWORD | No | Password of an encrypted `ewallet.pem`. | |
| ORA_DIAGNOSTICS_PACK | No | Enable Diagnostics Pack tools (`ash_top`, `awr_top_events`). | false |
| STORE_ENCRYPTION_KEY | No | Encrypts password / wallet_password in the token store (AES-256-GCM). | |
| ORA_SSL_SERVER_CERT_DN | No | Expected server certificate DN. | |
| ORA_SSL_SERVER_DN_MATCH | No | Verify server host name / DN. | true |
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 | |
This server cannot be deployed
Maintenance
ActivityMaintained
ResponsivenessNo issues