MCP Oracle Server MCP Server

Este proyecto es un **servidor Node.js** que expone herramientas para interactuar con una base de datos Oracle a través del protocolo Model Context

Local serverstdio

What is the MCP Oracle Server MCP server?

Este proyecto es un servidor Node.js que expone herramientas para interactuar con una base de datos Oracle a través del protocolo Model Context Protocol (MCP). Permite ejecutar consultas SELECT, describir tablas y listar tablas. That is what the mcp oracle server mcp server brings to an AI assistant: the same capability, reachable through the Model Context Protocol rather than a separate app or dashboard.

The tools it exposes

The server publishes 5 tools. What each one is for:

  • ORACLE_USER — ORACLE_PASSWORD
  • ORACLE_HOST — ORACLE_PORT
  • execute_query — Ejecuta una consulta SELECT en Oracle
  • describe_table — Describe la estructura de una tabla
  • list_tables — Lista todas las tablas disponibles para el usuario

What it needs from you

Configuration is passed through the environment: ORACLE_HOST, ORACLE_PORT, ORACLE_DATABASE, ORACLE_USER, ORACLE_PASSWORD. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.

Getting it running

Setup follows the usual MCP pattern — install or clone the server, register it in your client's configuration file, restart the client.

How it compares

This sits in the developer tooling group, where several servers overlap in what they claim to do but differ sharply once you actually set them up. MCP Oracle Server's toolset — ORACLE_USER, ORACLE_HOST, execute_query and 2 more — is a fair guide to whether it matches your workflow. It is maintained by YrsonHTM; worth a glance at recent repository activity before you build anything load-bearing on it.

We check each listing at SyncDev against the project's documentation before it goes live — if something here drifts out of date, it is a bug worth reporting.

Things to watch

  • It runs with your machine's permissions. That is convenient and also the reason to think about what you point it at before you approve a tool call.
  • Keep per-call confirmation enabled while you learn its behaviour; it is the cheapest safeguard you have.

Available tools

ToolWhat it does
ORACLE_USERORACLE_PASSWORD
ORACLE_HOSTORACLE_PORT
execute_queryEjecuta una consulta SELECT en Oracle.
describe_tableDescribe la estructura de una tabla.
list_tablesLista todas las tablas disponibles para el usuario.

Configuration

VariableDescriptionRequired
ORACLE_HOSTEndpoint or connection string the server talks to.Optional
ORACLE_PORTConfiguration value read at startup.Optional
ORACLE_DATABASEConfiguration value read at startup.Optional
ORACLE_USERConfiguration value read at startup.Optional
ORACLE_PASSWORDConfiguration value read at startup.Optional

Example prompts to try

  • Use MCP Oracle Server to ORACLE USER.
  • Use MCP Oracle Server to ORACLE HOST.
  • Use MCP Oracle Server to execute query.

Frequently asked questions

It connects MCP Oracle Server to MCP-compatible AI assistants such as Claude and Cursor, exposing 5 tools (ORACLE_USER, ORACLE_HOST, execute_query, 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 Server directly.