Tools in Zoho Analytics MCP Server
The Zoho Analytics MCP Server exposes different sets of tools depending on the deployment offering used. This page lists all available tools across all offerings, organized by category.
Offerings and Tool Sets
The three offerings differ in tool granularity and supported capabilities:
| Offering | Tool Approach | Key Differences |
| Local MCP (Docker / Node.js) | High-level tools that handle multi-step API operations internally | Supports file import/export and local file utilities; polling and job handling are managed automatically |
| Self-Hosted Remote MCP | Same tools as Local MCP | File import/export and local file utilities are not supported |
| Zoho MCP (mcp.zoho.com) | Granular tools that map one-to-one with individual Zoho Analytics API calls | Includes folder management; each step in a multi-step operation is a separate tool call |
Note: Some capabilities exist across all offerings but are implemented differently. For example, query_data in Local MCP and Self-Hosted Remote MCP wraps three separate API calls (submit → poll → download) into a single tool. In Zoho MCP, each of those three steps is its own tool.
Workspace & View Management
| Local / Self-Hosted Remote MCP | Zoho MCP | Description | API |
| create_workspace | createWorkspace | Creates a new workspace in Zoho Analytics. | Modeling API |
| get_workspaces_list | getAllWorkspaces / getOwnedWorkspaces | Returns workspaces accessible to the user. getOwnedWorkspaces (Zoho MCP) filters to workspaces the user owns; getAllWorkspaces returns all accessible workspaces. | Metadata API |
| — | getOrganizations | Lists the organizations accessible to the authenticated user. Useful as a first step to obtain a valid org-id. | Metadata API |
| create_table | createTable | Creates a new table in a workspace with defined columns. | Modeling API |
| search_views | getViews | Lists views (tables, reports, dashboards) within a workspace, with optional keyword filtering, type filtering, and pagination. | Metadata API |
| get_view_details | getViewDetails | Returns detailed metadata for a specific view, including structure and properties. | Metadata API |
| delete_view | deleteView | Deletes a view (table, report, or dashboard) from a workspace. | Modeling API |
Folder Management
Folder operations are available in Zoho MCP only.
| Zoho MCP | Description | API |
| getFolders | Lists all folders in a workspace with their IDs and metadata. | Metadata API |
| createFolder | Creates a folder to organize views within a workspace. Supports up to 2 levels of nesting. | Modeling API |
| deleteFolder | Permanently deletes a folder from a workspace. Views can optionally be deleted along with it. | Modeling API |
| renameFolder | Renames an existing folder and optionally updates its description. | Modeling API |
| moveViewsToFolder | Moves one or more views into a specified folder within a workspace. | Modeling API |
Data Operations
| Local / Self-Hosted Remote MCP | Zoho MCP | Description | API |
| add_row | addRow | Adds a single row to a specified table. | Data API |
| update_rows | updateRows | Updates rows in a table based on filter criteria. Supports upsert behavior. | Data API |
| delete_rows | deleteRows | Deletes rows from a table based on filter criteria. | Data API |
| import_data (Local MCP only) | — | Imports data into a table from a local file (CSV / JSON) or a list of records. Not supported in Self-Hosted Remote MCP or Zoho MCP. | Bulk API |
| export_view (Local MCP only) | — | Exports a table, chart, or dashboard in the specified format (CSV, PDF, etc.). Dashboards are exported asynchronously. Not supported in Self-Hosted Remote MCP or Zoho MCP. | Bulk API |
| query_data (single tool — handles all steps internally) | createExportJobSQLQuery → getExportJobDetails → downloadExportedData (3 separate tools) | Executes a SQL query and returns results. In Local MCP and Self-Hosted Remote MCP, a single tool submits the job, polls for completion, and returns the results. In Zoho MCP, each step is a separate tool call. | Bulk API |
Analytics & Reports
| Local / Self-Hosted Remote MCP | Zoho MCP | Description | API |
| create_aggregate_formula | addAggregateFormula | Adds an aggregate formula column (e.g. SUM, COUNT, AVG) to a table. | Modeling API |
| create_query_table | createQueryTable | Creates a derived table from a SQL SELECT query. | Modeling API |
| — | editQueryTable | Updates the SQL definition of an existing query table. | Modeling API |
| — | getQueryTableDetails | Returns the SQL definition and column metadata of a query table. | Metadata API |
| create_chart_report (separate tool) | createReport (single tool — report type specified in config) | Creates a chart report (bar, line, pie, scatter, bubble) in the workspace. In Local MCP and Self-Hosted Remote MCP, a dedicated tool is used per report type. In Zoho MCP, a single tool handles all report types with the type specified in the request. | Modeling API |
| create_pivot_report (separate tool) | (see above) | Creates a pivot table report for multidimensional data analysis. | Modeling API |
| create_summary_report (separate tool) | (see above) | Creates a summary report that groups data by specified columns and applies aggregate functions. | Modeling API |
File Utilities
File utilities are available in Local MCP only (Docker and Node.js). They are not supported in Self-Hosted Remote MCP or Zoho MCP, and do not call the Zoho Analytics API.
| Local MCP | Description | Category |
| analyse_file_structure | Analyzes the structure of a CSV or JSON file to determine its columns and data types. Useful as a preparation step before importing data. | Local Utility |
| download_file | Downloads a file from a given URL and saves it to the local data directory. | Local Utility |
Configuring Tool Behavior
The following environment variables are available for Local MCP and Self-Hosted Remote MCP setups to adjust default tool limits and timeouts.
| Variable | Affects | Default |
| QUERY_DATA_RESULT_ROW_LIMITS | Maximum rows returned by query_data | 20 |
| QUERY_DATA_POLLING_INTERVAL | Seconds between job status polls in query_data | 4 |
| QUERY_DATA_QUEUE_TIMEOUT | Maximum seconds a query_data job can wait in queue | 120 |
| QUERY_DATA_QUERY_EXECUTION_TIMEOUT | Maximum seconds allowed for query_data execution | 30 |
| WORKSPACE_RESULT_LIMIT | Maximum workspaces returned by get_workspaces_list | 20 |
| VIEW_RESULT_LIMIT | Maximum views returned by search_views | 30 |
For instructions on setting these variables, refer to your setup guide: