Skip to main content
Glama
Sign In
xlsx-audit-mcp

xlsx-audit-mcp

by koleharv
OverviewSchemaSourceRelated ServersDiscussionsAdmin
TypeScript
Local

List formulas

list_formulas

List all formulas in an Excel workbook with their cell addresses and cached values. Filter by formula text or sheet name to find formulas for audit.

Instructions

Formulas with addresses and cached values. Filter with contains (e.g. 'INDIRECT', 'VLOOKUP') and/or sheet.

Tool call template

Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.

{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "arguments": {
      "path": "<path>"
    },
    "name": "list_formulas"
  }
}

Input Schema

NameRequiredDescriptionDefault
pathYesPath to an .xlsx workbook
limitNoMax results
sheetNoOnly this sheet
containsNoCase-insensitive substring of the formula text

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A4/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description must carry the burden of behavioral disclosure. It adds useful context like 'cached values' (indicating it reads cached results rather than recalculating) and the filtering behavior, but it does not explicitly state whether the operation is read-only, mention potential side effects, or discuss rate limits or performance considerations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is two concise sentences that front-load the core purpose ('Formulas with addresses and cached values') and then immediately explain the filtering options with concrete examples. Every word adds value, with no redundancy or fluff.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given that there is no output schema, the description provides a reasonable overview of what is returned (formulas with addresses and cached values) and mentions the key filtering capabilities. It lacks details about the exact return structure or pagination, but for a moderately simple list tool with thorough schema coverage, it is sufficiently complete.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema already describes all parameters with 100% coverage. The description's mention of filtering with `contains` and/or `sheet` adds a small amount of practical context, but it largely repeats what the schema already dictates, so the baseline of 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states what the tool does: it lists formulas with their addresses and cached values. This is a specific verb+resource combination that distinguishes it from sibling tools like workbook_overview or trace_cell by focusing on formula listing and filtering.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides clear context on how to use the tool by mentioning filtering options (`contains` and `sheet`). However, it does not explicitly state when to use this tool over the sibling tools or when not to use it, so it falls short of a perfect score.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Deploy Server

Other Tools