google-analytics-mcp-server-by-cdata
If you are the rightful owner of google-analytics-mcp-server-by-cdata and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
CData's Model Context Protocol (MCP) Server for Google Analytics is a read-only server that allows LLMs to query live data from Google Analytics using the CData JDBC Driver.
The CData MCP Server for Google Analytics is designed to facilitate the interaction between large language models (LLMs) and Google Analytics data. By leveraging the CData JDBC Driver, this server exposes Google Analytics data as relational SQL models, enabling LLMs to access and query live data without the need for SQL knowledge. This server is particularly useful for applications like Claude Desktop, where users can ask natural language questions to retrieve data insights. The server is read-only, but a full-featured version with read, write, update, and delete capabilities is available in beta. The setup involves cloning the repository, building the server, and configuring the connection using a JDBC driver and a property file.
Features
- Read-only access to Google Analytics data through MCP interface.
- Integration with CData JDBC Driver for relational SQL model exposure.
- Natural language querying without SQL knowledge.
- Support for LLMs like Claude Desktop.
- Simplified setup with a property file configuration.
Tools
{servername}_get_tables
Get a list of available tables in the data source
{servername}_get_columns
Get the column list of specified tables
{servername}_run_query
Execute SQL SELECT query