oracle-mcp-server-by-cdata

oracle-mcp-server-by-cdata

0
databasesdeveloper_tools

This project provides a Model Context Protocol (MCP) Server for Oracle, allowing querying of live Oracle data using natural language queries through large language models like Claude Desktop. It simplifies data interaction by wrapping the CData JDBC Driver for Oracle into an MCP interface.

oracle-mcp-server-by-cdata

CData's Model Context Protocol (MCP) Server for Oracle

Purpose

This is a read-only MCP Server enabling LLMs (like Claude Desktop) to query live data from Oracle, supported by the CData JDBC Driver. It wraps the driver and presents Oracle data via a simple MCP interface, enabling natural language queries without SQL.

Setup Guide

  1. Clone and build the repository.
  2. Install the CData JDBC Driver for Oracle.
  3. License the JDBC Driver.
  4. Configure the data source connection string.
  5. Create a .prp file for JDBC connection configuration.

Using the Server with Claude Desktop

  • Add your server to the Claude Desktop config.
  • Update setup steps for Windows or Linux/Mac as needed.

Running the Server

  • Execute the server with the provided command.

Usage Details

Once set up, the AI client can utilize built-in tools to interact with the data, just by asking questions.

Tools & Descriptions

  • {servername}_get_tables: Retrieves available tables.
  • {servername}_get_columns: Lists columns for a table.
  • {servername}_run_query: Executes a SQL SELECT query.

Troubleshooting

  • Ensure proper setup and connections.
  • Contact CData Support for further assistance.

License

Licensed under the MIT License.