Which integrations are available for this server?

Allows reading from and writing to Supabase Storage, enabling file upload, download, and listing for Excel files.

How do I use Excel MCP Server with Supabase Storage?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Excel MCP Server with Supabase Storage Load 'budget.xlsx' from Supabase and convert to JSON." That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

Excel MCP Server with Supabase Storage

by 1126misakp

Overview Schema Related Servers Score Discussions

Python

Hybrid

<<<<<<< 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

Create a .env file in your project directory:

cp .env.example .env

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

Product Requirements Document (PRD)
API Reference - Complete API documentation for all 12 tools
Usage Examples - 6 end-to-end examples
Architecture - System architecture and design patterns
Development Guide - Contributing and development workflow
Troubleshooting - Common issues and solutions

🛠️ 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

Issues: GitHub Issues
Discussions: GitHub Discussions

🗺️ 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

openpyxl - Excel file operations
Supabase - Cloud storage backend
MCP Protocol - Model Context Protocol

📊 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

🌟 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

Create a .env file in your project directory:

cp .env.example .env

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

Product Requirements Document (PRD)
API Reference - Complete API documentation for all 12 tools
Usage Examples - 6 end-to-end examples
Architecture - System architecture and design patterns
Development Guide - Contributing and development workflow
Troubleshooting - Common issues and solutions

🛠️ 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

Issues: GitHub Issues
Discussions: GitHub Discussions

🗺️ 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

openpyxl - Excel file operations
Supabase - Cloud storage backend
MCP Protocol - Model Context Protocol

📊 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)

This server cannot be installed

license - permissive license

quality - not tested

maintenance

How are these scores calculated?

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

Lightport: Open-Sourcing Glama's AI Gateway
By punkpeye on April 27, 2026.
open source
OpenAI
Tool Definition Quality Score (TDQS)
By punkpeye on April 3, 2026.
mcp
The Hackers Who Tracked My Sleep Cycle
By punkpeye on March 26, 2026.
security

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/1126misakp/Excel-MCP-Server-with-Supabase-Storage'

If you have feedback or need assistance with the MCP directory API, please join our Discord server

Excel MCP Server with Supabase Storage

🌟 Features

🚀 Quick Start

Installation

Option 1: Install from GitHub (Recommended for now)

Option 2: Install from PyPI (Coming soon)

Option 3: Install from local source

Configuration

Claude Desktop Configuration

If installing from GitHub:

If installing from PyPI (once published):

Transport Modes

STDIO Mode (Default)

HTTP Mode

SSE Mode

🛠️ Available Tools

📖 Usage Examples

Parse Excel to JSON

Create Excel from JSON

Format Cells

Set Formulas

Merge Excel Files

Supabase Storage Operations

📚 Documentation

🛠️ Development

Local Setup

Project Structure

🧪 Testing

📋 Requirements

🤝 Contributing

📄 License

🙋 Support

🗺️ Roadmap

Version 1.0 (Current)

Version 1.1 (Planned)

🌐 Related Projects

📊 Performance

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

Excel MCP Server with Supabase Storage

🌟 Features

🚀 Quick Start

Installation

Option 1: Install from GitHub (Recommended for now)

Option 2: Install from PyPI (Coming soon)

Option 3: Install from local source

Configuration

Claude Desktop Configuration

If installing from GitHub:

If installing from PyPI (once published):

🛠️ Available Tools

📖 Usage Examples

Parse Excel to JSON

Create Excel from JSON

Format Cells

Set Formulas

Merge Excel Files

Supabase Storage Operations

📚 Documentation

🛠️ Development

Local Setup

Project Structure

🧪 Testing

📋 Requirements

🤝 Contributing

📄 License

🙋 Support

🗺️ Roadmap

Version 1.0 (Current)

Version 1.1 (Planned)

🌐 Related Projects

📊 Performance

Resources

Looking for Admin?

Latest Blog Posts

MCP directory API