{"id":"cdatasoftware-workday-mcp-server-by-cdata","name":"workday-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/workday-mcp-server-by-cdata","category":"infrastructure","subcategories":[],"tags":["mcp","workday","cdata","jdbc","stdio","read-only","data-integration","desktop-automation"],"what_it_does":"Provides a local, read-only MCP server that exposes Workday data via the CData JDBC Driver, wrapping the JDBC driver’s relational/SQL model behind simple MCP tools (get tables/columns and run a SELECT query) over stdio for use with local MCP clients (e.g., Claude Desktop).","use_cases":["Query Workday reference/operational data using natural-language questions without writing SQL","Interactive exploration of available Workday “tables” and their columns via MCP tools","Lightweight analytics by running read-only SQL SELECT queries against the mapped JDBC schema"],"not_for":["Arbitrary raw database access beyond the provided MCP tools","Write/update/delete operations (server is described as read-only)","Use cases requiring remote network access or multi-tenant hosted deployment (server is local via stdio)"],"best_when":"You want to locally connect an MCP-capable desktop client to Workday through CData’s JDBC driver, focusing on read/query workflows.","avoid_when":"You need remote/server-to-server access over HTTP, need guaranteed structured pagination, or require strong built-in access controls at the MCP layer.","alternatives":["Use CData’s managed MCP offering (CData Connect AI) for remote/full capabilities as suggested by the README","Access Workday directly via an approved integration/API and build your own data layer","Use the CData JDBC driver directly from your own application instead of MCP"],"af_score":41.5,"security_score":32.8,"reliability_score":28.8,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:33:10.764921+00:00","interface":{"has_rest_api":false,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":null,"has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["Workday authentication handled by the underlying CData JDBC driver; README mentions OAuth browser authentication when required by the data source"],"oauth":true,"scopes":false,"notes":"The MCP server itself is launched locally with a .prp file and relies on the JDBC driver’s connection string/auth flow (including OAuth-like browser auth when applicable). No MCP-level scope model is described in the README."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"README references CData JDBC driver licensing but does not provide MCP server pricing details."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":41.5,"security_score":32.8,"reliability_score":28.8,"mcp_server_quality":60.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":45.0,"rate_limit_clarity":5.0,"tls_enforcement":50.0,"auth_strength":35.0,"scope_granularity":10.0,"dependency_hygiene":40.0,"secret_handling":30.0,"security_notes":"Uses local stdio transport (no explicit TLS story since it is not a network service). Authentication is handled by the JDBC driver; README does not describe least-privilege scopes for MCP tools or how credentials are protected in configuration. The presence of a JDBC driver and local connection string increases the need for secure handling of the .prp/JdbcUrl contents (avoid logging). No explicit security model, audit, or row/column-level access controls are described at the MCP layer.","uptime_documented":0.0,"version_stability":40.0,"breaking_changes_history":50.0,"error_recovery":25.0,"idempotency_support":"true","idempotency_notes":"Read-only tools are naturally idempotent (get_tables/get_columns/run_query with SELECT). No explicit guidance is provided for retries or for distinguishing safe vs unsafe operations beyond the stated read-only scope.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server uses stdio and is intended for clients running on the same machine; remote clients won’t work without an adapter","The README indicates the tool outputs for get_columns/get_tables are CSV; agents should be prepared to parse CSV-formatted responses","Authentication and connection-string setup are delegated to the CData JDBC driver; failures will likely surface as connection/test issues rather than MCP-specific guidance","Tool run_query expects SQL SELECT; crafting queries incorrectly may cause driver-level errors that are not documented in MCP terms"]}}