Workday By Cdata MCP Server
Workday data access through a read-only relational SQL model interface for LLMs.
Data last scanned today · Reviewed today
Overview
This Java-based project enables AI models to query live Workday information by wrapping the CData JDBC Driver. By exposing Workday data as relational SQL models, it allows users to retrieve data through natural language queries rather than manual SQL generation. The server is designed as a local, read-only implementation. Users must separately download and license the CData JDBC Driver for Workday, configure a connection string via the driver's utility, and provide a local .prp properties file to initialize the connection.
Our verdict
With a security score of 39/100, this server is considered high-risk. The score reflects its status as a community-maintained project that has not undergone editorial review, lacks OAuth support verification, and has seen no commits in over 280 days. While the read-only configuration mitigates some risks, it is intended only for users who can independently manage the licensing and security of the underlying JDBC driver.
- Operates exclusively in a read-only configuration
- Utilizes zero direct code dependencies
- MIT open source license provided
- Wraps Workday data in standard relational SQL models
- High-risk score due to lack of recent updates
- Community-maintained without official vendor support
- Requires separate manual JDBC driver licensing
- Authentication method and OAuth handling remain unverified
Tools
| Tool | Description | Risk |
|---|---|---|
| workday_get_tables | Retrieves a list of tables available in the data source. | low |
| workday_get_columns | Retrieves a list of columns for a table. | low |
| workday_run_query | Execute a SQL SELECT query | low |
Compatibility
| Client | Local | Docker | Remote | Read-only |
|---|---|---|---|---|
| Claude Desktop | ||||
| Cursor | ||||
| VS Code | ||||
| Windsurf | ||||
| ChatGPT |
Frequently asked questions
›Is this Workday MCP server read-write capable?
No, this specific repository provides a local, read-only MCP server. For full read, write, update, and delete capabilities, CData offers a separate commercial MCP server product.
›What are the core prerequisites for running this server?
You must have the Java Development Kit (JDK) installed to build the project with Maven and to run the server. Additionally, you must download and license the CData JDBC Driver for Workday.
›How do I license the required CData JDBC driver?
After installing the driver, navigate to the lib folder in your installation directory and execute 'java -jar cdata.jdbc.workday.jar --license' to enter your license key or activate a trial.
›Can I use this server for remote MCP access?
No, the server uses stdio for communication and must be run on the same machine as the MCP client. For remote access, CData recommends using their CData Connect AI platform.
›How do I restrict the tables accessible to the LLM?
You can explicitly declare specific tables in the 'Tables' property of your .prp configuration file. Leaving this field blank defaults to providing access to all available data.
Badge
Maintain this server? Add the live badge to your README.