{"id":"cdatasoftware-ssas-mcp-server-by-cdata","name":"ssas-mcp-server-by-cdata","af_score":49.5,"security_score":52.8,"reliability_score":20.0,"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.","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.","last_evaluated":"2026-04-04T20:00:11.011786+00:00","has_mcp":true,"has_api":false,"auth_methods":["CData JDBC driver connection string authentication (includes support for OAuth per README note), configured via .prp and JDBC Url"],"has_free_tier":false,"known_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."],"error_quality":0.0}