Overview

Zoho Analytics MCP is the official Model Context Protocol server built and maintained by Zoho for their analytics and business intelligence platform. It implements MCP as a standardized middleware layer, enabling AI agents to interact with Zoho Analytics through 19 documented tools covering workspace management, data operations, SQL queries, and report generation.

Available as both a Docker container and npm package, with remote deployment options for enterprise teams, this is one of the most mature official MCP servers in the ecosystem. It bridges AI assistants with Zoho Analytics'' full BI capabilities — from creating workspaces and importing data to executing SQL queries and generating chart, pivot, and summary reports.

The server''s ability to execute arbitrary SQL queries against analytics data makes it one of the higher-risk data tools in any governance strategy. Organizations need to carefully scope which workspaces AI agents can access and what query patterns are permitted to prevent unauthorized data exposure or accidental data modification.

Key Features

Workspace & Table Management

Create workspaces and tables with defined column schemas. List and search across workspaces to discover available data assets.

SQL Query Execution

Execute SQL queries against workspaces and return structured results. The most powerful and highest-risk capability, enabling arbitrary data access.

Report Generation

Create chart reports (bar, line, pie, scatter, bubble), pivot tables for multidimensional analysis, and summary reports with grouped data and aggregate functions.

Data Import & Export

Import data from files or dictionaries into tables, and export tables, charts, or dashboards in various formats for downstream consumption.

Row-Level CRUD

Add individual rows, update rows by criteria, and delete rows by criteria — providing granular data manipulation within analytics tables.

View Management

Search views (tables, reports, dashboards), get detailed view properties, and delete views when no longer needed.

Formula & Derived Tables

Create aggregate formulas for single-value calculations and query tables based on SQL for derived data views.

Capabilities

Zoho Analytics MCP exposes 19 tools for AI agents. 6 require approval.

3 Read10 Write2 Delete4 Execute

Use Cases

Strategy-Aligned Use Cases

Automated Business Reporting

AI assistants can query analytics data and generate formatted reports (charts, pivots, summaries) on demand, replacing manual report-building workflows.

Ad-Hoc Data Analysis

Enable business users to ask natural language questions about their data, with the AI translating requests into SQL queries against analytics workspaces.

Data Pipeline Management

Automate data import workflows by downloading files, analyzing their structure, creating appropriate table schemas, and importing data into Zoho Analytics.

Executive Dashboard Population

AI agents can create and update dashboard components by generating new chart reports, pivot tables, and summary views based on the latest data.

Considerations

Before You Adopt

**SQL Execution Risk**: The query_data tool executes arbitrary SQL against analytics workspaces. Without proper scoping, AI agents could access sensitive business data, financial metrics, or PII stored in analytics tables.
**Data Deletion Impact**: The delete_rows and delete_view tools can permanently remove data and reports. These operations should require approval and be restricted to admin roles.
**Data Import Integrity**: The import_data tool can modify table contents at scale. Malformed imports could corrupt analytics datasets that feed business dashboards and executive reporting.
**Cross-Workspace Access**: Organizations with multiple analytics workspaces (by department or project) need governance to prevent AI agents from accessing workspaces outside their authorized scope.
**Report Generation Costs**: Generating complex reports (pivots, charts) consumes computational resources. Ungoverned AI agents could create excessive reports, impacting platform performance and costs.

Stratafy Fit

Integration Potential

4/5

Zoho Analytics MCP is a high-priority governance target for Stratafy due to its SQL execution capabilities and direct access to business intelligence data. Stratafy can enforce workspace-level access policies (marketing only sees marketing data), gate destructive operations (delete_rows, delete_view) behind approval workflows, and audit all SQL queries for compliance. The official nature of this server (built by Zoho, hosted on their GitHub) and its mature deployment options make it a reliable integration point for enterprise AI governance.

Tool	Operation	Risk	Description
`get_workspaces_list` Fetches the list of workspaces in the user's organization	Read	Low Risk	Fetches the list of workspaces in the user's organization
`search_views` Retrieves views (tables, reports, dashboards) within a workspace based on query	Read	Low Risk	Retrieves views (tables, reports, dashboards) within a workspace based on query
`get_view_details` Fetches details of a specific view including structure and properties	Read	Low Risk	Fetches details of a specific view including structure and properties
`query_data`Approval Executes a SQL query on a specified workspace and returns results	Execute	High Risk	Executes a SQL query on a specified workspace and returns results
`create_workspace` Creates a new workspace in Zoho Analytics	Write	Medium Risk	Creates a new workspace in Zoho Analytics
`create_table` Creates a new table in a workspace with defined columns	Write	Medium Risk	Creates a new table in a workspace with defined columns
`import_data`Approval Imports data into a table from a file or list of dictionaries	Write	High Risk	Imports data into a table from a file or list of dictionaries
`export_view`Approval Exports a table, chart, or dashboard in specified format	Execute	High Risk	Exports a table, chart, or dashboard in specified format
`add_row` Adds a new row to a specified table	Write	Medium Risk	Adds a new row to a specified table
`update_rows`Approval Updates rows in a table based on given criteria	Write	High Risk	Updates rows in a table based on given criteria
`delete_rows`Approval Deletes rows from a table based on given criteria	Delete	High Risk	Deletes rows from a table based on given criteria
`delete_view`Approval Deletes a view (table, report, or dashboard) from a workspace	Delete	High Risk	Deletes a view (table, report, or dashboard) from a workspace
`create_chart_report` Creates a chart report (bar, line, pie, scatter, bubble) in a workspace	Write	Medium Risk	Creates a chart report (bar, line, pie, scatter, bubble) in a workspace
`create_pivot_report` Creates a pivot table report for multidimensional data analysis	Write	Medium Risk	Creates a pivot table report for multidimensional data analysis
`create_summary_report` Produces a summary report with grouped data and aggregate functions	Write	Medium Risk	Produces a summary report with grouped data and aggregate functions
`create_aggregate_formula` Creates an aggregate formula in a table returning a single value	Write	Medium Risk	Creates an aggregate formula in a table returning a single value
`create_query_table` Generates a query table based on SQL for derived data views	Write	Medium Risk	Generates a query table based on SQL for derived data views
`analyse_file_structure` Analyzes CSV or JSON file structure to determine columns and data types	Execute	Low Risk	Analyzes CSV or JSON file structure to determine columns and data types
`download_file` Downloads a file from a URL and saves to local directory	Execute	Medium Risk	Downloads a file from a URL and saves to local directory