lillard01/chatexcel-mcp
Developer toolsThis page was translated automatically. Technical details may differ from the original. View the original
chatExcel - An Excel intelligent processing and data analysis server based on Model Context Protocol (MCP), specifically designed for intelligent Excel file parsing, data processing, code execution, and interactive chart generation. Supports complex Excel format processing, intelligent parameter recommendations, code template generation, and advanced data visualization.
Overview
It is an enterprise-grade Excel intelligent processing server based on MCP (Model Context Protocol), offering powerful Excel file analysis, data processing, formula calculation, and visualization capabilities. - (2 tools): Intelligent code detection, structural analysis - (9 tools): Secure code execution, parameter recommendations, template generation - (3 tools): Interactive chart generation (Chart.js) - (12 tools): Multi-level quality checking, intelligent cleaning - (5 tools): Formula parsing, compilation, execution, verification - : Traditional processing based on pandas/openpyxl, supports complex data analysis - : High-performance concurrent processing, suitable for large-scale data processing (optional) - : AST syntax analysis and security verification, supports complex nested formulas - : code generation and dependency analysis to optimize execution performance - : secure execution environment and result verification, supports contextual computation - : dependency graph generation and loop detection to avoid computational deadlocks - : syntax checks and risk assessment to ensure formula security - : Comprehensive verification of data integrity, consistency, and accuracy - : Automated data cleaning and format standardization - : Parallel processing of multiple Excel files to improve processing efficiency - : Multi-condition data extraction and content analysis - : Multi-table data merging and configuration processing - : Automated character format conversion and rule configuration - : AST analysis and function whitelisting to prevent malicious code execution - : Isolated execution environment to protect system security - : Fine-grained access control and operation auditing - : Intelligent dependency analysis and security vulnerability detection - : Multi-level caching strategy to reduce redundant computation - : Asynchronous task execution to improve processing speed - : Large file chunking processing optimized memory usage - : Automatic retry mechanism and health monitoring ChatExcel MCP Server is a powerful Model Context Protocol (MCP) server specifically designed for Excel file processing, data analysis, and visualization. The project integrates the best data processing libraries from the Python ecosystem and provides high-performance Excel operation capabilities through the Go Excelize library.
Overview (machine translated)
Latest Update (2025-06-19): Pandas import issues have been fully fixed, project structure optimization completed, and enterprise-level functions fully ready
🚀 > Enterprise-grade Excel intelligent processing and data analysis MCP server - A high-performance data processing solution built on FastMCP
chatExcel-mcp is an enterprise-grade Excel intelligent processing server based on MCP (Model Context Protocol), offering powerful Excel file analysis, data processing, formula calculation, and visualization functions.
🚀 Core Features
📊 31 Professional MCP Tools
- Data Reading and Metadata Analysis (2 tools): Intelligent code detection, structural analysis
- Data Processing and Execution (9 tools): Secure code execution, parameter recommendations, template generation
- Data Visualization (3 tools): Interactive chart generation (Chart.js)
- Data Verification and Quality Control (12 tools): Multi-level quality inspection, intelligent cleaning
- Excel Formula Handling (5 tools): Formula parsing, compiling, execution, verification
🏗️ Dual-Engine Architecture
- Python engine: Based on traditional processing methods like pandas/openpyxl, supports complex data analysis
- Go Engine: High-performance concurrency processing, suitable for large-scale data processing (optional)
🧮 Excel Formula Engine (New)
- Formula Analysis: AST syntax analysis and security validation, supporting complex nested formulas
- Formula Compilation: Code generation and dependency analysis to optimize execution performance
- Formula Execution: Secure execution environment and result verification, supporting contextual computation
- Dependency Analysis: Dependency graph generation and loop detection to avoid computational deadlocks
- Formula Verification: Syntax checks and risk assessments to ensure formula safety
🔍 Data Quality Control (Enhanced)
- Multi-level Quality Inspection: Comprehensive verification of data completeness, consistency, and accuracy
- Intelligent Data Cleaning: Automate data cleaning and format standardization
- Batch Processing: Process multiple Excel files in parallel to improve efficiency
- Advanced Extraction: Multi-condition data extraction and content analysis
- Intelligent Merging: Merge and configure multi-table data
- Character Format Conversion: Automate character format conversion and rule configuration
🛡️ Enterprise-Level Security
- Code Safety: AST analysis and function whitelisting to prevent malicious code execution
- Execution Sandbox: Isolates the execution environment to protect system security
- Permission Control: Fine-grained access control and operation auditing
- Dependency Scanning: Intelligent dependency analysis and security vulnerability detection
⚡ Performance Optimization
- Smart Caching: Multi-level caching strategy to reduce redundant counting
- Concurrent Handling: Asynchronous task execution to speed up processing
- Memory Management: Large files are processed in chunks to optimize memory usage
- Error Recovery: Automatic retry mechanism and health monitoring
📋 Project Overview
This page was translated automatically. Technical details may differ from the original.
Install
docker run -d \