Skip to main content
Glama
TableFix MCP

TableFix MCP

by yijigao

TableFix MCP — Simulated Alexa+ Table Cleaner

Submission for the Amazon Developer Hackathon (Alexa+ track) + Open Source mini challenge.

Paste messy delimited text, get back a clean table — exposed as a self-hosted MCP server (MCP spec 2025-11-25, Streamable HTTP) with a simulated Alexa+ conversational layer on top.

Note: Alexa+'s MCP add-on deployment pipeline is currently partner-only, so per the official hackathon rules this project ships the sanctioned alternative: a real, spec-compliant MCP server plus a simulated Alexa+ experience web app that calls the same server. The simulation layer is clearly labeled in the UI.

What's inside

  • server.js — local dev MCP server (Express, stateless Streamable HTTP, port 3000)

  • api/mcp.js — same logic as a Vercel serverless function (/api/mcp)

  • detect.js — table/delimiter detection (ported from the TableFix project)

  • sim-web/ — simulated Alexa+ chat UI (calls the MCP server, downloads .xlsx)

  • vercel.json — rewrites /mcp → /api/mcp

Related MCP server: spreadsheet-mcp-app

Tools

Tool

Input

Output

detect_table

messy text

delimiter, columns, confidence, scores, suspect rows

clean_messy_text

messy text, header?

cleaned rows (JSON), delimiter, suspect rows

Run locally

npm install
npm start        # MCP server on http://localhost:3000
cd sim-web && node serve.js   # UI on http://localhost:8080

Verify: npm run verify (or see verification.log).

Friction log

See FRICTION-LOG.md — real integration notes, kept from day one.

License

MIT — see LICENSE.

Related MCP Connectors

Related MCP Servers

  • A
    license
    C
    quality
    C
    maintenance
    Enables conversational data analysis of Excel/CSV files through natural language queries, powered by 395 Excel functions via HyperFormula and multi-provider AI. Supports advanced analytics, bulk operations, financial modeling, and large file processing with intelligent chunking.
    35
    45 npm
    38
    MIT
  • A
    license
    Not graded
    quality
    B
    maintenance
    Enables normalizing arbitrary Excel spreadsheets with varied headers into 19 canonical fields and clean JSON, with optional LLM disambiguation and offline fallback. Exposes MCP tools for use in Claude, Cursor, and Windsurf.
    1
    MIT