google-analytics-mcp-server-by-cdata

What is google-analytics-mcp-server-by-cdata?

This read-only MCP server allows LLMs like Claude Desktop to query live Google Analytics data using the CData JDBC Driver for Google Analytics, which exposes Google Analytics as relational SQL models.

How to use google-analytics-mcp-server-by-cdata?

Clone the repository, build with Maven, download and license the CData JDBC Driver for Google Analytics, create a .prp file with connection details, then configure the server in Claude Desktop’s claude_desktop_config.json. The server uses stdio transport and runs on the same machine as the client.

Key features of google-analytics-mcp-server-by-cdata

• Read-only access to Google Analytics data via MCP
• Exposes tables, columns, and SQL query capabilities
• Supports natural language questions from AI clients
• Powered by CData JDBC Driver for Google Analytics
• Uses stdio transport for local client integration

Use cases of google-analytics-mcp-server-by-cdata

• Querying Google Analytics metrics and dimensions with natural language
• Correlating closed won opportunities with account industry (example)
• Retrieving calendar events for the current day (example)
• Asking ad-hoc questions about analytics data without SQL

FAQ from google-analytics-mcp-server-by-cdata

What is the difference between this server and the CData MCP Server for Google Analytics (beta)?

This server is read-only; the beta version supports full read, write, update, delete, and action capabilities and offers a simplified setup.

What are the runtime requirements?

You need Java (to run the JAR), Maven (to build), and the CData JDBC Driver for Google Analytics must be installed and licensed.

Where does the data live?

Data stays in Google Analytics; the server queries it live via the JDBC Driver and returns results to the client.

What transport and authentication does the server use?

It uses stdio transport (local only). Authentication is handled through the JDBC Driver’s OAuth flow when configuring the connection string.

How do I list available tables and columns?

Use the tools {servername}_get_tables and {servername}_get_columns, which are automatically exposed once the server is configured.