csv-editor

概述

CSV Editor是一个全面的MCP服务器，通过39个专业工具为AI助手提供完整的CSV编辑功能。它基于FastMCP 3构建，使用pandas驱动，支持有状态的CSV操作，具有会话管理、撤销/重做功能和可配置的自动保存策略等高级特性。与只读数据MCP不同，此服务器专注于让AI能够实际修改CSV数据，并提供适当的跟踪和历史管理功能。它支持多种输入/输出格式，包括CSV、JSON、Excel、Parquet、HTML和Markdown文件。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• load_csv

  Load CSV data from a file

  试试:Load sales.csv试试:Load customer_data.csv
• filter_rows

  Filter rows based on conditions

  试试:Filter rows where status is active试试:Show transactions greater than $1000
• get_statistics

  Get statistical summary of data

  试试:Calculate statistics for revenue column试试:Show descriptive statistics for the dataset
• add_column

  Add computed columns to the dataset

  试试:Add a profit column as revenue minus cost试试:Create a full_name column combining first and last name
• export_csv

  Export data to various formats

  试试:Export to Excel format试试:Save the data as a JSON file
• remove_duplicates

  Remove duplicate rows from the dataset

  试试:Remove duplicate entries based on email试试:Clean the data by removing duplicates
• fill_missing_values

  Handle missing values in the dataset

  试试:Fill missing values with the mean试试:Replace nulls in the age column with zero
• get_correlation_matrix

  Calculate correlation between columns

  试试:Find correlation between price and quantity试试:Show correlation matrix for numeric columns
• group_by_aggregate

  Group data and perform aggregations

  试试:Group by region and sum sales试试:Calculate average price per category
• detect_outliers

  Detect outliers in the data

  试试:Find outliers in the sales column试试:Detect anomalies using IQR method
• undo

  Undo the last operation

  试试:Undo the last change试试:Revert the previous operation
• check_data_quality

  Check data quality and generate a report

  试试:Analyze data quality issues试试:Check for missing values and duplicates

可对比工具

安装

npx -y @smithery/cli install @santoshray02/csv-editor --client claude

# 如果需要，安装uv（一次性设置）
curl -LsSf https://astral.sh/uv/install.sh | sh

# 克隆并运行
git clone https://github.com/santoshray02/csv-editor.git
cd csv-editor
uv sync
uv run csv-editor

{
  "mcpServers": {
    "csv-editor": {
      "command": "uv",
      "args": ["tool", "run", "csv-editor"],
      "env": {
        "CSV_MAX_FILE_SIZE": "1073741824"
      }
    }
  }
}

FAQ

CSV Editor与其他CSV/数据MCP服务器有何不同？

CSV Editor专注于有状态编辑，具有会话管理、撤销/重做功能和自动保存功能，而大多数其他CSV MCP服务器是只读或单次分析工具。

CSV Editor支持哪些文件格式？

它支持CSV、JSON、Excel、Parquet、HTML和Markdown的输入和输出操作，使其能够满足不同的数据处理需求。

csv-editor 对比