# analyze_missing_values

A read tool on the Excel MCP Server MCP server.

Agent View of the PolicyLayer registry record for `analyze_missing_values`. HTML page: https://policylayer.com/tools/aifornorms-excelmcp/analyze-missing-values

## Facts

- Tool: `analyze_missing_values`
- Server: Excel MCP Server (`aifornorms/excelmcp`) — https://policylayer.com/tools/aifornorms-excelmcp.md
- Homepage: https://github.com/Aifornorms/ExcelMCP
- Risk category: Read (Low risk)
- Registry record: grade B, identity unverified
- Server rate-limited: no
- Parameters: 0
- Recommended policy verdict: Allowed

## Example call (MCP tools/call, JSON-RPC 2.0)

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "analyze_missing_values",
    "arguments": {}
  }
}
```

## Why analyze_missing_values is rated Low

This tool appears to analyze or query missing values in Excel data, which is a read-only inspection operation. It follows the naming and functional pattern of other analysis tools in the same server that retrieve insights from data without creating, modifying, or deleting content. The empty description lowers confidence slightly, but contextual alignment with sibling Read operations justifies the classification.

From the tool's own definition: "Tool name 'analyze_missing_values' indicates data analysis/inspection. Sibling tools like 'analyze_correlations', 'analyze_data', 'analyze_numeric_stats' are all Read operations on Excel workbooks."

## Use case

AI agents call analyze_missing_values to retrieve information from Excel MCP Server without modifying anything. It is typically the context-gathering step in research, monitoring, and reporting workflows, before the agent takes action elsewhere.

## Recommended policy (PolicyLayer)

Verdict: **Allowed**. Enforced by the PolicyLayer MCP gateway (https://policylayer.com/mcp-gateway) before a call reaches Excel MCP Server:

```json
{
  "version": "1",
  "default": "deny",
  "tools": {
    "analyze_missing_values": {}
  }
}
```

## Other tools on Excel MCP Server (14)

- `analyze_correlations` — Read — https://policylayer.com/tools/aifornorms-excelmcp/analyze-correlations.md
- `analyze_data` — Read — https://policylayer.com/tools/aifornorms-excelmcp/analyze-data.md
- `analyze_data_overview` — Read — https://policylayer.com/tools/aifornorms-excelmcp/analyze-data-overview.md
- `analyze_group_stats` — Read — https://policylayer.com/tools/aifornorms-excelmcp/analyze-group-stats.md
- `analyze_numeric_stats` — Read — https://policylayer.com/tools/aifornorms-excelmcp/analyze-numeric-stats.md
- `analyze_time_series` — Read — https://policylayer.com/tools/aifornorms-excelmcp/analyze-time-series.md
- `analyze_unique_values` — Read — https://policylayer.com/tools/aifornorms-excelmcp/analyze-unique-values.md
- `get_random_sample` — Read — https://policylayer.com/tools/aifornorms-excelmcp/get-random-sample.md
- `list_columns` — Read — https://policylayer.com/tools/aifornorms-excelmcp/list-columns.md
- `list_worksheets` — Read — https://policylayer.com/tools/aifornorms-excelmcp/list-worksheets.md
- `plot_matplotlib_chart` — Read — https://policylayer.com/tools/aifornorms-excelmcp/plot-matplotlib-chart.md
- `plot_pyecharts_chart` — Read — https://policylayer.com/tools/aifornorms-excelmcp/plot-pyecharts-chart.md
- `plot_pyecharts_dashboard` — Write — https://policylayer.com/tools/aifornorms-excelmcp/plot-pyecharts-dashboard.md
- `save_transformed_data` — Write — https://policylayer.com/tools/aifornorms-excelmcp/save-transformed-data.md

## For agents

This record is a snapshot. Live verdicts and the full registry:

- Check every server in your MCP config at once: `npx -y policylayer stack`
- Vet a server before you add it: install the mcp-precheck skill — `npx skills add https://policylayer.com` (skill text: https://policylayer.com/skill.md)
- Query the registry over MCP: endpoint `https://api.policylayer.com/mcp` — tools `check_mcp_server`, `check_mcp_stack`, `check_tool`, `search_registry`, `get_change_events`

---

Source: the PolicyLayer MCP registry — one continuously verified record per MCP server. Full record: https://policylayer.com/registry?q=aifornorms-excelmcp · API: https://policylayer.com/registry/api · Policy library: https://policylayer.com/policies/aifornorms-excelmcp