adp -by-cdata

This MCP server exposes live ADP data through a read-only MCP interface using the CData JDBC Driver for ADP. It wraps the JDBC driver and presents it to clients (such as Claude Desktop) as MCP tools that can query metadata, list tables and columns, and run SELECT queries. After starting the server, you can query live data without writing SQL in your client—just use the built-in tools described below or issue JSON-RPC calls to the MCP server.

The available tools are named based on the configured server (e.g., adp). The typical workflow is to first retrieve the list of available tables with adp_get_tables, then inspect columns with adp_get_columns for a specific table, and finally run adp_run_query with a SQL SELECT statement to fetch data. These tools return results in CSV format for tables and columns, and standard result formats for query results. To integrate with Claude Desktop, add a Claude config entry that points to the Java process and the adp.prp properties file. The server uses stdio, so it runs on the same machine as the client.

Prerequisites:

• Java Runtime Environment (JRE/JDK) 8+ installed on the host machine
• Access to a machine with the CData JDBC Driver for ADP installed and licensed
• Maven (for building the MCP server JAR) if you need to build from source

Step-by-step installation:

1. Build the MCP server jar (from source):

# Assuming you have the repository checked out
mvn clean install

This produces CDataMCP-jar-with-dependencies.jar in the target directory.

2. Install and license the CData JDBC Driver for ADP

• Download the driver from: https://www.cdata.com/drivers/adp/download/jdbc
• Install according to the vendor instructions
• License the driver (example for Windows/Linux/Mac):
  • Navigate to the lib folder in the installation directory
  • Run: java -jar cdata.jdbc.adp.jar --license
  • Enter your name, email, and either TRIAL or your license key

3. Create the adp.prp configuration file for your JDBC connection

• Prepare a .prp file with required properties, e.g.:

Prefix=adp
ServerName=CDataADP
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.adp.jar
DriverClass=cdata.jdbc.adp.ADPDriver
JdbcUrl=jdbc:adp:InitiateOAuth=GETANDREFRESH;
Tables=

4. Run the MCP server locally

• Start the MCP server using the Java JAR and the .prp file:

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/adp.prp

Notes:

• The server uses stdio, so it must run on the same machine as the client.
• Ensure your adp.prp is accessible to the Java process and that the JDBC driver path is correct.

Tips and common issues:

• If Claude Desktop or your MCP client does not appear, fully quit and restart the client to refresh configuration.
• Ensure the JDBC connection string (JdbcUrl in adp.prp) is valid and tested using the CData Connection String utility before starting the MCP server.
• If you need to modify connection settings, update adp.prp and restart the MCP server.
• The tools expose data in CSV for table/column listings; for actual data, use adp_run_query with a standard SQL SELECT statement.
• If OAuth is used for data sources, authentication may be required in a browser during connection string setup.
• For support, refer to CData's documentation and support resources.