{"id":"cdatasoftware-google-analytics-mcp-server-by-cdata","name":"google-analytics-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/google-analytics-mcp-server-by-cdata","category":"ai-ml","subcategories":[],"tags":["mcp","google-analytics","cdata","jdbc","llm","data-access","stdio","local-integration","read-only"],"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).","use_cases":["Querying live Google Analytics data from an MCP-capable desktop client without writing SQL","Exploratory analytics and ad-hoc reporting (e.g., totals, breakdowns, correlations) via natural-language tool use","Building lightweight internal dashboards/assistants that answer questions over GA data"],"not_for":["Production multi-tenant or remote MCP access scenarios (stdio is local-only per README)","Write/update/delete GA data (README describes the MCP server as read-only)","Use cases requiring a hosted API gateway, rate-limit headers, or managed OAuth flows inside this repo"],"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.","alternatives":["Use a managed MCP/data integration product (e.g., the referenced CData Connect AI)","Use CData’s managed/full MCP offering for Google Analytics (if read-write is needed)","Directly query Google Analytics (or BigQuery export) via official APIs or BI tooling instead of MCP"],"af_score":48.5,"security_score":35.0,"reliability_score":20.0,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:59:13.592680+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":["Local JDBC connection using a provided .prp configuration (may require OAuth authentication in a browser depending on data source settings)"],"oauth":true,"scopes":false,"notes":"Auth details for OAuth scopes are not documented in this README; it references that OAuth may require browser authentication for the JDBC driver/connection string."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":["CData JDBC Driver for Google Analytics (and its license) likely required","Potentially the MCP server bundle itself is local/packaged, but JDBC licensing is explicitly mentioned"],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"README explicitly requires licensing the CData JDBC Driver; pricing terms are not provided here."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":48.5,"security_score":35.0,"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":20.0,"auth_strength":55.0,"scope_granularity":30.0,"dependency_hygiene":35.0,"secret_handling":30.0,"security_notes":"Local stdio reduces network exposure, but secrets/connection strings are placed in a local .prp file; the README does not discuss secure storage, redaction, or log handling. OAuth may be required via browser for the JDBC driver, but scope/granularity and token lifecycle handling are not documented in this repo. No explicit TLS/network security controls apply beyond 'local' operation; if any remote components are used, they are not described here. Dependency/CVE hygiene is not assessable from the provided content.","uptime_documented":0.0,"version_stability":30.0,"breaking_changes_history":30.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_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."]}}