{"id":"cdatasoftware-adp-mcp-server-by-cdata","name":"adp-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/adp-mcp-server-by-cdata","category":"api-gateway","subcategories":[],"tags":["mcp","jdbc","adp","data-access","claude-desktop","stdio"],"what_it_does":"Provides a local, read-only MCP server that exposes ADP data through a simple MCP tool interface backed by CData JDBC Drivers. Intended for use with AI clients (e.g., Claude Desktop) to query live ADP information via natural-language requests or JSON-RPC tool calls.","use_cases":["Ask questions about ADP live data (e.g., open tickets, opportunities, calendar events) without writing SQL","Discover available ADP tables and columns via MCP tools","Run read-only SQL SELECT queries over ADP through an MCP tool for reporting/analysis"],"not_for":["Direct internet-access remote MCP hosting (server is designed for local stdio use)","High-trust automated data modification workflows (server is stated as read-only)","Public multi-tenant deployment without additional hardening (no server-side auth model described)"],"best_when":"Used locally on the same machine as the MCP-capable client (e.g., Claude Desktop) to safely query ADP data for analysts and assistants.","avoid_when":"Avoid if you need remote/Multi-host access, fine-grained authorization, or robust operational controls like documented rate limiting, pagination, or retry semantics.","alternatives":["CData managed MCP platform (CData Connect AI) mentioned in the README for remote access and fuller capabilities","CData MCP Server for ADP with full CRUD capabilities (as referenced in README)","Direct use of CData JDBC driver from your own application (build your own query/authorization layer)"],"af_score":46.8,"security_score":36.8,"reliability_score":27.5,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:49:49.110754+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":["CData JDBC Driver authentication (may be OAuth via the underlying connection string, per README note)"],"oauth":true,"scopes":false,"notes":"No auth mechanism for the MCP server itself is described. Authentication is delegated to the underlying CData JDBC driver configuration referenced by the .prp file (including potential OAuth flows)."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"Pricing for the open-source MCP wrapper is not described. The README indicates you must download and license the CData JDBC Driver for ADP."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":46.8,"security_score":36.8,"reliability_score":27.5,"mcp_server_quality":65.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":45.0,"rate_limit_clarity":0.0,"tls_enforcement":50.0,"auth_strength":35.0,"scope_granularity":20.0,"dependency_hygiene":40.0,"secret_handling":40.0,"security_notes":"Transport security is not explicitly discussed because the MCP server is local and uses stdio. Authentication/authz for data access appears to be handled by the underlying CData JDBC driver connection (possibly OAuth), but the MCP server itself has no described access control, scopes, or tenancy isolation. The tool run_query enables SQL SELECT access; there is no documented query sandboxing, result-size limiting, or explicit prevention of sensitive data exfiltration beyond the read-only intent. Dependency/security hygiene cannot be verified from the provided README alone.","uptime_documented":0.0,"version_stability":40.0,"breaking_changes_history":50.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":"The tools include read-only operations (get_tables/get_columns/run_query SELECT), so idempotency is likely inherent for reads, but the README does not explicitly discuss idempotency semantics.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server uses stdio, so it can only be used with clients running on the same machine","Claude Desktop may require fully quitting and reopening for the MCP server to appear","The run_query tool accepts SQL; agents may generate overly broad queries—no query limits or guardrails are described","The repository is read-only by design, but the run_query tool still exposes SQL execution; ensure agents do not attempt non-SELECT statements"]}}