MCP Oracle Database Server

claude mcp add oracle-database --env ORACLE_HOST='<ORACLE_HOST>' --env ORACLE_PORT='<ORACLE_PORT>' --env ORACLE_SERVICE_NAME='<ORACLE_SERVICE_NAME>' --env ORACLE_USERNAME='<ORACLE_USERNAME>' --env ORACLE_PASSWORD='<ORACLE_PASSWORD>' -- npx @grec0/mcp-oracle-db

~/.codex/config.toml

[mcp_servers.oracle-database]
command = "npx"
args = ["@grec0/mcp-oracle-db"]
env = { ORACLE_HOST = "<ORACLE_HOST>", ORACLE_PORT = "<ORACLE_PORT>", ORACLE_SERVICE_NAME = "<ORACLE_SERVICE_NAME>", ORACLE_USERNAME = "<ORACLE_USERNAME>", ORACLE_PASSWORD = "<ORACLE_PASSWORD>" }

# codex mcp add oracle-database --env ORACLE_HOST='<ORACLE_HOST>' --env ORACLE_PORT='<ORACLE_PORT>' --env ORACLE_SERVICE_NAME='<ORACLE_SERVICE_NAME>' --env ORACLE_USERNAME='<ORACLE_USERNAME>' --env ORACLE_PASSWORD='<ORACLE_PASSWORD>' -- npx @grec0/mcp-oracle-db

~/.cursor/mcp.json

{
  "mcpServers": {
    "oracle-database": {
      "command": "npx",
      "args": [
        "@grec0/mcp-oracle-db"
      ],
      "env": {
        "ORACLE_HOST": "<ORACLE_HOST>",
        "ORACLE_PORT": "<ORACLE_PORT>",
        "ORACLE_SERVICE_NAME": "<ORACLE_SERVICE_NAME>",
        "ORACLE_USERNAME": "<ORACLE_USERNAME>",
        "ORACLE_PASSWORD": "<ORACLE_PASSWORD>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "oracle-database": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "@grec0/mcp-oracle-db"
      ],
      "env": {
        "ORACLE_HOST": "<ORACLE_HOST>",
        "ORACLE_PORT": "<ORACLE_PORT>",
        "ORACLE_SERVICE_NAME": "<ORACLE_SERVICE_NAME>",
        "ORACLE_USERNAME": "<ORACLE_USERNAME>",
        "ORACLE_PASSWORD": "<ORACLE_PASSWORD>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "oracle-database": {
      "command": "npx",
      "args": [
        "@grec0/mcp-oracle-db"
      ],
      "env": {
        "ORACLE_HOST": "<ORACLE_HOST>",
        "ORACLE_PORT": "<ORACLE_PORT>",
        "ORACLE_SERVICE_NAME": "<ORACLE_SERVICE_NAME>",
        "ORACLE_USERNAME": "<ORACLE_USERNAME>",
        "ORACLE_PASSWORD": "<ORACLE_PASSWORD>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "oracle-database": {
      "command": "npx",
      "args": [
        "@grec0/mcp-oracle-db"
      ],
      "env": {
        "ORACLE_HOST": "<ORACLE_HOST>",
        "ORACLE_PORT": "<ORACLE_PORT>",
        "ORACLE_SERVICE_NAME": "<ORACLE_SERVICE_NAME>",
        "ORACLE_USERNAME": "<ORACLE_USERNAME>",
        "ORACLE_PASSWORD": "<ORACLE_PASSWORD>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "oracle-database": {
      "command": "npx",
      "args": [
        "@grec0/mcp-oracle-db"
      ],
      "env": {
        "ORACLE_HOST": "<ORACLE_HOST>",
        "ORACLE_PORT": "<ORACLE_PORT>",
        "ORACLE_SERVICE_NAME": "<ORACLE_SERVICE_NAME>",
        "ORACLE_USERNAME": "<ORACLE_USERNAME>",
        "ORACLE_PASSWORD": "<ORACLE_PASSWORD>"
      }
    }
  }
}