home / mcp / sap bydesign mcp server

SAP ByDesign MCP Server

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

You can query live SAP ByDesign data through a read-only MCP server that wraps the CData JDBC Driver. This server exposes SAP ByDesign data via a simple MCP interface so you can ask natural-language questions and get up-to-date results without writing SQL.

How to use

You connect your MCP client to the local MCP server and start a process that exposes SAP ByDesign data as MCP endpoints. Once running, you can ask questions like “What is the status of open opportunities by industry?” or “Show me calendar events for today,” and the AI client will use the exposed tools to read data from SAP ByDesign.

How to install

Prerequisites: you need Java installed on your machine and a Java build tool to compile the server.

1) Clone the project and open the directory.

git clone https://github.com/cdatasoftware/sap-bydesign-mcp-server-by-cdata.git
cd sap-bydesign-mcp-server-by-cdata

2) Build the server to produce the runnable JAR.

mvn clean install

Running the server

Start the MCP server using the built JAR and your prepared configuration file. The final command runs on the same machine as Claude Desktop or any client that uses stdio.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/sap-bydesign.prp

Notes on configuration and startup

The server uses stdio for communication, so the MCP client must run on the same machine. You supply a configuration file (sap-bydesign.prp) that points to the SAP ByDesign data source via the CData JDBC Driver. No authentication or OAuth steps are required here beyond what you configure in the JDBC driver setup.

Security and maintenance

Keep the JDBC driver up to date and license-activated. If you modify data source connections, re-generate the sap-bydesign.prp file with the correct JdbcUrl and driver details.

Troubleshooting

If the MCP server does not appear in your client, ensure you have fully terminated and restarted the client after starting the server. Verify that the sap-bydesign.prp file points to valid driver jars and a reachable SAP ByDesign data source.

Available tools

bydesign_get_tables

Retrieves the list of tables available from the SAP ByDesign data source. Output is in CSV format with a header row.

bydesign_get_columns

Retrieves the list of columns for a specified table. Output is in CSV format with a header row.

bydesign_run_query

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