Excel MCP Server with Supabase Storage

Excel MCP Server with Supabase Storage

A powerful MCP server for Excel operations with seamless Supabase Storage integration.

Category
访问服务器

README

<<<<<<< HEAD

Excel MCP Server with Supabase Storage

Python Version License: MIT MCP Compatible

A powerful MCP (Model Context Protocol) server for Excel operations with seamless Supabase Storage integration. Handle Excel files programmatically without requiring Microsoft Office or WPS installation.

🌟 Features

  • ✅ Excel Parsing: Convert Excel files to JSON with complete formatting information
  • ✅ Excel Generation: Create formatted Excel files from JSON data
  • ✅ Advanced Formatting: Modify cell styles, merge cells, adjust dimensions
  • ✅ Formula Support: Execute and calculate 20+ common Excel formulas
  • ✅ Multi-Sheet Operations: Merge multiple Excel files into a single workbook
  • ✅ Supabase Integration: Direct read/write operations with Supabase Storage
  • ✅ Zero Dependencies: No Microsoft Office or WPS required
  • ✅ Cross-Platform: Works on Windows, Linux, and macOS

🚀 Quick Start

Installation

Option 1: Install from GitHub (Recommended for now)

# Install and run directly
uvx --from git+https://github.com/1126misakp/Excel-MCP-Server-with-Supabase-Storage mcp-excel-supabase

Option 2: Install from PyPI (Coming soon)

# Once published to PyPI, you can use:
uvx mcp-excel-supabase

Option 3: Install from local source

# Clone the repository
git clone https://github.com/1126misakp/Excel-MCP-Server-with-Supabase-Storage
cd Excel-MCP-Server-with-Supabase-Storage

# Install in development mode
pip install -e .

# Run the server
mcp-excel-supabase

Configuration

  1. Create a .env file in your project directory:
cp .env.example .env
  1. Edit .env and add your Supabase credentials:
SUPABASE_URL=https://yourproject.supabase.co
SUPABASE_KEY=your-service-role-key-here

Claude Desktop Configuration

Add to your Claude Desktop configuration file:

Windows: %APPDATA%\Claude\claude_desktop_config.json macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Linux: ~/.config/Claude/claude_desktop_config.json

If installing from GitHub:

{
  "mcpServers": {
    "excel-supabase": {
      "command": "uvx",
      "args": [
        "--from",
        "git+https://github.com/1126misakp/Excel-MCP-Server-with-Supabase-Storage",
        "mcp-excel-supabase"
      ],
      "env": {
        "SUPABASE_URL": "https://yourproject.supabase.co",
        "SUPABASE_KEY": "your-service-role-key-here"
      }
    }
  }
}

If installing from PyPI (once published):

{
  "mcpServers": {
    "excel-supabase": {
      "command": "uvx",
      "args": ["mcp-excel-supabase"],
      "env": {
        "SUPABASE_URL": "https://yourproject.supabase.co",
        "SUPABASE_KEY": "your-service-role-key-here"
      }
    }
  }
}

Transport Modes

The server supports three transport modes via environment variables:

STDIO Mode (Default)

Best for Claude Desktop and command-line tools:

{
  "mcpServers": {
    "excel-supabase": {
      "command": "uvx",
      "args": ["mcp-excel-supabase"],
      "env": {
        "SUPABASE_URL": "https://yourproject.supabase.co",
        "SUPABASE_KEY": "your-service-role-key-here"
      }
    }
  }
}

HTTP Mode

Best for Cherry Studio and web clients:

{
  "mcpServers": {
    "excel-supabase": {
      "command": "uvx",
      "args": ["mcp-excel-supabase"],
      "env": {
        "SUPABASE_URL": "https://yourproject.supabase.co",
        "SUPABASE_KEY": "your-service-role-key-here",
        "MCP_TRANSPORT": "http",
        "MCP_HOST": "127.0.0.1",
        "MCP_PORT": "8000"
      }
    }
  }
}

SSE Mode

For legacy SSE clients:

