analytics

The Zoho Analytics MCP Server acts as a bridge between AI agents and Zoho Analytics by implementing the Model Context Protocol (MCP). It exposes tooling that lets agents query and analyze data from Zoho Analytics, such as listing workspaces, retrieving views, and executing data queries. Common capabilities include getting workspaces, getting views within a workspace, and performing query_data style operations to extract insights from stored analytics data. Deployers can run the server via Docker and configure OAuth credentials and endpoints as environment variables to enable secure access to Zoho Analytics APIs. Once running, MCP hosts or clients can connect to the server using the MCP protocol and start issuing data-aware prompts to retrieve structured analytics results and run analyses through the provided tools.

Prerequisites:

• Docker installed on the host system
• Zoho Analytics OAuth credentials (Client ID, Client Secret, Refresh Token) and Org ID

Install and run the server using Docker:

1. Pull the pre-built Docker image (latest tag):

docker pull zohoanalytics/mcp-server:latest

2. Create a .env file (or export environment variables) with required credentials:

# Example values; replace with your own
ANALYTICS_CLIENT_ID="<your-client-id>"
ANALYTICS_CLIENT_SECRET="<your-client-secret>"
ANALYTICS_REFRESH_TOKEN="<your-refresh-token>"
ANALYTICS_ORG_ID="<your-org-id>"
ANALYTICS_MCP_DATA_DIR="/path/to/data"
ACCOUNTS_SERVER_URL="https://accounts.zoho.com"
ANALYTICS_SERVER_URL="https://analyticsapi.zoho.com"

3. Run the MCP server container with the environment variables:

docker run -d --name zohoanalytics-mcp \
  -e ANALYTICS_CLIENT_ID="<your-client-id>" \
  -e ANALYTICS_CLIENT_SECRET="<your-client-secret>" \
  -e ANALYTICS_REFRESH_TOKEN="<your-refresh-token>" \
  -e ANALYTICS_ORG_ID="<your-org-id>" \
  -e ANALYTICS_MCP_DATA_DIR="/path/to/data" \
  -e ACCOUNTS_SERVER_URL="https://accounts.zoho.com" \
  -e ANALYTICS_SERVER_URL="https://analyticsapi.zoho.com" \
  zohoanalytics/mcp-server:latest

4. Verify the container is running:

docker ps | grep zohoanalytics-mcp

5. Point your MCP host or client to the running server using the MCP protocol. The host can optionally override ports or network settings as needed.

Tips and caveats:

• Ensure your Zoho OAuth credentials have the necessary scopes (Zoho Analytics API) and that the refresh token remains valid.
• The ANALYTICS_MCP_DATA_DIR path should be accessible to the container for temporary data storage.
• If you encounter API rate limits or token lifecycle issues, review the token management flow and consider implementing token refresh handling in your hosting environment.
• The server exposes endpoints that support tools like get_workspaces, get_views, and query execution. Review your MCP host documentation for how these tools map to MCP actions.
• For remote hosting, consider setting STORAGE_BACKEND and related Redis variables if you need distributed storage across multiple instances.