MCP Oracle Db MCP Server

MCP server para integración completa con Oracle Database

Local serverstdio

What is the MCP Oracle Db MCP server?

If you want an AI assistant working directly with MCP Oracle Db, the mcp oracle db mcp server is the bridge. MCP server para integración completa con Oracle Database.

What MCP Oracle Db does

Servidor MCP (Model Context Protocol) para integración completa con Oracle Database. Permite ejecutar consultas SQL, comandos DDL/DML, gestionar transacciones y explorar la estructura de la base de datos directamente desde aplicaciones MCP.

Tools it exposes

Once connected, the assistant can call these 14 tools directly:

  • Compatibilidad — Soporte para versiones antiguas de Oracle (pre-12c)
  • Monitoreo — Health checks y estadísticas de conexión
  • Windows — [instantclient-basic-windows.x64-19.26.0.0.0dbru.zip](https://download.oracle.com/otn_software/nt/instantclient/1926000/instantclient-basic-windows.x64-19.26.0
  • macOS — ~/Library/Application Support/Claude/claude_desktop_config.json
  • Linux — ~/.config/claude/claude_desktop_config.json
  • Node.js — >=18.0.0
  • Sistemas — Windows, Linux, macOS
  • Variable — Descripción
  • ORACLE_HOST — Host del servidor Oracle
  • ORACLE_PORT — Puerto de Oracle
  • ORACLE_SERVICE_NAME — Nombre del servicio Oracle
  • ORACLE_USERNAME — Usuario de base de datos
  • ORACLE_PASSWORD — Contraseña de base de datos
  • ORACLE_CONNECTION_STRING — Connection string completo (alternativo)

Installing the mcp oracle db mcp server

Setup follows the standard MCP pattern: clone or install the server, then register it in your client's configuration file and restart the client. The configuration snippets on this page cover Claude Desktop, Claude Code and Cursor.

Configuration

The server reads 7 environment variables: ORACLE_HOST, ORACLE_PORT, ORACLE_SERVICE_NAME, ORACLE_USERNAME, ORACLE_PASSWORD, ORACLE_OLD_CRYPTO, ORACLE_CLIENT_LIB_DIR. Keep credentials in your client's env block or a secrets manager rather than committing them.

Where it fits

Database servers turn schema archaeology and ad-hoc reporting into conversation, which is why they tend to be the second or third server people install. MCP Oracle Db sits in that group, and the shape of its toolset — Compatibilidad, Monitoreo, Windows among others — tells you what it is really for. Worth comparing against the other databases servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.

Practical notes

  • This server runs locally, so it operates with whatever access your machine and its credentials already have. Scope that deliberately rather than by default.
  • With 14 tools exposed, expect a noticeable bump in prompt size — disable it in projects that never use MCP Oracle Db.
  • Maintained by gcorroto.
  • MCP clients ask for confirmation before each tool call by default. Keep that on while you learn what the mcp oracle db mcp server actually does with your data.
  • Every entry in this directory is reviewed by hand before it goes live, and details are checked against the project's own documentation.

Available tools

ToolWhat it does
CompatibilidadSoporte para versiones antiguas de Oracle (pre-12c)
MonitoreoHealth checks y estadísticas de conexión
Windows[instantclient-basic-windows.x64-19.26.0.0.0dbru.zip](https://download.oracle.com/otn_software/nt/instantclient/1926000/instantclient-basic-windows.x64-19.26.0.0.0dbru.zip)
macOS~/Library/Application Support/Claude/claude_desktop_config.json
Linux~/.config/claude/claude_desktop_config.json
Node.js>=18.0.0
SistemasWindows, Linux, macOS
VariableDescripción
ORACLE_HOSTHost del servidor Oracle
ORACLE_PORTPuerto de Oracle
ORACLE_SERVICE_NAMENombre del servicio Oracle
ORACLE_USERNAMEUsuario de base de datos
ORACLE_PASSWORDContraseña de base de datos
ORACLE_CONNECTION_STRINGConnection string completo (alternativo)

How to install the MCP Oracle Db MCP server

{
  "mcpServers": {
    "oracle-db": {
      "command": "npx",
      "args": ["@grec0/mcp-oracle-db"],
      "env": {
        "ORACLE_HOST": "tu-host-oracle",
        "ORACLE_PORT": "1521",
        "ORACLE_SERVICE_NAME": "tu-servicio",
        "ORACLE_USERNAME": "usuario",
        "ORACLE_PASSWORD": "contraseña",
        "ORACLE_OLD_CRYPTO": "true",
        "ORACLE_CLIENT_LIB_DIR": "C:\\oracle\\instantclient_19_26"
      }
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

VariableDescriptionRequired
ORACLE_HOSTEndpoint or connection string the server talks to.Optional
ORACLE_PORTConfiguration value read at startup.Optional
ORACLE_SERVICE_NAMEConfiguration value read at startup.Optional
ORACLE_USERNAMEConfiguration value read at startup.Optional
ORACLE_PASSWORDConfiguration value read at startup.Optional
ORACLE_OLD_CRYPTOConfiguration value read at startup.Optional
ORACLE_CLIENT_LIB_DIRFilesystem location the server is allowed to use.Optional

Example prompts to try

  • Use MCP Oracle Db to Compatibilidad.
  • Use MCP Oracle Db to Monitoreo.
  • Use MCP Oracle Db to Windows.

Frequently asked questions

It connects MCP Oracle Db to MCP-compatible AI assistants such as Claude and Cursor, exposing 14 tools (Compatibilidad, Monitoreo, Windows, and more) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with MCP Oracle Db directly.