ganit-mcp 0.3.6

MCP server exposing ganit formula evaluation as a tool for AI assistants
ganit-mcp-0.3.6 is not a library.

ganit-mcp

crates.io license

MCP server that exposes ganit spreadsheet formula evaluation as tools for AI assistants.

Plug it into Claude Desktop (or any MCP-compatible client) and your AI can evaluate, validate, and explain Excel-compatible formulas without writing any code.

Install

cargo install ganit-mcp

Claude Desktop setup

Add the server to ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "ganit": {
      "command": "/Users/your-username/.cargo/bin/ganit-mcp"
    }
  }
}

Restart Claude Desktop. The tools will appear automatically.

Tools

evaluate

Evaluate a formula with optional variable bindings.

{ "formula": "SUM(A1, B1)", "variables": { "A1": 100, "B1": 200 } }

Returns: { "value": 300, "type": "number" }

validate

Check whether a formula parses without errors.

{ "formula": "IF(score >= 60, \"pass\", \"fail\")" }

Returns: { "valid": true } or { "valid": false, "error": "..." }

explain

Describe a formula and list the functions it uses.

{ "formula": "IF(AND(A1 > 0, B1 > 0), SUM(A1, B1), 0)" }

Returns: { "description": "Formula using: AND, IF, SUM", "functions_used": ["AND", "IF", "SUM"] }

batch_evaluate

Evaluate multiple formulas sharing the same variable bindings.

{
  "formulas": ["SUM(A1, B1)", "AVERAGE(A1, B1)", "MAX(A1, B1)"],
  "variables": { "A1": 10, "B1": 90 }
}

Returns an array of results in the same order.

list_functions

Return the full catalogue of supported spreadsheet functions with category, syntax, and description.

Supported functions

Covers math, logical, text, financial, and statistical categories. For the full list with signatures and descriptions, call the list_functions tool — it returns the live registry.

Related

  • ganit-core — the underlying formula engine (Rust library)
  • @tryganit/core — WebAssembly package for JavaScript/TypeScript

License

MIT