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 offerings differ in tool granularity and supported capabilities:
| Offering | Tool Approach | Key Differences |
|---|---|---|
| Local MCP (Node.js) | High-level tools that handle multi-step API operations internally | Broadest Local MCP tool set. Supports file import/export, local utilities, report editing, lookups, and connection checks. Polling and job handling are managed automatically. |
| Local MCP (Docker) | Same approach as Local MCP (Node.js) | Supports file import/export and local file utilities. Does not include report editing, report metadata, lookups, aggregate formula listing, or connection checks. |
| Self-Hosted Remote MCP | Same tools as Local MCP (Docker) | 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, dashboard management, and formula editing. Each step in a multi-step operation is a separate tool call. |
| Plugins | All tools from Local MCP (Node.js) and Zoho MCP | Includes every tool on this page. Tools are surfaced to the AI model based on the task, so the full tool set is not loaded at once. |
Note: Some capabilities exist across all offerings but are implemented differently. For example, queryData / 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.
Tool names: Local MCP (Node.js) uses camelCase tool names, such as queryData. Local MCP (Docker) and Self-Hosted Remote MCP use snake_case tool names, such as query_data. The tables below list both names.
Plugins: Plugins include every tool on this page. Availability notes such as (Node.js only) or Zoho MCP only refer to the other offerings.
Workspace & View Management
| Local / Self-Hosted Remote MCP | Zoho MCP | Description | API |
|---|---|---|---|
| createWorkspace / create_workspace | createWorkspace | Creates a new workspace in Zoho Analytics. | Modeling API |
| getWorkspacesList / 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. Both Zoho MCP tools require an org-id, which you can get from getOrganizations. | Metadata API |
| — | getOrganizations | Lists the organizations accessible to the authenticated user. Useful as a first step to obtain a valid org-id. | Metadata API |
| createTable / create_table | createTable | Creates a new table in a workspace with defined columns. | Modeling API |
| createLookup (Node.js only) | — | Creates a lookup relationship between two tables. | Modeling API |
| deleteLookup (Node.js only) | — | Removes a lookup relationship between tables. | Modeling API |
| searchViews / search_views | getViews | Lists views (tables, reports, dashboards) within a workspace, with optional keyword filtering, type filtering, and pagination. In Local MCP and Self-Hosted Remote MCP, the tool also uses name matching to return the most relevant views. | Metadata API |
| getViewDetails / get_view_details | getViewDetails | Returns detailed metadata for a specific view, including structure and properties. | Metadata API |
| deleteView / delete_view | deleteView | Deletes a view (table, report, or dashboard) from a workspace. In Zoho MCP, the deleted view is moved to trash. | 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 |
|---|---|---|---|
| addRow / add_row | addRow | Adds a single row to a specified table. | Data API |
| updateRows / update_rows | updateRows | Updates rows in a table based on filter criteria. Supports upsert behavior. In Zoho MCP, use addIfNotExist to enable upsert. | Data API |
| deleteRows / delete_rows | deleteRows | Deletes rows from a table based on filter criteria. In Zoho MCP, can also delete all rows in a table. | Data API |
| importData / 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 |
| exportView / export_view (Local MCP only) | exportDataView | Exports a table, chart, or dashboard in the specified format (CSV, PDF, etc.). Dashboards are exported asynchronously. Not supported in Self-Hosted Remote MCP. In Zoho MCP, exportDataView exports a view's data synchronously. For asynchronous bulk exports, use createExportJobSQLQuery, getExportJobDetails, and downloadExportedData. | Bulk API |
| queryData / query_data (single tool that 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 |
|---|---|---|---|
| addAggregateFormula / create_aggregate_formula | addAggregateFormula | Adds an aggregate formula column (e.g. SUM, COUNT, AVG) to a table. | Modeling API |
| listAggregateFormulas (Node.js only) | listAggregateFormulas | Lists the aggregate formulas in a table. | Metadata API |
| — | editAggregateFormula | Edits an existing aggregate formula in a table. | Modeling API |
| — | editCustomFormulas | Edits existing custom formula definitions in a table. | Modeling API |
| createQueryTable / 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 |
| createChartReport / 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 |
| createPivotReport / create_pivot_report (separate tool) | (see above) | Creates a pivot table report for multidimensional data analysis. | Modeling API |
| createSummaryReport / create_summary_report (separate tool) | (see above) | Creates a summary report that groups data by specified columns and applies aggregate functions. | Modeling API |
| updateChart / updateSummary / updatePivot (Node.js only; separate tools) | updateReport (single tool for all report types) | Modifies an existing chart, summary, or pivot report. In Local MCP (Node.js), a dedicated tool is used per report type. In Zoho MCP, a single tool handles all report types. | Modeling API |
| readReportMetadata (Node.js only) | readReportMetadata | Returns the full design metadata of a chart, pivot, or summary report. | Metadata API |
Dashboard Management
Dashboard operations are available in Zoho MCP only.
| Zoho MCP | Description | API |
|---|---|---|
| createDashboard | Creates a new dashboard in a workspace. | Modeling API |
| readDashboardMetaData | Returns the metadata of an existing dashboard. Useful as a first step before editing a dashboard. | Metadata API |
| editDashboard | Edits an existing dashboard. | Modeling API |
Local Utilities
Local utilities are available in Local MCP only (Docker and Node.js). They are not supported in Self-Hosted Remote MCP or Zoho MCP. File utilities 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. | File Utility |
| download_file | Downloads a file from a given URL and saves it to the local data directory. | File Utility |
| checkConnection (Node.js only) | Runs a step-by-step health check of the MCP server setup. Useful for troubleshooting connection issues. | Diagnostic 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 queryData / query_data | 20 |
| QUERY_DATA_POLLING_INTERVAL | Seconds between job status polls in queryData / query_data | 4 |
| QUERY_DATA_QUEUE_TIMEOUT | Maximum seconds a queryData / query_data job can wait in queue | 120 |
| QUERY_DATA_QUERY_EXECUTION_TIMEOUT | Maximum seconds allowed for queryData / query_data execution | 30 |
| WORKSPACE_RESULT_LIMIT | Maximum workspaces returned by getWorkspacesList / get_workspaces_list | 20 |
| VIEW_RESULT_LIMIT | Maximum views returned by searchViews / search_views | 30 |
For instructions on setting these variables, refer to your setup guide: