MCP Server
Analytics Plus MCP Server
The Analytics MCP Server (Beta) implements the Model Context Protocol (MCP), a standardized interface that enables AI models to interact seamlessly with applications. This middleware solution bridges the connection between AI agents and Analytics Plus, providing powerful data analysis capabilities through a unified interface.
Key features
Full access to Analytics plus workspaces via the Analytics Plus V2 API.
External integration with Analytics Plus features
Combination of AI knowledge with Analytics Plus advanced analytics
Compatible with all MCP Hosts (including Claude Desktop, Cursor, and others)
Comprehensive tools for Analytics Plus operations.
Note:
Analytics Plus MCP Servers consume API units based on the specific APIs used to generate responses.
The Analytics Plus MCP project is currently in its early development (beta) phase. As development progresses, the features and tools offered may be modified or updated to reflect continuous improvements.
Getting Started
2. Configuring Environment Variables
Step 1: Docker Image Setup
System Requirements
To build the Analytics Plus MCP server from the repository, you need to have Docker installed on your system. Before setup, please make sure to have docker and a container runtime installed in your device.
Operating System | Docker Solutions |
macOS | |
Windows | |
Linux | Docker Engine (Native), Podman Desktop, Colima |
Pull from Docker repository
You can configure the Docker image by this mentioned method. Use the pre-built image from a container registry (e.g., Docker Hub). The official pre-built Docker image is hosted on Docker Hub and it can be pulled directly:
Pull Docker Image
docker pull meanalyticsplus/mcp-server:latestStep 2: Configuring Environment Variables
Obtaining OAuth Credentials
To configure the Analytics Plus MCP Server, you need to provide OAuth credentials (Client ID, Client Secret, and Refresh Token) as environment variables. Follow these steps to generate them:
Go to the Analytics Plus Developer Console
Create a new Self-Client application.
Enable the Analytics Plus API scope.
Generate your Refresh Token.
For detailed instructions, refer to the official API Authentication Documentation.
Required Environment Variables
Configure these essential variables before integrating with the MCP Hosts:
Variable | Description |
ANALYTICS_CLIENT_ID | Your Analytics Plus OAuth client ID |
ANALYTICS_CLIENT_SECRET | Your Analytics Plus OAuth client secret |
ANALYTICS_REFRESH_TOKEN | Your Analytics Plus OAuth refresh token |
ANALYTICS_ORG_ID | Your Analytics Plus organization ID |
ANALYTICS_MCP_DATA_DIR | Directory for storing temporary data files |
ACCOUNTS_SERVER_URL | Your Analytics Plus Accounts Server URL, based on data centre (DC) location. Example: https://analyticsplus.manageengine.com/ Please refer to the API Specification document for more details. |
ANALYTICS_SERVER_URL | Your Analytics Plus Server URL, based on data centre (DC) location. Example: https://analyticsplusapi.manageengine.com Please refer to the API Specification document for more details. |
Other Environment Variables
The following is a list of other environment variables:
Variable | Description |
QUERY_DATA_ROW_LIMIT (Optional) | Number of rows outputted by the query_data tool. Default row limit - 20 |
QUERY_DATA_POLLING_INTERVAL (Optional) | Sleep Time between consecutive polls to check job status (JOB COMPLETED, JOB IN QUEUE; For more, please refer to analytics v2 api documentation) Default sleep interval time - 4 seconds |
QUERY_DATA_QUEUE_TIMEOUT (Optional) | This is the amount of time allowed between job submit time in the queue and job processing (query processing) time. Default time allowed in queue - 120 seconds |
QUERY_DATA_QUERY_EXECUTION_TIMEOUT (Optional) | The amount of time allowed for query execution. Default execution time - 30 seconds |
WORKSPACE_RESULT_LIMIT (Optional) | The number of workspaces that will be returned in the response by the get_workspaces tool. Default size of the workspaces list - 20 |
VIEW_RESULT_LIMIT (Optional) | The number of view that will be returned in the response by get_views tool. Default size of the views list - 20 |
Step 3: Integrate with MCP Hosts
Analytics Plus MCP Server can be integrated with any MCP host. Below are some sample integrations that demonstrate how this can be done.
To configure the Analytics Plus MCP server with Claude Desktop, add the following configuration to your Claude settings:
Install Claude Desktop in your system.
Open the Claude Desktop application and navigate to Settings > Developer tab.
Click Edit Config to configure (claude_desktop_config.json) with your MCP server details.
Sample Config JSON
{
"mcpServers": {
"meanalyticsplusMCP": {
"command": "docker",
"args": [
"run",
"-e", "ANALYTICS_CLIENT_ID=<YOUR_ANALYTICS_CLIENT_ID>",
"-e", "ANALYTICS_CLIENT_SECRET=<YOUR_ANALYTICS_CLIENT_SECRET>",
"-e", "ANALYTICS_REFRESH_TOKEN=<YOUR_ANALYTICS_REFRESH_TOKEN>",
"-e", "ANALYTICS_ORG_ID=<YOUR_ANALYTICS_ORG_ID>",
"-e", "ANALYTICS_MCP_DATA_DIR=<YOUR_ANALYTICS_MCP_DATA_DIR>",
"-e", "ACCOUNTS_SERVER_URL=<YOUR_ANALYTICS_ACCOUNTS_SERVER_URL>",
"-e", "ANALYTICS_SERVER_URL=<YOUR_ANALYTICS_SERVER_URL>",
"--network=host",
"-i",
"--rm",
"-v", "<YOUR_ANALYTICS_MCP_DATA_DIR>:<YOUR_ANALYTICS_MCP_DATA_DIR>",
"meanalyticsplus/mcp-server"
]
}
}
}To configure the Analytics Plus MCP server with Visual Studio Code:
Install the VSCode in your system.
Open the VSCode application and navigate to Settings.
In the Settings page, search for MCP configurations. Select the Edit in settings.json option to configure the MCP server.
Sample Config JSON
"mcp": {
"servers": {
"meanalyticsplus_mcp_server": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-e", "ANALYTICS_CLIENT_ID=<YOUR_ANALYTICS_CLIENT_ID>",
"-e", "ANALYTICS_CLIENT_SECRET=<YOUR_ANALYTICS_CLIENT_SECRET>",
"-e", "ANALYTICS_REFRESH_TOKEN=<YOUR_ANALYTICS_REFRESH_TOKEN>",
"-e", "ANALYTICS_ORG_ID=<YOUR_ANALYTICS_ORG_ID>",
"-e", "ANALYTICS_MCP_DATA_DIR=<YOUR_LOCAL_DATA_DIR>",
"-e", "ACCOUNTS_SERVER_URL=<YOUR_ANALYTICS_ACCOUNTS_SERVER_URL>",
"-e", "ANALYTICS_SERVER_URL=<YOUR_ANALYTICS_SERVER_URL>",
"--network=host",
"-i",
"--rm",
"-v", "<YOUR_LOCAL_DATA_DIR>:<YOUR_LOCAL_DATA_DIR>",
"meanalyticsplus/mcp-server"
]
}
}
}To configure the Analytics Plus MCP server with Cursor:
Install the Cursor in your system.
Open the Cursor application and navigate to Settings > Tools and Integrations.
Click the Add Custom MCP menu to enter your server configuration details, and Save.
Sample Config JSON
{
"mcpServers": {
"meanalyticsplusMCP": {
"command": "docker",
"args": [
"run",
"-e", "ANALYTICS_CLIENT_ID=<YOUR_ANALYTICS_CLIENT_ID>",
"-e", "ANALYTICS_CLIENT_SECRET=<YOUR_ANALYTICS_CLIENT_SECRET>",
"-e", "ANALYTICS_REFRESH_TOKEN=<YOUR_ANALYTICS_REFRESH_TOKEN>",
"-e", "ANALYTICS_ORG_ID=<YOUR_ANALYTICS_ORG_ID>",
"-e", "ANALYTICS_MCP_DATA_DIR=<YOUR_ANALYTICS_MCP_DATA_DIR>",
"-e", "ACCOUNTS_SERVER_URL=<YOUR_ANALYTICS_ACCOUNTS_SERVER_URL>",
"-e", "ANALYTICS_SERVER_URL=<YOUR_ANALYTICS_SERVER_URL>",
"--network=host",
"-i",
"--rm",
"-v", "<YOUR_ANALYTICS_MCP_DATA_DIR>:<YOUR_ANALYTICS_MCP_DATA_DIR>",
"meanalyticsplus/mcp-server"
]
}
}
}Tools in Analytics Plus MCP Server
The Analytics Plus MCP server provides various tools for interacting with Analytics Plus.
Tool | API Used | Description |
create_workspace | Creates a new workspace in Analytics Plus with the given name. | |
create_table | Creates a new table in a specified workspace with defined columns. | |
get_workspaces_list | Fetches the list of workspaces in the user's organization. | |
search_views | Fetches the list of views (tables, reports, dashboards) within a specified workspace based on the query. | |
get_view_details | Get View Details | Fetches the details of a specific view, including its structure and properties. |
import_data | Imports data into a specified table from a file or a list of dictionaries. | |
export_view |
| Exports an object (table, chart, or dashboard) from the workspace in the specified format. |
query_data | Executes a SQL query on the specified workspace and returns the results. Note: | |
create_aggregate_formula | Add Aggregate Formula | Creates an aggregate formula in a specified table that returns a single aggregate value. |
create_query_table | Creates a query table based on a SQL query for derived data views. | |
create_chart_report | Create Report | Creates a chart report (bar, line, pie, scatter, bubble) in the specified workspace. |
create_pivot_report | Create Report | Creates a pivot table report for multidimensional data analysis. |
create_summary_report | Create Report | Creates a summary report that groups data by specified columns and applies aggregate functions. |
add_row | Adds a new row to a specified table. | |
update_rows | Updates rows in a specified table based on given criteria. | |
delete_rows | Deletes rows from a specified table based on given criteria. | |
delete_view | Deletes a view (table, report, or dashboard) from a workspace. | |
analyse_file_structure | Not Applicable | Analyzes the structure of a CSV or JSON file to determine its columns and data types. |
download_file | Not Applicable | Downloads a file from a given URL and saves it to a local directory. |
Troubleshooting
For common issues:
Authentication Problems:
Verify all OAuth credentials
Ensure tokens have proper permissions
Check token expiration status
Connection Issues:
Confirm the Docker container is running
Validate network connectivity
Check firewall settings
Data Center Configuration Errors:
Ensure the ACCOUNTS_SERVER_URL and ANALYTICS_SERVER_URL in your configuration are correct and matches your organization's designated data center (DC) location.
Please refer to the API Specification document for more details.
File System Problems:
Confirm the data directory exists
Check directory permissions
Verify sufficient disk space
Help & Support
We offer 24x5 technical support (Monday to Friday). In case if you need our assistance kindly do mail us your questions to analyticsplus-support@manageengine.com
You can also reach out to us on our toll-free numbers.
US : (+1) 469 501 6108
UK : (+44) 207 660 2649
AUS : (+61) 892 100 050
India: +91-44-69656217