{"id":"cdatasoftware-power-bi-xmla-mcp-server-by-cdata","name":"power-bi-xmla-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/power-bi-xmla-mcp-server-by-cdata","category":"ai-ml","subcategories":[],"tags":["mcp","power-bi","xmla","jdbc","data-access","agent-tooling","read-only"],"what_it_does":"Provides a local, read-only MCP server that wraps the CData JDBC Driver for Power BI XMLA, exposing Power BI XMLA data as MCP tools (get tables/columns and run_query) for LLM clients such as Claude Desktop.","use_cases":["Ask natural-language questions about live Power BI XMLA datasets","List available XMLA tables and columns for discovery","Run SQL SELECT queries against Power BI XMLA via MCP tools in an agent workflow"],"not_for":["Internet-hosted/shared multi-tenant use (relies on local stdio)","Security-sensitive scenarios without careful credential handling and host isolation","High-throughput/large-result workloads without considering query cost and client-side handling","Full CRUD workflows (server is stated as read-only; uses JDBC driver for data access but this MCP wrapper is read-only)"],"best_when":"You have a local machine where an MCP-capable client can run the server via stdio, and you want agent-friendly access to Power BI XMLA using natural language over a JDBC-backed SQL surface.","avoid_when":"You need a network-exposed API, fine-grained authorization per user, or robust operational controls (pagination, retries, rate-limit handling) documented for automated agents.","alternatives":["CData’s managed MCP platform (CData Connect AI)","CData full MCP server for Power BI XMLA (as referenced in README)","Direct JDBC/ODBC access with an application-side translation layer","Power BI/semantic layer APIs (where applicable)"],"af_score":48.8,"security_score":43.5,"reliability_score":23.8,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:49:14.092070+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":["MCP server runs locally; authentication is delegated to the CData JDBC Driver connection string (may use OAuth in the driver)."],"oauth":true,"scopes":false,"notes":"The MCP wrapper itself does not specify an auth scheme; it relies on the CData JDBC Driver connection string/connection properties in the provided .prp file. README notes OAuth may require browser authentication in the connection string builder."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":["CData JDBC Driver for Power BI XMLA (licensed separately)","(Optionally) CData Connect AI / managed MCP offerings referenced in README"],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"Repository is MIT, but the JDBC driver licensing is required to connect to data."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":48.8,"security_score":43.5,"reliability_score":23.8,"mcp_server_quality":72.0,"documentation_accuracy":62.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":10.0,"tls_enforcement":60.0,"auth_strength":55.0,"scope_granularity":20.0,"dependency_hygiene":45.0,"secret_handling":35.0,"security_notes":"Transport security (TLS) is not described for the MCP layer; since it runs locally over stdio, the risk shifts to local host security. Authentication is delegated to the CData JDBC Driver (potentially OAuth), but there is no MCP-level authorization/scoping described. Secrets/connection strings are placed in a local .prp file; README does not state how secrets are protected from logs or process inspection.","uptime_documented":0.0,"version_stability":45.0,"breaking_changes_history":30.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":"No explicit idempotency guarantees are documented. Tools include read-oriented operations (get_tables/get_columns/run_query with SELECT), which are typically safe, but the wrapper’s behavior for non-SELECT or side effects is not clearly documented (and CRUD is described as not the focus).","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server uses stdio; must run on the same machine as the MCP client.","Only read-only capabilities are advertised; agent attempts at write/update/delete may fail or be unsupported.","The SQL tool accepts an arbitrary SQL string; agents must constrain to safe/SELECT queries to avoid unexpected behavior and high load.","Output is described as CSV for get_tables/get_columns; agents should parse CSV reliably and handle large outputs."]}}