# Oracle Autonomous Database Configuration
# Based on your ORDS URL: https://gfca71b2aacce62-photosightdb.adb.us-chicago-1.oraclecloudapps.com
# For Oracle Cloud Autonomous Database, you need:
# 1. Download the wallet file from Oracle Cloud Console
# 2. Extract it to a directory (e.g., ~/oracle-wallet/)
# 3. Set the TNS_ADMIN environment variable to point to that directory
# Connection method for ADB (using TNS from wallet)
ORACLE_TNS_NAME=photosightdb_high # Check tnsnames.ora in your wallet for exact name
ORACLE_USER=admin # or your specific username
ORACLE_PASSWORD=your_password_here
# Alternative: Direct connection string (if you have the full connection details)
# ORACLE_CONNECTION_STRING=(description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-chicago-1.oraclecloud.com))(connect_data=(service_name=gfca71b2aacce62_photosightdb_high.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))
# Path to wallet directory (required for ADB)
TNS_ADMIN=/path/to/your/wallet/directory
# Optional: Default schema
# ORACLE_DEFAULT_SCHEMA=ADMIN
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/samscarrow/oracle-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server