The CSV Editor server provides AI-powered tools for comprehensive CSV data manipulation, analysis, and validation with robust session management and history tracking.
Core Capabilities:
Data Loading & Export: Load CSV data from files, URLs, or string content; export to CSV, JSON, Excel, Parquet, HTML, and Markdown formats
Data Manipulation: Filter, sort, select, rename, add, remove, update, and transform columns; change data types and handle missing values
Data Analysis: Generate statistics, calculate correlations, group by with aggregation, value counts, outlier detection, and comprehensive data profiling
Data Quality: Remove duplicates, validate against schemas, quality assurance checks, and anomaly detection
Session Management: Multi-user support with isolated sessions, creation, listing, and cleanup capabilities
History & Auto-Save: Full undo/redo functionality, operation tracking, restore points, and configurable auto-save strategies (overwrite, backup, versioned, custom)
Server Utilities: Health status monitoring and capability information
Supports exporting CSV data to Markdown format for documentation and reporting purposes
Leverages NumPy for advanced numerical computing operations on CSV data including statistical analysis and mathematical transformations
Provides comprehensive CSV data manipulation capabilities including filtering, cleaning, statistical analysis, and transformation operations using pandas as the core data processing engine
CSV Editor - AI-Powered CSV Processing via MCP
Transform how AI assistants work with CSV data. CSV Editor is a high-performance MCP server that gives Claude, ChatGPT, and other AI assistants powerful data manipulation capabilities through simple commands.
🎯 Why CSV Editor?
The Problem
AI assistants struggle with complex data operations - they can read files but lack tools for filtering, transforming, analyzing, and validating CSV data efficiently.
The Solution
CSV Editor bridges this gap by providing AI assistants with 40+ specialized tools for CSV operations, turning them into powerful data analysts that can:
- Clean messy datasets in seconds
- Perform complex statistical analysis
- Validate data quality automatically
- Transform data with natural language commands
- Track all changes with undo/redo capabilities
Key Differentiators
Feature | CSV Editor | Traditional Tools |
---|---|---|
AI Integration | Native MCP protocol | Manual operations |
Auto-Save | Automatic with strategies | Manual save required |
History Tracking | Full undo/redo with snapshots | Limited or none |
Session Management | Multi-user isolated sessions | Single user |
Data Validation | Built-in quality scoring | Separate tools needed |
Performance | Handles GB+ files with chunking | Memory limitations |
⚡ Quick Demo
🚀 Quick Start (2 minutes)
Installing via Smithery
To install csv-editor for Claude Desktop automatically via Smithery:
Fastest Installation (Recommended)
Configure Your AI Assistant
Add to ~/Library/Application Support/Claude/claude_desktop_config.json
(macOS):
See MCP_CONFIG.md for detailed configuration.
💡 Real-World Use Cases
📊 Data Analyst Workflow
🏭 ETL Pipeline
🔍 Data Quality Assurance
🎨 Core Features
Data Operations
- Load & Export: CSV, JSON, Excel, Parquet, HTML, Markdown
- Transform: Filter, sort, group, pivot, join
- Clean: Remove duplicates, handle missing values, fix types
- Calculate: Add computed columns, aggregations
Analysis Tools
- Statistics: Descriptive stats, correlations, distributions
- Outliers: IQR, Z-score, custom thresholds
- Profiling: Complete data quality reports
- Validation: Schema checking, quality scoring
Productivity Features
- Auto-Save: Never lose work with configurable strategies
- History: Full undo/redo with operation tracking
- Sessions: Multi-user support with isolation
- Performance: Stream processing for large files
📚 Available Tools
I/O Operations
load_csv
- Load from fileload_csv_from_url
- Load from URLload_csv_from_content
- Load from stringexport_csv
- Export to various formatsget_session_info
- Session detailslist_sessions
- Active sessionsclose_session
- Cleanup
Data Manipulation
filter_rows
- Complex filteringsort_data
- Multi-column sortselect_columns
- Column selectionrename_columns
- Rename columnsadd_column
- Add computed columnsremove_columns
- Remove columnsupdate_column
- Update valueschange_column_type
- Type conversionfill_missing_values
- Handle nullsremove_duplicates
- Deduplicate
Analysis
get_statistics
- Statistical summaryget_column_statistics
- Column statsget_correlation_matrix
- Correlationsgroup_by_aggregate
- Group operationsget_value_counts
- Frequency countsdetect_outliers
- Find outliersprofile_data
- Data profiling
Validation
validate_schema
- Schema validationcheck_data_quality
- Quality metricsfind_anomalies
- Anomaly detection
Auto-Save & History
configure_auto_save
- Setup auto-saveget_auto_save_status
- Check statusundo
/redo
- Navigate historyget_history
- View operationsrestore_to_operation
- Time travel
⚙️ Configuration
Environment Variables
Variable | Default | Description |
---|---|---|
CSV_MAX_FILE_SIZE | 1GB | Maximum file size |
CSV_SESSION_TIMEOUT | 3600s | Session timeout |
CSV_CHUNK_SIZE | 10000 | Processing chunk size |
CSV_AUTO_SAVE | true | Enable auto-save |
Auto-Save Strategies
CSV Editor automatically saves your work with configurable strategies:
- Overwrite (default) - Update original file
- Backup - Create timestamped backups
- Versioned - Maintain version history
- Custom - Save to specified location
🛠️ Advanced Installation Options
Using pip
Using pipx (Global)
From GitHub (Recommended)
🧪 Development
Running Tests
Project Structure
🤝 Contributing
We welcome contributions! See CONTRIBUTING.md for guidelines.
Quick Contribution Guide
- Fork the repository
- Create a feature branch
- Make your changes with tests
- Run
uv run all-checks
- Submit a pull request
📈 Roadmap
- SQL query interface
- Real-time collaboration
- Advanced visualizations
- Machine learning integrations
- Cloud storage support
- Performance optimizations for 10GB+ files
💬 Support
- Issues: GitHub Issues
- Discussions: GitHub Discussions
- Documentation: Wiki
📄 License
MIT License - see LICENSE file
🙏 Acknowledgments
Built with:
Ready to supercharge your AI's data capabilities? Get started in 2 minutes →
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
Tools
Comprehensive CSV processing MCP server with 40+ operations for data manipulation, analysis, and validation. Features auto-save, undo/redo, and handles GB+ files
Related MCP Servers
- AsecurityFlicenseAqualityAn MCP server that provides comprehensive Excel file operations, data analysis, and visualization capabilities for working with various spreadsheet formats like XLSX, CSV, and JSON.Last updated -865
- -securityAlicense-qualityAn MCP server that manages chunking and reading of large responses, allowing tools to handle oversized data that would otherwise fail.Last updated -2GPL 3.0
- -securityFlicense-qualityAn MCP server that provides comprehensive PDF processing capabilities including text extraction, image extraction, table detection, annotation extraction, metadata retrieval, page rendering, and document structure analysis.Last updated -
- -securityFlicense-qualityAn MCP server that allows LLMs to read, analyze, and interact with Excel files through file operations, data discovery, and comprehensive analysis tools.Last updated -1