The NPM setup method lets you run the Zoho Analytics MCP Server as a lightweight Node.js package directly on your machine using npx. There is no Docker installation required and no separate build step. Your credentials are passed as environment variables within your MCP client's configuration file, keeping the setup straightforward and easy to update.

Prerequisites

• npm must be installed on your system (Node.js includes npm by default)
• OAuth credentials from your Zoho Analytics account (Client ID, Client Secret, and Refresh Token)

Obtaining OAuth Credentials

1. Open the Zoho Developer Console. Navigate to the console and begin creating a new application.
2. Create a Self-Client application. This type is appropriate for local installations where each user holds their own credentials.
3. Enable the Zoho Analytics API scope. Choose the scope that grants the server access to your Analytics data.
4. Generate a Refresh Token. Save your Client ID, Client Secret, and Refresh Token ready for the configuration step.

Environment Variables

Required Variables

Optional Variables

These variables have working defaults but may be adjusted: QUERY_DATA_RESULT_ROW_LIMITS (default: 20 rows), QUERY_DATA_POLLING_INTERVAL (default: 4 seconds), QUERY_DATA_QUEUE_TIMEOUT (default: 120 seconds), QUERY_DATA_QUERY_EXECUTION_TIMEOUT (default: 30 seconds), WORKSPACE_RESULT_LIMIT (default: 20), and VIEW_RESULT_LIMIT (default: 20).

Client Configuration

Claude Desktop

Open Claude Desktop, go to Settings > Developer, and click Edit Config to open claude_desktop_config.json. Add the following, replacing the placeholder values with your actual credentials:

{
  "mcpServers": {
    "zoho-analytics-mcp": {
      "command": "npx",
      "args": ["zoho-analytics-mcp-server@latest"],
      "env": {
        "ANALYTICS_CLIENT_ID": "your-client-id-here",
        "ANALYTICS_CLIENT_SECRET": "your-client-secret-here",
        "ANALYTICS_REFRESH_TOKEN": "your-refresh-token-here",
        "ANALYTICS_ORG_ID": "your-org-id-here",
        "ACCOUNTS_SERVER_URL": "",
        "ANALYTICS_SERVER_URL": ""
      }
    }
  }
}

VS Code

In VS Code, open Settings and search for MCP configurations, then select Edit in settings.json. Add the following entry:

{
  "servers": {
    "zoho_analytics": {
      "type": "stdio",
      "command": "npx",
      "args": ["zoho-analytics-mcp-server@latest"],
      "env": {
        "ANALYTICS_CLIENT_ID": "your-client-id-here",
        "ANALYTICS_CLIENT_SECRET": "your-client-secret-here",
        "ANALYTICS_REFRESH_TOKEN": "your-refresh-token-here",
        "ANALYTICS_ORG_ID": "your-org-id-here",
        "ACCOUNTS_SERVER_URL": "",
        "ANALYTICS_SERVER_URL": ""
      }
    }
  }
}

Available MCP Tools

The NPM-installed server exposes more than 20 tools to your AI client, covering workspace and table management (create_workspace, create_table, get_workspaces_list), view operations (search_views, get_view_details, delete_view), data import and export (import_data, export_view), SQL querying (query_data with an asynchronous 2-minute default timeout), row operations (add_row, update_rows, delete_rows), reporting (create_chart_report, create_pivot_report, create_summary_report, create_aggregate_formula, create_query_table), and utility tools (analyse_file_structure, download_file).

Troubleshooting

• Authentication problems: Verify all OAuth credentials, confirm the token has the required permissions, and check whether the refresh token has expired.
• Connection issues: Validate your network connectivity and review firewall settings to ensure outbound connections are permitted.
• Data centre errors: Confirm that ACCOUNTS_SERVER_URL and ANALYTICS_SERVER_URL match the data centre region for your Zoho account.
• File system issues: Check that the directory specified in ANALYTICS_MCP_DATA_DIR exists, has the correct permissions, and has sufficient disk space available.

Support

Zoho Analytics provides 24x5 technical support Monday to Friday. Contact the team by email at support@zohoanalytics.com or by telephone: US +1 (888) 900 9646, UK +44 (20) 35647890, Australia +61-2-80662898, India +91 44 6965 6060.