{
  "mcpServers": {
    "excel-supabase": {
      "command": "uvx",
      "args": ["mcp-excel-supabase"],
      "env": {
        "SUPABASE_URL": "https://yourproject.supabase.co",
        "SUPABASE_KEY": "your-service-role-key-here",
        "MCP_TRANSPORT": "sse",
        "MCP_HOST": "127.0.0.1",
        "MCP_PORT": "8000"
      }
    }
  }
}

Environment Variables:

  • MCP_TRANSPORT: Transport mode (stdio | http | sse), default: stdio
  • MCP_HOST: Server host address, default: 127.0.0.1
  • MCP_PORT: Server port, default: 8000

For detailed transport configuration, see docs/TRANSPORT_MODES.md.

🛠️ Available Tools

This server provides 12 MCP tools for comprehensive Excel operations:

Tool Description
parse_excel_to_json Parse Excel files to JSON format
create_excel_from_json Generate Excel files from JSON data
modify_cell_format Edit cell formatting (fonts, colors, borders)
merge_cells Merge cell ranges
unmerge_cells Unmerge cell ranges
set_row_heights Adjust row heights
set_column_widths Adjust column widths
manage_storage Upload/download files to/from Supabase
set_formula Set Excel formulas in cells
recalculate_formulas Recalculate all formulas in a workbook
manage_sheets Create, delete, rename, copy, move sheets
merge_excel_files Merge multiple Excel files

See API Reference for detailed documentation.

📖 Usage Examples

Parse Excel to JSON

# Parse a local file
result = parse_excel_to_json(
    file_path="data/sales_q1.xlsx",
    extract_formats=True
)

# Access parsed data
workbook = result["workbook"]
sheets = workbook["sheets"]

Create Excel from JSON

# Create a simple Excel file
workbook_data = {
    "sheets": [{
        "name": "Sales",
        "rows": [
            {"cells": [
                {"value": "Product", "row": 1, "column": 1},
                {"value": "Revenue", "row": 1, "column": 2}
            ]},
            {"cells": [
                {"value": "Product A", "row": 2, "column": 1},
                {"value": 1000, "row": 2, "column": 2}
            ]}
        ]
    }]
}

create_excel_from_json(
    workbook_data=workbook_data,
    output_path="output/sales.xlsx",
    apply_formats=True
)

Format Cells

# Format header row
modify_cell_format(
    file_path="data/sales.xlsx",
    sheet_name="Sheet1",
    cell_range="A1:J1",
    format_spec={
        "font": {"name": "Arial", "size": 12, "bold": True, "color": "FFFFFF"},
        "fill": {"color": "4472C4"},
        "alignment": {"horizontal": "center", "vertical": "center"}
    }
)

Set Formulas

# Set a SUM formula
set_formula(
    file_path="data/sales.xlsx",
    sheet_name="Sheet1",
    cell="D10",
    formula="=SUM(D2:D9)"
)

# Recalculate all formulas
recalculate_formulas(
    file_path="data/sales.xlsx"
)

Merge Excel Files

# Merge quarterly reports
merge_excel_files(
    file_paths=["q1.xlsx", "q2.xlsx", "q3.xlsx", "q4.xlsx"],
    output_path="annual_report.xlsx",
    handle_duplicates="rename"  # or "skip" or "overwrite"
)

Supabase Storage Operations

# Upload file to Supabase
manage_storage(
    operation="upload",
    local_path="output/report.xlsx",
    remote_path="reports/2024/annual.xlsx"
)

# Download file from Supabase
manage_storage(
    operation="download",
    remote_path="reports/2024/annual.xlsx",
    local_path="downloads/annual.xlsx"
)

# List files
manage_storage(
    operation="list",
    remote_path="reports/2024/"
)

For more examples, see the Examples Directory.

📚 Documentation

🛠️ Development

Local Setup

# Clone the repository
git clone https://github.com/1126misakp/Excel-MCP-Server-with-Supabase-Storage
cd Excel-MCP-Server-with-Supabase-Storage

# Install dependencies
pip install -e ".[dev]"

# Run tests
pytest

# Run linter
ruff check .

# Format code
black .

Project Structure

