{"id":"cdatasoftware-ssas-mcp-server-by-cdata","name":"ssas-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/ssas-mcp-server-by-cdata","category":"infrastructure","subcategories":[],"tags":["mcp","sql-server-analysis-services","ssas","jdbc","cdata","read-only","data-access","claude-desktop"],"what_it_does":"Provides a read-only Model Context Protocol (MCP) server that exposes SQL Server Analysis Services data to MCP clients by wrapping the CData JDBC Driver for SQL Server Analysis Services. It supports listing tables/columns and executing SQL SELECT queries over the underlying SSAS data via MCP tools.","use_cases":["Answer natural-language questions over live SSAS data (e.g., sales, KPIs, calendar events) without writing SQL","Discovery workflows: list available SSAS tables and columns for a chosen dataset","Ad-hoc read-only analytics by running SELECT queries through an MCP client (e.g., Claude Desktop)"],"not_for":["Writing/updating/deleting data in SSAS (explicitly read-only MCP server)","Production deployments requiring networked/remote access (server uses stdio, local-process model)","Use cases needing REST/GraphQL-style HTTP APIs or hosted endpoints"],"best_when":"You want local, read-only SSAS data access from an MCP-capable desktop client, using CData’s JDBC driver and configuration files to establish the SSAS connection.","avoid_when":"You need a remotely accessible service over HTTP with documented rate limits, retries, and pagination, or you require write access / transactional operations.","alternatives":["CData’s MCP Server for SQL Server Analysis Services with full CRUD (per README note)","Direct use of the CData JDBC Driver without MCP (build your own queries/connector)","If available for your environment, an HTTP-based SQL gateway or BI connector that supports query execution over HTTPS"],"af_score":49.5,"security_score":52.8,"reliability_score":20.0,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T20:00:11.011786+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 connection string authentication (includes support for OAuth per README note), configured via .prp and JDBC Url"],"oauth":true,"scopes":false,"notes":"Authentication is delegated to the CData JDBC driver via the connection string used in the .prp file. The README mentions OAuth flows may require browser authentication, but does not describe scopes or fine-grained authorization within the MCP server itself."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":["CData JDBC Driver licensing required (per README)"],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"No MCP server pricing details are provided; JDBC driver licensing is required."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":49.5,"security_score":52.8,"reliability_score":20.0,"mcp_server_quality":72.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":0.0,"tls_enforcement":70.0,"auth_strength":65.0,"scope_granularity":40.0,"dependency_hygiene":50.0,"secret_handling":35.0,"security_notes":"Transport security is not explicitly described for the MCP stdio channel or for the JDBC connection in the README. Authentication is handled by the CData JDBC driver; OAuth is mentioned but MCP-side scope granularity is not documented. Connection configuration is placed in a local .prp file, and the README includes example JDBC URL content; it does not describe secret redaction, logging behavior, or safe handling of credentials. Because the MCP server can run user-supplied SELECT SQL, prompt-to-SQL misuse risk exists (e.g., requesting broader-than-expected data) unless the JDBC driver enforces least-privilege at the data source.","uptime_documented":0.0,"version_stability":30.0,"breaking_changes_history":30.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":"Read operations (get_tables/get_columns) are naturally safe; run_query is a SELECT-only tool per intended use, but there is no explicit statement about idempotency/retries for query execution.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server uses stdio, so it must run on the same machine as the MCP client (e.g., Claude Desktop).","The tool list depends on the configured connection/table visibility in the generated .prp (Tables property).","If the MCP server does not appear in the client, the README suggests fully quitting and reopening the desktop client.","Large SELECT queries may be expensive/slow, but there is no documented guardrail (limits/timeouts) in the README provided."]}}