zoho/analytics-mcp-server

Zoho Analytics MCP Server

The Zoho Analytics MCP Server (Beta) implements the Model Context Protocol (MCP), a standardized interface that enables AI models to interact seamlessly with applications. This middleware solution bridges the connection between AI agents and Zoho Analytics, providing powerful data analysis capabilities through a unified interface.

Note: The Zoho Analytics MCP project is currently in its early development (Beta) phase. As we continue to improve and refine its features, the available tools and functionalities may change.

Getting Started

1. Docker Image Setup
2. Configuring Environment Variables
3. Integrating with MCP Hosts a. Claude Desktop b. VSCode c. Cursor

1. Docker Image Setup

System Requirements To build the Zoho Analytics MCP server from source, you need to have Docker installed on your system. Before setup, please make sure to have docker and a container runtime installed in your device.

Build from Source Once the docker is successfully installed to your system, you can build the Zoho Analytics MCP server from source.

# Clone the repository
git clone https://github.com/zoho/analytics-mcp-server.git
cd analytics-mcp-server/docker/

# Build the Docker image
docker build -t zohoanalytics/mcp-server:latest .

Pull Docker Image

If you prefer to use the pre-built Docker image, you can pull it directly from Docker Hub:

docker pull zohoanalytics/mcp-server:latest

2. Configuring Environment Variables

Obtaining OAuth Credentials To configure the Zoho Analytics MCP Server, you need to provide OAuth credentials (Client ID, Client Secret, and Refresh Token) as environment variables. Follow these steps to generate them:

1. Go to the Zoho Developer Console
2. Create a new Self-Client application.
3. Enable the Zoho Analytics API scope.
4. Generate your Refresh Token. For detailed instructions, refer to the official API Authentication Documentation.

Required Environment Variables

Configure these essential variables before integrating with the MCP Hosts:

Other Environment variables

The following is a list of other optional environment variables:

3. Integrate with MCP Hosts

Zoho Analytics MCP Server can be integrated with any MCP host. Below are some sample integrations that demonstrate how this can be done.

Claude Desktop Configuration

To configure the Zoho Analytics MCP server with Claude Desktop, add the following configuration to your Claude settings:

1. Install Claude Desktop in your system.
2. Open the Claude Desktop application and navigate to Settings > Developer tab.
3. Click Edit Config to configure (claude_desktop_config.json) with your MCP server details.

{
  "mcpServers": {
    "ZohoAnalyticsMCP": {
      "command": "docker",
      "args": [
        "run",
        "-e", "ANALYTICS_CLIENT_ID=<YOUR_ANALYTICS_CLIENT_ID>",
        "-e", "ANALYTICS_CLIENT_SECRET=<YOUR_ANALYTICS_CLIENT_SECRET>",
        "-e", "ANALYTICS_REFRESH_TOKEN=<YOUR_ANALYTICS_REFRESH_TOKEN>",
        "-e", "ANALYTICS_ORG_ID=<YOUR_ANALYTICS_ORG_ID>",
        "-e", "ANALYTICS_MCP_DATA_DIR=<YOUR_ANALYTICS_MCP_DATA_DIR>",
        "--network=host",
        "-i",
        "--rm",
        "-v", "<YOUR_ANALYTICS_MCP_DATA_DIR>:<YOUR_ANALYTICS_MCP_DATA_DIR>",
        "zohoanalytics/mcp-server"
      ]
    }
  }
}

VSCode Configuration

To configure the Zoho Analytics MCP server with Visual Studio Code:

1. Install the VSCode in your system.
2. Open the VSCode application and navigate to Settings.
3. In the Settings page, search for MCP configurations. Select the Edit in settings.json option to configure the MCP server.

"mcp": {
  "servers": {
    "zoho_analytics_mcp_server": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-e", "ANALYTICS_CLIENT_ID=<YOUR_ANALYTICS_CLIENT_ID>",
        "-e", "ANALYTICS_CLIENT_SECRET=<YOUR_ANALYTICS_CLIENT_SECRET>",
        "-e", "ANALYTICS_REFRESH_TOKEN=<YOUR_ANALYTICS_REFRESH_TOKEN>",
        "-e", "ANALYTICS_ORG_ID=<YOUR_ANALYTICS_ORG_ID>",
        "-e", "ANALYTICS_MCP_DATA_DIR=<YOUR_LOCAL_DATA_DIR>",
        "--network=host",
        "-i",
        "--rm",
        "-v", "<YOUR_LOCAL_DATA_DIR>:<YOUR_LOCAL_DATA_DIR>",
        "zohoanalytics/mcp-server"
      ]
    }
  }
}

Cursor Configuration

To configure the Zoho Analytics MCP server with Cursor:

1. Install the Cursor in your system.
2. Open the Cursor application and navigate to Settings > Tools and Integrations.
3. Click the Add Custom MCP menu to enter your server configuration details, and Save.

{
  "mcpServers": {
    "ZohoAnalyticsMCP": {
      "command": "docker",
      "args": [
        "run",
        "-e", "ANALYTICS_CLIENT_ID=<YOUR_ANALYTICS_CLIENT_ID>",
        "-e", "ANALYTICS_CLIENT_SECRET=<YOUR_ANALYTICS_CLIENT_SECRET>",
        "-e", "ANALYTICS_REFRESH_TOKEN=<YOUR_ANALYTICS_REFRESH_TOKEN>",
        "-e", "ANALYTICS_ORG_ID=<YOUR_ANALYTICS_ORG_ID>",
        "-e", "ANALYTICS_MCP_DATA_DIR=<YOUR_ANALYTICS_MCP_DATA_DIR>",
        "--network=host",
        "-i",
        "--rm",
        "-v", "<YOUR_ANALYTICS_MCP_DATA_DIR>:<YOUR_ANALYTICS_MCP_DATA_DIR>",
        "zohoanalytics/mcp-server"
      ]
    }
  }
}

Tools List

The Zoho Analytics MCP server provides various tools for interacting with Zoho Analytics.

Troubleshooting

For common issues:

1. Authentication Problems:
   • Verify all OAuth credentials
   • Ensure tokens have proper permissions
   • Check token expiration status
2. Connection Issues:
   • Confirm if the Docker container is running
   • Validate network connectivity
   • Check firewall settings
3. Data Center Errors:
   • Verify ANALYTICS_SERVER_URL and ACCOUNTS_SERVER_URL matches your organization's region
   • Ensure the location code is correct (case-sensitive)
4. File System Problems:
   • Confirm if the data directory exists
   • Check directory permissions
   • Verify sufficient disk space