Excel-MCP-Server-with-Supabase-Storage/
├── src/mcp_excel_supabase/      # Source code
│   ├── excel/                    # Excel operations
│   ├── storage/                  # Supabase integration
│   └── utils/                    # Utilities
├── tests/                        # Test suite
├── docs/                         # Documentation
└── PRD.md                        # Product Requirements

🧪 Testing

# Run all tests
pytest

# Run with coverage
pytest --cov

# Run specific test file
pytest tests/test_parser.py

📋 Requirements

  • Python 3.9+
  • Supabase account with Storage API access
  • No Microsoft Office or WPS installation required

🤝 Contributing

Contributions are welcome! Please see Development Guide for guidelines.

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

🙋 Support

🗺️ Roadmap

Version 1.0 (Current)

  • ✅ Core Excel parsing and generation
  • ✅ Supabase Storage integration
  • ✅ Basic formatting support
  • ✅ 20+ common formulas

Version 1.1 (Planned)

  • 📋 Chart generation support
  • 📋 Conditional formatting
  • 📋 Data validation rules
  • 📋 Advanced formula functions
  • 📋 WebUI control panel

🌐 Related Projects

📊 Performance

Benchmarked on a standard development machine (Intel i5, 8GB RAM):

Operation Target Actual Status
Parse 1MB file <2s 0.598s ✅ 3.3x faster
Generate 1000 rows <3s 0.026s ✅ 115x faster
Merge 10 files <8s 0.117s ✅ 68x faster
Batch 20 files <10s 0.192s ✅ 52x faster
Format 1000 cells <0.5s 0.089s ✅ 5.6x faster

Performance Optimizations:

  • ✅ LRU caching for parsed files (128 entries)
  • ✅ Thread pool concurrency (8 workers)
  • ✅ Streaming I/O for large files
  • ✅ Memory-efficient processing (5000 rows = +0.04MB)

Made with ❤️ by 1126misakp

This project is actively maintained and welcomes contributions from the community.

Excel MCP Server with Supabase Storage

Python Version License: MIT MCP Compatible

A powerful MCP (Model Context Protocol) server for Excel operations with seamless Supabase Storage integration. Handle Excel files programmatically without requiring Microsoft Office or WPS installation.

🌟 Features

  • ✅ Excel Parsing: Convert Excel files to JSON with complete formatting information
  • ✅ Excel Generation: Create formatted Excel files from JSON data
  • ✅ Advanced Formatting: Modify cell styles, merge cells, adjust dimensions
  • ✅ Formula Support: Execute and calculate 20+ common Excel formulas
  • ✅ Multi-Sheet Operations: Merge multiple Excel files into a single workbook
  • ✅ Supabase Integration: Direct read/write operations with Supabase Storage
  • ✅ Zero Dependencies: No Microsoft Office or WPS required
  • ✅ Cross-Platform: Works on Windows, Linux, and macOS

🚀 Quick Start

Installation

Option 1: Install from GitHub (Recommended for now)

# Install and run directly
uvx --from git+https://github.com/1126misakp/Excel-MCP-Server-with-Supabase-Storage mcp-excel-supabase

Option 2: Install from PyPI (Coming soon)

# Once published to PyPI, you can use:
uvx mcp-excel-supabase

Option 3: Install from local source

# Clone the repository
git clone https://github.com/1126misakp/Excel-MCP-Server-with-Supabase-Storage
cd Excel-MCP-Server-with-Supabase-Storage

# Install in development mode
pip install -e .

# Run the server
mcp-excel-supabase

Configuration

  1. Create a .env file in your project directory:
cp .env.example .env
  1. Edit .env and add your Supabase credentials:
SUPABASE_URL=https://yourproject.supabase.co
SUPABASE_KEY=your-service-role-key-here

Claude Desktop Configuration

Add to your Claude Desktop configuration file:

Windows: %APPDATA%\Claude\claude_desktop_config.json macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Linux: ~/.config/Claude/claude_desktop_config.json

If installing from GitHub:

