Excel MCP Server with Supabase Storage
Allows reading from and writing to Supabase Storage, enabling file upload, download, and listing for Excel files.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
<<<<<<< HEAD
Excel MCP Server with Supabase Storage
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
Related MCP server: Excel MCP Server
π 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-supabaseOption 2: Install from PyPI (Coming soon)
# Once published to PyPI, you can use:
uvx mcp-excel-supabaseOption 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-supabaseConfiguration
Create a
.envfile in your project directory:
cp .env.example .envEdit
.envand add your Supabase credentials:
SUPABASE_URL=https://yourproject.supabase.co
SUPABASE_KEY=your-service-role-key-hereClaude 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:stdioMCP_HOST: Server host address, default:127.0.0.1MCP_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 files to JSON format |
| Generate Excel files from JSON data |
| Edit cell formatting (fonts, colors, borders) |
| Merge cell ranges |
| Unmerge cell ranges |
| Adjust row heights |
| Adjust column widths |
| Upload/download files to/from Supabase |
| Set Excel formulas in cells |
| Recalculate all formulas in a workbook |
| Create, delete, rename, copy, move sheets |
| 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
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
π Related Projects
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
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-supabaseOption 2: Install from PyPI (Coming soon)
# Once published to PyPI, you can use:
uvx mcp-excel-supabaseOption 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-supabaseConfiguration
Create a
.envfile in your project directory:
cp .env.example .envEdit
.envand add your Supabase credentials:
SUPABASE_URL=https://yourproject.supabase.co
SUPABASE_KEY=your-service-role-key-hereClaude 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 files to JSON format |
| Generate Excel files from JSON data |
| Edit cell formatting (fonts, colors, borders) |
| Merge cell ranges |
| Unmerge cell ranges |
| Adjust row heights |
| Adjust column widths |
| Upload/download files to/from Supabase |
| Set Excel formulas in cells |
| Recalculate all formulas in a workbook |
| Create, delete, rename, copy, move sheets |
| 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
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
π Related Projects
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)
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelogβ¦
This server cannot be deployed
Maintenance
Related MCP Connectors
MCP server for interacting with the Supabase platform
One MCP server for the services your AI needs: memory, files, Microsoft 365, kanban and more.
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
Hosted MCP server for AI-driven data ops. Create apps, manage schemas, and CRUD structured data.
Related MCP Servers
- AlicenseNot gradedqualityNot gradedmaintenanceAn MCP server that provides tools for interacting with Supabase databases, storage, and edge functions.45MIT
- FlicenseNot gradedqualityDmaintenanceAn MCP server for manipulating Excel files that features a headless engine for real-time formula calculation and data validation. It enables users to create, read, and manage workbooks, sheets, and charts without requiring Microsoft Excel installed.-
- AlicenseNot gradedqualityDmaintenanceA production-ready MCP server providing AI assistants with intelligent Supabase database access, featuring dynamic schema discovery, complete user management, and file storage operations.1MIT
- AlicenseNot gradedqualityDmaintenanceMCP server for Supabase, enabling database CRUD, storage management, auth administration, project management, edge functions, and secrets via 31 tools.9 npmMIT