Skip to content
HyperFormulaHyperFormulaHyperFormula (v3.5.0)
View as Markdown

HyperFormula MCP Server

An MCP (Model Context Protocol) server that exposes HyperFormula as a tool for any MCP-compatible AI client (Claude Desktop, Cursor, VS Code, and others) — giving LLMs deterministic spreadsheet and formula computation.

What it does

Section titled “What it does”
  • Evaluate formulas deterministically — your agent runs any Excel-compatible formula through HyperFormula instead of asking the LLM to do math. Results are exact, reproducible, and auditable.
  • Read and write cells and ranges — the agent inspects, populates, or modifies sheet data through typed tool calls.
  • Trace dependencies — precedents and dependents are surfaced so the agent can explain how every value was derived.
  • 425 built-in functions out of the box — the agent has access to the full Excel-compatible function set (SUM, VLOOKUP, IRR, INDEX/MATCH, and the rest), no implementation work required.

Example

Section titled “Example”

Run the server (no install needed once published):

Terminal window
npx -y @hyperformula/mcp

Wire it into an MCP client by adding it to the client’s config (for example, claude_desktop_config.json or .cursor/mcp.json):

{
  "mcpServers": {
    "hyperformula": {
      "command": "npx",
      "args": ["-y", "@hyperformula/mcp"]
    }
  }
}

The client now sees tools like evaluate, getCellValue, and setCellContents, and the agent can call them as part of any conversation — without inventing numbers.

Use cases

Section titled “Use cases”
  • Explain the spreadsheet — ask the agent what a workbook does, which cells are inputs, and how each output is derived; get answers grounded in real formula evaluation.
  • What-if scenarios and forecasting — the agent tweaks assumptions and reports how downstream results change, deterministically.
  • Validate and clean data — the agent scans ranges for errors, missing values, or inconsistencies and fixes them in place.
  • Generate formulas from natural language — the agent translates a plain-English calculation into a verified, working Excel formula.
  • Financial modeling and reporting — NPV, IRR, amortization, KPI rollups, and other quantitative workflows where the answer must be exact and auditable.

Get early access

Section titled “Get early access”
Section titled “Links”