{
  "mcpServers": {
    "excel-supabase": {
      "command": "uvx",
      "args": [
        "--from",
        "git+https://github.com/1126misakp/Excel-MCP-Server-with-Supabase-Storage",
        "mcp-excel-supabase"
      ],
      "env": {
        "SUPABASE_URL": "https://yourproject.supabase.co",
        "SUPABASE_KEY": "your-service-role-key-here"
      }
    }
  }
}

If installing from PyPI (once published):

{
  "mcpServers": {
    "excel-supabase": {
      "command": "uvx",
      "args": ["mcp-excel-supabase"],
      "env": {
        "SUPABASE_URL": "https://yourproject.supabase.co",
        "SUPABASE_KEY": "your-service-role-key-here"
      }
    }
  }
}

🛠️ Available Tools

This server provides 12 MCP tools for comprehensive Excel operations:

Tool Description
parse_excel_to_json Parse Excel files to JSON format
create_excel_from_json Generate Excel files from JSON data
modify_cell_format Edit cell formatting (fonts, colors, borders)
merge_cells Merge cell ranges
unmerge_cells Unmerge cell ranges
set_row_heights Adjust row heights
set_column_widths Adjust column widths
manage_storage Upload/download files to/from Supabase
set_formula Set Excel formulas in cells
recalculate_formulas Recalculate all formulas in a workbook
manage_sheets Create, delete, rename, copy, move sheets
merge_excel_files Merge multiple Excel files

See API Reference for detailed documentation.

📖 Usage Examples

Parse Excel to JSON

# Parse a local file
result = parse_excel_to_json(
    file_path="data/sales_q1.xlsx",
    extract_formats=True
)

# Access parsed data
workbook = result["workbook"]
sheets = workbook["sheets"]

Create Excel from JSON

# Create a simple Excel file
workbook_data = {
    "sheets": [{
        "name": "Sales",
        "rows": [
            {"cells": [
                {"value": "Product", "row": 1, "column": 1},
                {"value": "Revenue", "row": 1, "column": 2}
            ]},
            {"cells": [
                {"value": "Product A", "row": 2, "column": 1},
                {"value": 1000, "row": 2, "column": 2}
            ]}
        ]
    }]
}

create_excel_from_json(
    workbook_data=workbook_data,
    output_path="output/sales.xlsx",
    apply_formats=True
)

Format Cells

# Format header row
modify_cell_format(
    file_path="data/sales.xlsx",
    sheet_name="Sheet1",
    cell_range="A1:J1",
    format_spec={
        "font": {"name": "Arial", "size": 12, "bold": True, "color": "FFFFFF"},
        "fill": {"color": "4472C4"},
        "alignment": {"horizontal": "center", "vertical": "center"}
    }
)

Set Formulas

# Set a SUM formula
set_formula(
    file_path="data/sales.xlsx",
    sheet_name="Sheet1",
    cell="D10",
    formula="=SUM(D2:D9)"
)

# Recalculate all formulas
recalculate_formulas(
    file_path="data/sales.xlsx"
)

Merge Excel Files

# Merge quarterly reports
merge_excel_files(
    file_paths=["q1.xlsx", "q2.xlsx", "q3.xlsx", "q4.xlsx"],
    output_path="annual_report.xlsx",
    handle_duplicates="rename"  # or "skip" or "overwrite"
)

Supabase Storage Operations

# Upload file to Supabase
manage_storage(
    operation="upload",
    local_path="output/report.xlsx",
    remote_path="reports/2024/annual.xlsx"
)

# Download file from Supabase
manage_storage(
    operation="download",
    remote_path="reports/2024/annual.xlsx",
    local_path="downloads/annual.xlsx"
)

# List files
manage_storage(
    operation="list",
    remote_path="reports/2024/"
)

For more examples, see the Examples Directory.

📚 Documentation

🛠️ Development

Local Setup

# Clone the repository
git clone https://github.com/1126misakp/Excel-MCP-Server-with-Supabase-Storage
cd Excel-MCP-Server-with-Supabase-Storage

# Install dependencies
pip install -e ".[dev]"

# Run tests
pytest

# Run linter
ruff check .

# Format code
black .

Project Structure

