{"id":"cdatasoftware-sas-data-sets-mcp-server-by-cdata","name":"sas-data-sets-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/sas-data-sets-mcp-server-by-cdata","category":"devtools","subcategories":[],"tags":["mcp","cdata","sas","jdbc","read-only","stdio","data-access"],"what_it_does":"Provides a read-only Model Context Protocol (MCP) server that exposes SAS Data Sets via the CData JDBC Driver, letting an MCP-capable client (e.g., Claude Desktop) query live data using MCP tools (get tables, get columns, run SQL SELECT).","use_cases":["Natural-language-to-data queries over SAS Data Sets using an MCP client","Schema discovery (list tables/columns) for SAS Data Sets","Executing read-only SQL SELECT queries against SAS Data Sets and returning results to an LLM client"],"not_for":["Write/update/delete operations (server is explicitly read-only)","Remote/public deployment expecting HTTP REST endpoints (uses stdio and is local to the client machine)","Environments needing strict query safety/SQL governance beyond JDBC driver behavior"],"best_when":"You want local, read-only data exploration of SAS Data Sets from an MCP-capable desktop client on the same machine as the server process.","avoid_when":"You need an internet-reachable API endpoint, fine-grained per-query access controls, or robust, documented pagination/rate limiting semantics.","alternatives":["CData’s MCP Server for SAS Data Sets (full CRUD/simplified setup)","Using the CData JDBC Driver directly from your application (no MCP layer)","Other MCP servers or connectors that provide dedicated API endpoints with structured controls"],"af_score":45.5,"security_score":48.5,"reliability_score":25.0,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:58:24.312967+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 mechanisms via JDBC connection string (may include OAuth for some sources)","MCP server configuration via .prp properties referencing JDBC connection string"],"oauth":true,"scopes":false,"notes":"README indicates that if the underlying data source uses OAuth, authentication happens in a browser as part of configuring the JDBC connection string. It does not document fine-grained scopes at the MCP layer."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":["CData JDBC Driver licensing (and potentially CData MCP offerings depending on variant)"],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"No pricing details are provided in the README for this repository; licensing pertains to the CData JDBC Driver."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":45.5,"security_score":48.5,"reliability_score":25.0,"mcp_server_quality":78.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":65.0,"rate_limit_clarity":0.0,"tls_enforcement":60.0,"auth_strength":60.0,"scope_granularity":30.0,"dependency_hygiene":50.0,"secret_handling":40.0,"security_notes":"Uses local stdio MCP (reduces network exposure) but requires embedding JDBC connection details in a local .prp file. TLS usage for the underlying JDBC connection is not documented in the README. The MCP layer does not document per-tool authorization, fine-grained scopes, or protections against overbroad SQL reads beyond what the JDBC driver and underlying SAS permissions enforce. Dependency/Vulnerability hygiene is not verifiable from the provided content.","uptime_documented":0.0,"version_stability":50.0,"breaking_changes_history":30.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":"Operations exposed are read-only (get_tables/get_columns/run_query SELECT). Idempotency for these read actions is effectively high, but the README does not explicitly discuss retry/idempotency semantics.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["The server uses stdio, so it must run on the same machine as the MCP client.","Tool discovery/schema retrieval is via CSV outputs; agents should handle CSV parsing robustly.","Only SELECT queries are described; attempting non-SELECT or write operations may not work (read-only MCP server).","Large result sets may be problematic; the README does not describe limits, streaming, or pagination."]}}