SAP HANA XS Advanced MCP Server

How to use

Once the MCP server is running, you connect with an MCP client to issue data‑read requests. You can ask natural language questions like, “What are my open opportunities by industry?” or “Show me calendar events for today.” The server presents the underlying data as tables and columns through built‑in tools that fetch table and column information, and execute read queries. Use these patterns to discover data you can ask about: retrieve available tables, inspect columns for a table, and run a SELECT query against a table to obtain results.

How to install

# Prerequisites
- Java JRE/JDK
- Maven
- A data source connection (see steps below)

# 1) Build the MCP server
mvn clean install

# This produces the MCP JAR: CDataMCP-jar-with-dependencies.jar

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) Download and install the CData JDBC Driver for SAP HANA XS Advanced
# Visit the driver download page and install per your OS

# 3) License the CData JDBC Driver
# Windows example
# Run from the installation directory's lib folder
java -jar cdata.jdbc.saphanaxsa.jar --license
# Enter your name, email, and TRIAL (or your license key)

# 4) Configure your connection to the data source
# Open the Connection String utility to create a connection string
java -jar cdata.jdbc.saphanaxsa.jar

# Copy the resulting connection string for use later

# 5) Create a .prp file for the JDBC connection
# Example sap-hana-xs-advanced.prp content
Prefix=saphanaxsa
ServerName=CDataSAPHANAXSA
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.saphanaxsa.jar
DriverClass=cdata.jdbc.saphanaxsa.SAPHANAXSADriver
JdbcUrl=jdbc:saphanaxsa:InitiateOAuth=GETANDREFRESH;
Tables=

Configuring the client (Claude Desktop example)

{
  "mcpServers": {
    "sap_hana_xs_advanced": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\sap-hana-xs-advanced.prp"
      ]
    },
    ...
  }
}

# Windows Claude Desktop config example
cp C:\\PATH\\TO\\claude_desktop_config.json %APPDATA%\\Claude\\claude_desktop_config.json

Running the server

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/sap-hana-xs-advanced.prp

Usage patterns and notes

The MCP server runs on stdio, so you interact with it from a local client on the same machine. No SQL is required from the client when using the built‑in tools; you can rely on natural language prompts to guide data access. If your environment uses OAuth for the data source, complete the browser authentication during connection string setup.

Notes on troubleshooting and support

If you cannot see or connect to the MCP server, ensure you have fully restarted your client after configuring the server, verify the JDBC driver is licensed, and confirm the connection string is correct. For issues with the data source connection, verify OAuth or credentials in the connection string. For further help, contact CData Support or join the CData Community.

License

This MCP server is provided under the MIT License. You may use, modify, and distribute it in accordance with the license terms.

sap_hana_xs_advanced_get_tables

Retrieves a list of tables available in the data source. The output is in CSV format with a header row.

sap_hana_xs_advanced_get_columns

Retrieves a list of columns for a specific table. The output is in CSV format with a header row.

sap_hana_xs_advanced_run_query

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