{"id":"cdatasoftware-google-analytics-mcp-server-by-cdata","name":"google-analytics-mcp-server-by-cdata","af_score":48.5,"security_score":35.0,"reliability_score":20.0,"what_it_does":"Provides a local, read-only Model Context Protocol (MCP) server that exposes Google Analytics data to LLM clients. It wraps a CData JDBC Driver for Google Analytics, generates MCP tools for listing tables/columns and executing SQL SELECT queries via tools/call, and is intended to be run locally using stdio (same machine as the MCP client).","best_when":"You want on-device (local) integration from an MCP client (e.g., Claude Desktop) to query Google Analytics via a JDBC-backed SQL interface.","avoid_when":"You need network-accessible remote MCP endpoints, fine-grained authorization management within this repo, or guaranteed operational controls like published SLAs/rate-limit contracts.","last_evaluated":"2026-04-04T19:59:13.592680+00:00","has_mcp":true,"has_api":false,"auth_methods":["Local JDBC connection using a provided .prp configuration (may require OAuth authentication in a browser depending on data source settings)"],"has_free_tier":false,"known_gotchas":["Server uses stdio, so it can only be used by clients running on the same machine.","The README claims read-only behavior, but also mentions write/update/delete capability in a general paragraph—this mismatch may confuse agents; treat available tools as limited to the listed tools (get_tables/get_columns/run_query) and underlying JDBC driver permissions.","SQL is passed through run_query; the AI may generate inefficient or invalid SQL—there is no SQL safety/validation guidance in the README."],"error_quality":0.0}