This MCP server exposes SAP Sybase data through a read-only interface powered by CData's MCP for the SAP Sybase JDBC driver. It enables an autonomous AI client (like Claude Desktop) to query live SAP Sybase data using natural language questions without writing SQL. The server provides tools to discover available data structures and to run read-only queries against the source. Tools are named based on the server identifier (sap_sybase) and include: sap_sybase_get_tables to list available tables, sap_sybase_get_columns to list columns for a table, and sap_sybase_run_query to execute a SELECT query. You typically configure Claude Desktop with a .prp file that points to the JAR and your connection details, then add an mcpServers entry to Claude's config so the client can reach the MCP server.

To use, first ensure you have a properly configured sap-sybase.prp (as described in the Setup Guide). Launch the MCP server with the provided java command, then refresh Claude Desktop or your client so the new server appears. Once connected, ask the AI to explore data or fetch specific information, for example: “What is the revenue by region from Accounts?” or “Show me open opportunities for the Salesforce example.” The built-in tools will return results in CSV format (for tables/columns) or as data payloads for queries, enabling live data access without manual SQL authoring.

Prerequisites:

• Java installed (JDK 8+).
• Maven installed for building the server jar (optional if you already have the prebuilt JAR).
• Access to the CData JDBC Driver for SAP Sybase and the corresponding license as described in the Setup Guide.

Install steps:

1. Clone the repository and build the server (if you don’t already have the prebuilt JAR): git clone https://github.com/cdatasoftware/sap-sybase-mcp-server-by-cdata.git cd sap-sybase-mcp-server-by-cdata mvn clean install

   This creates the JAR at: CDataMCP-jar-with-dependencies.jar

2. Download and install the CData JDBC Driver for SAP Sybase from the official site and license it as described in the Setup Guide.
3. Prepare a .prp file for your JDBC connection (sap-sybase.prp) with the required properties (Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, Tables).
4. Run the MCP server using the provided JAR and PRP file: java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/sap-sybase.prp Note: The server uses stdio for I/O, so it must be run on the same machine as the client unless configured otherwise.

Tips and notes:

• The MCP server is read-only by default in this package. If you need write/update/delete capabilities, use the full enterprise MCP server from CData.
• Ensure the sap-sybase.prp file is correctly configured with a valid JDBC connection string obtained via the CData Connection String utility.
• When Claude Desktop cannot see the MCP server, fully quit and relaunch Claude Desktop or ensure the config.json has the sap_sybase entry under mcpServers.
• For OAuth-based data sources, authentication may occur in a browser during connection string setup; complete this before starting the MCP server.
• The CLI/tooling expects the server to be accessible on the same host as Claude Desktop since stdio is used for communication.