The three tools are discovery, discovery and SELECT; nothing here writes back to Workday. CData points at its own paid products for full read-write and for remote hosted access, so if what you want is a question-answering connection to live Workday data running on your own machine, this is exactly that and nothing more.
A local, read-only MCP server from CData that wraps the CData JDBC Driver for Workday, which exposes Workday as relational SQL models. The assistant lists the tables, reads their columns, and runs SELECT queries against live data.
- `get_tables` — the tables available in the data source, returned as CSV with a header row
- `get_columns` — the columns of one table, so a query is written against real column names rather than guesses
- `run_query` — execute a SQL SELECT against live Workday data
- Questions answered without you writing SQL: the tools are called for you and the results come back in the conversation
- A `Tables` setting in the properties file that restricts which tables are reachable at all
Java, plus Maven to build the jar. Download and license the CData JDBC Driver for Workday — `java -jar cdata.jdbc.workday.jar --license`, with TRIAL or your key — then build a connection string with its utility; OAuth sources authenticate in the browser. Write a `.prp` file holding Prefix, ServerName, ServerVersion, DriverPath, DriverClass and JdbcUrl, and launch the jar with that file as its argument. Transport is stdio, so the client has to run on the same machine.
Build from source — clone the repository and build it, then deploy it and point your client at the endpoint