sap-hana-xs-advanced -by-cdata

This MCP server provides a read-only interface to SAP HANA XS Advanced data via the CData JDBC driver. After starting the server, clients can query live data using the built-in MCP tools such as get_tables, get_columns, and run_query to retrieve table lists, column metadata, and results of SQL SELECT statements, respectively. The server exposes a simple JSON-RPC style of interaction, allowing AI clients or other MCP clients to request table and column metadata or execute queries without direct SQL entry. To use it with Claude Desktop or similar clients, configure an MCP entry that points to the Java jar and the corresponding .prp connection/configuration file created for your SAP HANA XS Advanced connection. Remember: this particular server is read-only, so write/update/delete operations are not exposed.

Prerequisites:

• Java (JDK 8+ preferred)
• Maven (for building the MCP server jar)
• CData JDBC Driver for SAP HANA XS Advanced (license as needed)

Installation steps:

1. Clone the repository and navigate into it:

   • git clone https://github.com/cdatasoftware/sap-hana-xs-advanced-mcp-server-by-cdata.git
   • cd sap-hana-xs-advanced-mcp-server-by-cdata

2. Build the MCP server jar:

   • mvn clean install
   • This will produce CDataMCP-jar-with-dependencies.jar (as indicated in the README).

3. Install the CData JDBC Driver for SAP HANA XS Advanced (follow the driver’s installation/licensing steps as documented by CData).

4. Create a .prp connection profile for SAP HANA XS Advanced, configuring Prefix, ServerName, ServerVersion, DriverPath, DriverClass, and JdbcUrl as described in the README. Save it as sap-hana-xs-advanced.prp.

5. Prepare the Claude Desktop config (or other MCP client) by adding an mcpServers entry that points to the jar and the sap-hana-xs-advanced.prp file, as shown in the README.

6. Run the MCP server:

   • java -jar /path/to/CDataMCP-jar-with-dependencies.jar /path/to/sap-hana-xs-advanced.prp
   • Note: The server uses stdio and is intended for clients running on the same machine.

Tips and notes:

• The MCP server is read-only by design. To enable full CRUD and actions, refer to the related full MCP server for SAP HANA XS Advanced from CData.
• Ensure the SAP HANA XS Advanced JDBC driver is properly licensed and accessible via the DriverPath in the .prp file.
• If Claude Desktop or similar clients do not detect the MCP server, fully quit and relaunch the client after starting the server, or restart your config file as needed.
• The server exposes tools in the form {servername}_get_tables, {servername}_get_columns, and {servername}_run_query. Use these tool names exactly when constructing JSON-RPC requests.
• When testing queries, you can start with simple SELECT statements to verify connectivity, then move to more complex joins as needed.
• Since the server runs via stdio, ensure the client and server are on the same host. For remote setups, consider alternative deployment approaches that preserve MCP protocol compatibility.