adp-mcp-server-by-cdata

What is adp-mcp-server-by-cdata?

adp-mcp-server-by-cdata is a read-only Model Context Protocol (MCP) server that allows large language models (like Claude Desktop) to query live ADP data by asking natural language questions. It wraps the CData JDBC Driver for ADP, which exposes ADP data as relational SQL models, and makes that data available through a simple MCP interface without requiring SQL.

How to use adp-mcp-server-by-cdata?

Clone the repository and build the JAR with mvn clean install. Download and license the CData JDBC Driver for ADP, then configure a .prp file with your JDBC connection string. Add the server to your Claude Desktop configuration (claude_desktop_config.json) and restart Claude Desktop. The server provides tools like {servername}_get_tables, {servername}_get_columns, and {servername}_run_query that the AI client can call automatically when you ask questions about your ADP data.

Key features of adp-mcp-server-by-cdata

• Read-only MCP server for ADP data
• Natural language querying of live ADP data
• Built on the CData JDBC Driver for ADP
• Provides three tools: get_tables, get_columns, run_query
• Uses stdio transport (client must run on same machine)
• MIT‑licensed

Use cases of adp-mcp-server-by-cdata

• Query ADP employee, payroll, or HR data using conversational language
• Generate reports or summaries from ADP data without writing SQL
• Integrate ADP data into AI‑powered assistants like Claude Desktop

FAQ from adp-mcp-server-by-cdata

Is this server read-only?

Yes. The README explicitly states this project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, CData offers a separate MCP Server for ADP (beta) available on their website.

What are the dependencies?

Java (to run the JAR) and the CData JDBC Driver for ADP, which must be downloaded and licensed separately.

Where does the ADP data live?

The server connects to ADP data through the CData JDBC Driver; the data is not stored locally and is queried live from ADP.

What transport does the server use?

The server uses stdio transport, so it can only be used with clients that run on the same machine as the server.

Does the server require authentication?

Yes. The JDBC connection string typically uses OAuth (e.g., InitiateOAuth=GETANDREFRESH) and you may need to authenticate in your browser during connection setup.