MCP.so
登录

Pandas MCP Server

@marlonluo2018

基本信息

分类

其他

许可证

MIT

传输方式

stdio

作者

marlonluo2018

关于 Pandas MCP Server

暂无概览

Pandas MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "pandas-mcp-server": {
      "command": "python",
      "args": [
        "cli.py"
      ]
    }
  }
}

Pandas MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Pandas MCP Server?

A Model Context Protocol (MCP) server that enables LLMs to execute pandas code through a standardized workflow for data analysis and visualization. It provides secure, sandboxed code execution, intelligent data analysis, and interactive chart generation for AI assistants like Claude Desktop.

How to use Pandas MCP Server?

Clone the repository, install dependencies (pip install -r requirements.txt), optionally configure environment variables via .env, and then add a JSON entry to your Claude Desktop configuration (using uvx or python). Verify installation by running python cli.py or python server.py. The server exposes four MCP tools: read_metadata_tool, interpret_column_data, run_pandas_code_tool, and generate_chartjs_tool.

Key features of Pandas MCP Server

  • Sandboxed execution environment for security
  • Automatic file metadata extraction and analysis
  • Interactive Chart.js visualization generation
  • Intelligent memory optimization for large files
  • Easy integration with Claude Desktop
  • Command-line interface for testing and development

Use cases of Pandas MCP Server

  • Let an LLM explore and analyze CSV or Excel files
  • Generate interactive bar, line, or pie charts from data
  • Perform secure, guided data cleaning and transformation
  • Automate multi-step data analysis workflows with AI
  • Interpret categorical columns to improve filtering and aggregation

常见问题

1

What are the prerequisites to run Pandas MCP Server?

Python 3.10 or higher, pip package manager, and Git are required. Dependencies include `pandas>=2.0.0`, `fastmcp>=1.0.0`, `chardet>=5.0.0`, and `psutil`.

2

What file types does Pandas MCP Server support?

It supports CSV (`.csv`) and Excel (`.xlsx`, `.xls`) files. Excel files can optionally specify a sheet name or index.

3

What tools does the server expose to LLMs?

Four tools: `read_metadata_tool` (file analysis), `interpret_column_data` (column value interpretation), `run_pandas_code_tool` (code execution), and `generate_chartjs_tool` (chart generation).

4

How do I configure Pandas MCP Server with Claude Desktop?

Add a JSON entry with type `"stdio"` and either `"uvx"` (recommended) or `"python"` as the command, pointing to the server directory or `server.py`. The configuration file is located in `%APPDATA%\Claude\claude_desktop_config.json` (Windows), `~/Library/Application Support/Claude/claude_desktop_config.json` (macOS), or `~/.config/Claude/claude_desktop_config.json` (Linux).

5

Is code execution secure in Pandas MCP Server?

Yes, code runs in a sandboxed environment that prevents malicious operations and protects system security.

评论

其他 分类下的更多 MCP 服务器