Oracle Database MCP

A Model Context Protocol server for working with large Oracle databases. It provides contextual schema information for databases with thousands of tables, letting AI assistants understand relationships, look up table and column definitions, and run queries without loading the entire schema into context.

{
  "mcpServers": {
    "oracle-database": {
      "command": "npx",
      "args": [],
      "env": {
        "ORACLE_CONNECTION_STRING": "<YOUR_ORACLE_CONNECTION_STRING>"
      }
    }
  }
}

{
  "type": "object",
  "required": [
    "table"
  ],
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name to describe"
    }
  }
}

{
  "type": "object",
  "required": [
    "sql"
  ],
  "properties": {
    "sql": {
      "type": "string",
      "description": "SQL statement to execute"
    }
  }
}