Excel-MCP-Server-with-Supabase-Storage/
├── src/mcp_excel_supabase/      # Source code
│   ├── excel/                    # Excel operations
│   ├── storage/                  # Supabase integration
│   └── utils/                    # Utilities
├── tests/                        # Test suite
├── docs/                         # Documentation
└── PRD.md                        # Product Requirements

🧪 Testing

# Run all tests
pytest

# Run with coverage
pytest --cov

# Run specific test file
pytest tests/test_parser.py

📋 Requirements

  • Python 3.9+
  • Supabase account with Storage API access
  • No Microsoft Office or WPS installation required

🤝 Contributing

Contributions are welcome! Please see Development Guide for guidelines.

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

🙋 Support

🗺️ Roadmap

Version 1.0 (Current)

  • ✅ Core Excel parsing and generation
  • ✅ Supabase Storage integration
  • ✅ Basic formatting support
  • ✅ 20+ common formulas

Version 1.1 (Planned)

  • 📋 Chart generation support
  • 📋 Conditional formatting
  • 📋 Data validation rules
  • 📋 Advanced formula functions
  • 📋 WebUI control panel

🌐 Related Projects

📊 Performance

Benchmarked on a standard development machine (Intel i5, 8GB RAM):

Operation Target Actual Status
Parse 1MB file <2s 0.598s ✅ 3.3x faster
Generate 1000 rows <3s 0.026s ✅ 115x faster
Merge 10 files <8s 0.117s ✅ 68x faster
Batch 20 files <10s 0.192s ✅ 52x faster
Format 1000 cells <0.5s 0.089s ✅ 5.6x faster

Performance Optimizations:

  • ✅ LRU caching for parsed files (128 entries)
  • ✅ Thread pool concurrency (8 workers)
  • ✅ Streaming I/O for large files
  • ✅ Memory-efficient processing (5000 rows = +0.04MB)

Made with ❤️ by 1126misakp

This project is actively maintained and welcomes contributions from the community.

6dc69b6 (Release v1.0.0: Complete Excel MCP Server with Supabase Storage)

推荐服务器

Baidu Map

Baidu Map

百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。

官方
精选
JavaScript
Playwright MCP Server

Playwright MCP Server

一个模型上下文协议服务器，它使大型语言模型能够通过结构化的可访问性快照与网页进行交互，而无需视觉模型或屏幕截图。

官方
精选
TypeScript
Magic Component Platform (MCP)

Magic Component Platform (MCP)

一个由人工智能驱动的工具，可以从自然语言描述生成现代化的用户界面组件，并与流行的集成开发环境（IDE）集成，从而简化用户界面开发流程。

官方
精选
本地
TypeScript
Audiense Insights MCP Server

Audiense Insights MCP Server

通过模型上下文协议启用与 Audiense Insights 账户的交互，从而促进营销洞察和受众数据的提取和分析，包括人口统计信息、行为和影响者互动。

官方
精选
本地
TypeScript
VeyraX

VeyraX

一个单一的 MCP 工具，连接你所有喜爱的工具：Gmail、日历以及其他 40 多个工具。

官方
精选
本地
graphlit-mcp-server

graphlit-mcp-server

模型上下文协议 (MCP) 服务器实现了 MCP 客户端与 Graphlit 服务之间的集成。 除了网络爬取之外，还可以将任何内容（从 Slack 到 Gmail 再到播客订阅源）导入到 Graphlit 项目中，然后从 MCP 客户端检索相关内容。

官方
精选
TypeScript
Kagi MCP Server

Kagi MCP Server

一个 MCP 服务器，集成了 Kagi 搜索功能和 Claude AI，使 Claude 能够在回答需要最新信息的问题时执行实时网络搜索。

官方
精选
Python
e2b-mcp-server

e2b-mcp-server

使用 MCP 通过 e2b 运行代码。

官方
精选
Neon MCP Server

Neon MCP Server

用于与 Neon 管理 API 和数据库交互的 MCP 服务器

官方
精选
Exa MCP Server

Exa MCP Server

模型上下文协议（MCP）服务器允许像 Claude 这样的 AI 助手使用 Exa AI 搜索 API 进行网络搜索。这种设置允许 AI 模型以安全和受控的方式获取实时的网络信息。

官方
精选