MCP Oracle Server

Provides MCP endpoints to query Oracle data via SELECT, describe tables, and list tables.

javascript

GitHub Stars

javascript

Language

4 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "yrsonhtm-mcp-oracle-server": {
      "command": "node",
      "args": [
        "RUTA_DONDE_INSTALA_EL_SERVER: EJ: C:\\mcp-oracle-server\\server.js"
      ],
      "env": {
        "ORACLE_HOST": "HOST_SERVER: EJ:10.10.10.10",
        "ORACLE_PORT": "PRT: EJ:1521",
        "ORACLE_USER": "NOMBRE_USUARIO: EJ:admin",
        "ORACLE_DATABASE": "NOMBRE_BASE_DATOS: EJ:pruebadb",
        "ORACLE_PASSWORD": "CONTRASEÑA: EJ:1234"
      }
    }
  }
}

You run an MCP server that exposes safe Oracle database interactions over the Model Context Protocol. You can execute SELECT queries, describe table structures, and list available tables for the connected user, enabling easy integration with MCP-enabled clients and workflows while protecting the data from unintended changes.

How to use

Start the server and connect your MCP client to the local stdio interface. You will use three MCP actions: execute a SELECT query, describe a table, or list all tables for the connected user. These actions are read-only to prevent accidental data modification.

Typical usage patterns include running a SELECT query to fetch data for reporting, inspecting table schemas to understand columns and data types, and listing tables to discover available sources you can query. Ensure your environment variables for Oracle are set so the server can authenticate and reach the database.

How to install

Prerequisites: Node.js version 18 or higher. Ensure you have access to an Oracle database and the following environment variables configured for the Oracle connection.

Clone the project and enter its directory.

git clone https://github.com/YrsonHTM/mcp-oracle-server.git
cd mcp-oracle-server

Install dependencies.

npm install

Start the server.

npm start

Additional notes

The server exposes three MCP capabilities: execute_query for running SELECT statements, describe_table to describe a table’s structure, and list_tables to enumerate all tables accessible to the connected user.

If you encounter connection issues, verify that your Oracle environment variables are correctly set and that the Oracle database is reachable from the server host.

Configuration for MCP clients (example)

You can connect to the local MCP server over the stdio channel using a client like Cursor. The following example shows how to configure the MCP connection in Cursor.

{
  "mcpServers": {
    "oracle_db": {
      "command": "node",
      "args": ["RUTA_DONDE_INSTALA_EL_SERVER: EJ: C:\\mcp-oracle-server\\server.js"],
      "env": {
        "ORACLE_HOST": "HOST_SERVER: EJ:10.10.10.10",
        "ORACLE_PORT": "PRT: EJ:1521",
        "ORACLE_DATABASE": "NOMBRE_BASE_DATOS: EJ:pruebadb",
        "ORACLE_USER": "NOMBRE_USUARIO: EJ:admin",
        "ORACLE_PASSWORD": "CONTRASEÑAñ EJ:1234"
      }
    }
  }
}

Available tools

execute_query

Executes a SELECT query against the Oracle database and returns the result set.

describe_table

Describes the structure of a specified Oracle table, including column names and types.

list_tables

Lists all tables available to the connected Oracle user.

Built by

VeilStrat

AI signals for GTM teams