Zoho Analytics
The Zoho Analytics connector lets AI agents query workspaces, export data, run SQL queries against reports, and share views. It uses OAuth 2.0 so your credentials are stored encrypted in MCPGate's vault and are never exposed to the AI client.
Required scopes#
MCPGate requests the following OAuth scopes when you connect a Zoho Analytics account.
| Scope | Purpose |
|---|---|
| ZohoAnalytics.data.READ | Read data from tables and reports |
| ZohoAnalytics.usermanagement.READ | List users and their workspace access |
| ZohoAnalytics.metadata.READ | Read column and schema metadata |
Tool reference#
The Zoho Analytics connector exposes 10 tools. Use the MCP Apps page to enable or disable individual tools per app, and the Guardrails page to add fine-grained rules on top.
| Tool | Category | Description |
|---|---|---|
| zohoanalytics_list_workspaces | read | List all workspaces in Zoho Analytics |
| zohoanalytics_list_views | read | List all views (tables/reports/dashboards) in a workspace |
| zohoanalytics_get_view | read | Get details of a specific view by ID |
| zohoanalytics_export_data | read | Export data from a Zoho Analytics view as CSV or JSON |
| zohoanalytics_run_query | read | Run a SQL query against a Zoho Analytics workspace |
| zohoanalytics_get_metadata | read | Get column/schema metadata for a Zoho Analytics view |
| zohoanalytics_list_users | read | List users with access to a Zoho Analytics workspace |
| zohoanalytics_get_view_url | read | Get a shareable URL for a Zoho Analytics view |
| zohoanalytics_list_dashboards | read | List dashboards in a Zoho Analytics workspace |
| zohoanalytics_share_view | write | Share a Zoho Analytics view with users |
SQL queries are read-only
zohoanalytics_run_query executes SELECT queries only. DML statements (INSERT, UPDATE, DELETE) are not permitted. This connector is safe to use with the read_only or query preset without risk of modifying underlying data.Common guardrail recipes#
Read-only access#
Apply the read_only preset to enable the nine read tools and deny zohoanalytics_share_view. Suitable for business intelligence agents that query data and generate reports without sharing views externally.
Query preset#
Use the query preset to enable all 10 tools, allowing agents to both query data and share views with specified users. Apply a allow_values guardrail to zohoanalytics_share_view targeting the email field to control who the agent may grant access to.
Full access#
The full_access preset is equivalent to query for this connector. Restrict workspace IDs via guardrails if agents should only access specific analytics workspaces.
Troubleshooting#
- Workspace organisation ID— Zoho Analytics API calls require both an organisation ID and a workspace ID. MCPGate fetches these during the OAuth flow. If tools return "workspace not found" errors, reconnect the connector to refresh the cached organisation details.
- SQL syntax differences — Zoho Analytics uses a subset of ANSI SQL with some proprietary extensions. Complex joins or window functions may not be supported. Use
zohoanalytics_get_metadatato check column names and types before constructing queries. - Export size limits —
zohoanalytics_export_datais subject to Zoho Analytics row export limits based on your plan tier. For very large datasets, usezohoanalytics_run_querywith pagination parameters instead.