home / mcp / oraclesales mcp server

OracleSales MCP Server

This read-only MCP Server allows you to connect to Oracle Sales 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-sales-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/oracle-sales.prp"
      ]
    }
  }
}

You can query live Oracle Sales data through a read-only MCP server that wraps the CData JDBC Driver. This MCP Server exposes Oracle Sales data via a simple, no-SQL MCP interface so you can ask natural-language questions and retrieve live information without writing SQL.

How to use

Once you have the MCP server running, you use an MCP client to interact with the server. You don’t manually call individual tools in most cases; instead, you ask questions like, “What is the status of my open opportunities?” or “Show me recent calendar events.” The server translates your requests into queries against Oracle Sales via the CData JDBC Driver and returns the results in a structured format that your client can display. If you need to inspect available data models, you can query the server for the list of tables and columns, then run targeted queries to retrieve the data you need.

How to install

Prerequisites: you need Java installed on your machine and a working Java runtime able to execute JARs. You will also install the CData JDBC Driver for Oracle Sales and configure a JDBC connection.

Step 1. Clone the MCP server repository and enter the project directory.

git clone https://github.com/cdatasoftware/oracle-sales-mcp-server-by-cdata.git
cd oracle-sales-mcp-server-by-cdata

Install the MCP server JAR and driver

Step 2. Build the MCP server to create the JAR that runs the server.

mvn clean install

Install and license the CData JDBC Driver for Oracle Sales

Step 3. Download and install the CData JDBC Driver for Oracle Sales from the CData site.

Step 4. License the driver using the command in the driver’s lib folder.

java -jar cdata.jdbc.oraclesales.jar --license

Configure the data source connection

Step 5. Run the Connection String utility to configure the connection and test it. Copy the resulting connection string for later use.

java -jar cdata.jdbc.oraclesales.jar

Create the MCP PRP file

Step 6. Create a PRP file (e.g. oracle-sales.prp) with the JDBC connection details so the MCP server can connect to Oracle Sales.

Prefix=oraclesales
ServerName=CDataOracleSales
ServerVersion=1.0
DriverPath=PATH\\TO\\cdata.jdbc.oraclesales.jar
DriverClass=cdata.jdbc.oraclesales.OracleSalesDriver
JdbcUrl=jdbc:oraclesales:InitiateOAuth=GETANDREFRESH;
Tables=

Prepare Claude or another MCP client config

If you use an MCP client like Claude Desktop, create a config that loads the MCP server via the provided JAR and PRP file.

{
  "mcpServers": {
    "oraclesales": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/oracle-sales.prp"
      ]
    }
  }
}

Available tools

oraclesales_get_tables

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

oraclesales_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.

oraclesales_run_query

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