workday-mcp-server-by-cdata
The CData MCP Server for Workday is a read-only server designed to allow LLMs to query live Workday data easily. It simplifies interaction with Workday data using natural language queries through the MCP interface, eliminating the need for SQL knowledge.
workday-mcp-server-by-cdata
CData's Model Context Protocol (MCP) Server for Workday.
Purpose
The project aims to create a read-only MCP Server using the CData JDBC Driver for Workday to allow LLMs to query live Workday data. The server exposes Workday data through a simple MCP interface, enabling natural language queries without the need for SQL.
Setup Guide
- Clone the repository and build the server to create the necessary JAR file.
- Install and license the CData JDBC Driver for Workday.
- Configure the connection string and create a
.prpfile for JDBC connections. - Set up the server with Claude Desktop by editing the config file.
- Run the server using the command line.
Usage Details
The server allows AI clients to interact with Workday data through integrated tools such as get_tables, get_columns, and run_query. These tools provide access to underlying data in a user-friendly manner. Simply query the client in natural language for insights on data systems.
Troubleshooting
Guidance is provided for resolving issues related to server visibility in Claude Desktop, connection configuration, and reaching out to CData Support for additional help.
License
Licensed under the MIT License, allowing free use, modification, and distribution.