MCP Excel Analyzer

MCP Excel Analyzer is a lightweight Node.js server that connects to Claude Desktop and continuously analyzes Excel files across multiple projects. It helps detect and fix lint errors and coding issues, acting as a local AI assistant for developers.

🚀 Features

• ✅ Monitors selected project paths for Excel files or coding issues
• ⚙️ Sends lint/code data to Claude for analysis
• 🔁 Continuously runs in the background
• 📡 Exposes endpoints for querying Claude or triggering analysis manually
• 🧠 Designed for automation and local developer productivity

📂 Project Structure

mcp-excel-analyzer/
├── src/
│   ├── analyzer/         # Core logic for scanning and parsing Excel/code
│   ├── api/              # REST API endpoints
│   ├── services/         # Claude integration and helpers
│   └── config/           # Configurations and path setup
├── .env
├── package.json
└── README.md

⚙️ Setup

Prerequisites

• Node.js v18+
• .env file with Claude API keys and project settings

Install

git clone https://github.com/your-username/mcp-excel-analyzer.git
cd mcp-excel-analyzer
npm install

Run

npm start

The server will:

• Watch the specified directory
• Analyze Excel/code files
• Communicate with Claude Desktop
• Serve results via API

🧠 Usage Example

Send a POST request to /analyze with a file path:

curl -X POST http://localhost:3000/analyze   -H "Content-Type: application/json"   -d '{"filePath": "/path/to/project/file.xlsx"}'

🔐 Environment Variables

CLAUDE_API_KEY=your_api_key_here
WATCH_PATH=/path/to/projects
PORT=3000

🛠 Tech Stack

• Node.js
• Express.js
• Claude AI (local integration)
• dotenv
• Chokidar (for file watching)

📈 Roadmap

• Add UI to display results visually
• Integrate real-time Claude responses
• Support more file types beyond Excel

🤝 Contributing

Feel free to fork the repo and submit PRs or feature suggestions.

---

📧 Contact

Created by @OsamaNuserat – for questions or collaboration, reach out anytime.

---