home / mcp / oracle mcp server

Oracle MCP Server

This read-only MCP Server allows you to connect to Oracle data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-oracle-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/oracle.prp"
      ]
    }
  }
}

You can query live Oracle data through a read-only MCP server that wraps the CData JDBC Driver for Oracle. This enables you to ask natural-language questions and get up-to-date results without writing SQL, making it easy to integrate Oracle data into MCP-enabled clients.

How to use

Once the MCP server is running, you connect your MCP client to it and use built-in data access tools to read Oracle data. You can ask questions like, “What is the status of open opportunities?” or “Show me account details for top customers.” The client will automatically retrieve data through the MCP server, returning results in a structured format such as tables or CSV-like outputs. You do not need to craft SQL queries; simply pose your questions and the MCP server translates them into data access operations.

How to install

Prerequisites you need to prepare before installing include Java and Maven, since the server is built with Maven and run with the Java runtime.

Step-by-step commands to set up and run the MCP server locally:

# 1) Clone the MCP server repository
git clone https://github.com/cdatasoftware/oracle-mcp-server-by-cdata.git
cd oracle-mcp-server-by-cdata

# 2) Build the server and create the runnable JAR
mvn clean install
# This produces CDataMCP-jar-with-dependencies.jar
```
{ } ,{

Available tools

oracle_get_tables

Retrieves a list of tables available in the Oracle data source. The output is provided in CSV format with column headers on the first line.

oracle_get_columns

Retrieves a list of columns for a specified table. The output is provided in CSV format with column headers on the first line.

oracle_run_query

Executes a SQL SELECT query against the Oracle data source and returns the results.