A powerful Model Context Protocol (MCP) server that enables Claude Desktop to execute Python code, create visualizations, analyze Excel files, and perform file operations.
Run the setup script:
setup.batThis will:
- Create a virtual environment
- Install all dependencies
- Configure Claude Desktop
Update Claude Desktop config (if needed):
update_claude_config.batmcp_python/
├── mcp_python_server/ # Server implementation
├── examples/ # Usage examples and sample data
├── tests/ # Test scripts
├── docs/ # Documentation
├── scripts/ # Runtime scripts (created by server)
├── outputs/ # Generated outputs (created by server)
├── README.md # This file
└── setup.bat # Setup script
Transform Excel data into beautiful visualizations with natural language prompts.
Data: small_business_sales_2023_2024.xlsx
Prompt:
Analyze the small business sales data and create visualizations showing:
- Monthly revenue trends comparing 2023 vs 2024
- Product category performance breakdown
- Regional sales distribution
Output:
Data: Multiple campaign CSV files in examples/data/
- Q1_Email_Marketing_Campaign.csv
- Q1_Social_Media_Campaign.csv
- Q2_Email_Marketing_Campaign.csv
- Q2_PPC_Campaign.csv
- Q2_Influencer_Campaign.csv
- Q2_Social_Media_Campaign.csv
Prompt:
Compare all marketing campaigns across Q1 and Q2:
- Show campaign performance metrics (CTR, conversion rate, ROI)
- Compare different campaign types
- Identify best performing channels
Output:
Data: Lab experiment Excel files
- experiment_1_temperature_enzyme_activity.xlsx
- experiment_2_pH_enzyme_activity.xlsx
- experiment_3_substrate_concentration.xlsx
Prompt:
Analyze the enzyme activity experiments:
- Show how temperature affects enzyme activity
- Compare pH impact on enzyme performance
- Visualize substrate concentration effects
Output:
For detailed usage examples and prompts:
- Excel Visualization Guide - Complete guide for Excel file analysis
- Data Visualization Examples - Creating charts with matplotlib, pandas, and seaborn
- File Operations Guide - Reading and writing files
Execute Python code with support for:
- NumPy, Pandas, Matplotlib, Seaborn
- Data analysis and scientific computing
- Custom libraries and packages
- Analyze Excel file structure
- Load and process Excel data
- Create visualizations directly from Excel files
- Support for multiple sheets and complex data
- Read/write single or multiple files
- Pattern matching (*.py, *.json, etc.)
- Recursive directory operations
- Batch file processing
- Create charts with Matplotlib
- Statistical plots with Seaborn
- Pandas built-in plotting
- Multiple chart types (line, bar, scatter, heatmap, etc.)
Usage Documentation:
- Examples Guide - Real-world examples with sample data
- File Operations Guide - Complete file operations reference
- Quick Start: File Operations - Fast-track guide
- Testing Guide - Testing and validation
Technical Documentation:
- Setup Guide - Installation and configuration
- Technical Details - Architecture and internals
- Performance Optimization - Performance tuning
Run tests:
cd tests
test_server.bat-
Claude Desktop not recognizing server
- Run
update_claude_config.bat - Restart Claude Desktop
- Run
-
Missing dependencies
- Run
install_requirements.bat - Or:
install_viz_dependencies.batfor visualization libraries
- Run
-
File access issues
- Check file paths are correct
- Ensure proper permissions
User: "Calculate the factorial of 10"
Claude: [Executes Python code and returns result]
User: "Analyze sales_data.xlsx and show monthly trends"
Claude: [Reads Excel file, creates visualization]
User: "Read all Python files in the src folder"
Claude: [Reads multiple files and shows content]
User: "Create a bar chart comparing Q1 vs Q2 sales"
Claude: [Generates and displays chart]
This server is designed to work seamlessly with Claude Desktop. Simply describe what you want to do in natural language, and Claude will use the appropriate tools automatically.
MIT License - see LICENSE file for details
Ready to get started? Run setup.bat and start analyzing data with Claude!