n8n-mcp-server

ppwcr/n8n-mcp-server

3.2

If you are the rightful owner of n8n-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

The XLSX MCP Server is a lightweight, containerized service designed to convert Excel files into JSON format, making them compatible with LLMs while preserving cell values and formulas.

Tools
1
Resources
0
Prompts
0

% XLSX MCP Server

A lightweight containerized service that converts .xlsx files to compact, LLM-friendly JSON, preserving both cell values and formulas across multiple sheets. Exposes a simple HTTP tool endpoint and includes an MCP-style discovery stub.

Quick Start

  • Put your Excel files in ./data (mounted to /data in the container).
  • Build and run:
    • docker compose up --build
  • Health check:
    • curl http://localhost:8000/healthz

Convert Excel → JSON

Request (JSON path input):

curl -sS -X POST http://localhost:8000/tools/convert_xlsx_to_json \
  -H 'Content-Type: application/json' \
  -d '{"file_path":"/data/sample.xlsx"}' | jq

Behavior:

  • Reads the XLSX at file_path.
  • Writes JSON to the same directory with the same base name: /data/sample.json.
  • Output JSON contains per-sheet headers (if detected), and rows where each cell maps to { "v": value, "f": formula? }.

Request (multipart, field name 'data'):

curl -sS -X POST http://localhost:8000/tools/convert_xlsx_to_json \
  -F "data=@./data/sample.xlsx" | jq

Request (raw binary body):

curl -sS -X POST 'http://localhost:8000/tools/convert_xlsx_to_json?filename=sample.xlsx' \
  --data-binary @./data/sample.xlsx | jq

Supported Formats

  • Supported: .xlsx, .xlsm, .xltx, .xltm (Open XML). Macros aren’t executed; formulas are captured.
  • Not supported: .xls, .xlsb, .ods, .csv (ask if you need these).

Notes for Gemini

  • Output is compact and regularized: only {v, f} keys per cell.
  • Empty cells are omitted by default to reduce tokens; include them via include_empty: true.

MCP Discovery Stub

  • List tools: GET /mcp/tools (non-standard helper for MCP-aware clients).

Local CLI (inside container)

  • docker compose exec xlsx-mcp python -m app.convert_xlsx /data/sample.xlsx

Development

  • Dependencies are in app/requirements.txt.
  • Server runs at http://0.0.0.0:8000 (FastAPI/uvicorn).

Background Run & Auto-Start (macOS)

  • Compose uses restart: unless-stopped to auto-restart with Docker.
  • Run once in background: docker compose up -d --build
  • Enable Docker Desktop at login: Docker Desktop → Settings → General → "Start Docker Desktop when you log in".
  • After login, Docker starts and the container auto-starts.
  • Useful:
    • docker compose ps
    • docker compose logs -f xlsx-mcp
    • docker compose stop / docker compose start
    • docker compose down (remove)

n8n-mcp-server