Claude MCP Data Explorer
Claude MCP 数据浏览器(Windows 版)
一个使用 TypeScript 实现的模型上下文协议 (MCP) 服务器,用于使用 Claude 进行数据探索。该服务器与 Claude Desktop 集成,并通过提供加载 CSV 文件和执行 JavaScript 数据分析脚本的工具来实现高级数据分析。
先决条件
Node.js v16+ -下载 Node.js
克劳德桌面 -下载克劳德桌面
Related MCP server: mcp-csv-analyst
安装(针对 Windows 进行了更新)
克隆此存储库
git clone https://github.com/tofunori/claude-mcp-data-explorer.git cd claude-mcp-data-explorer安装依赖项
npm install构建并运行安装脚本
npm run setup这将:
将 TypeScript 代码构建为 JavaScript
配置 Claude Desktop 以使用已编译的 JavaScript
创建必要的目录
重启 Claude Desktop 并启用开发者模式
完全关闭 Claude Desktop
启动 Claude Desktop
前往“帮助”→“启用开发者模式”
手动测试
您可以通过运行以下命令直接测试服务器:
npm run build
npm run start服务器应该可以正常启动。如果运行成功,Claude Desktop 应该也能使用该服务器。
工作原理
该 MCP 服务器为 Claude 提供了两个主要工具:
load-csv - 将 CSV 数据加载到内存中进行分析
run-script - 执行 JavaScript 代码进行数据处理和分析
它还包括一个提示模板,指导 Claude 完成结构化数据探索过程。
用法
启动 Claude Desktop
选择“探索数据”提示模板
安装完成后,Claude Desktop 中会出现此提示
输入CSV文件路径和探索主题
示例文件路径:
C:/Users/YourName/Documents/data.csv示例主题:“各地区的销售趋势”
让 Claude 分析您的数据
Claude 将加载 CSV 文件并自动生成见解
服务器使用分块高效处理大文件
故障排除
Claude 没有显示 MCP 服务器
检查
%APPDATA%\Claude\claude_desktop_config.json处的配置文件它应该指向 dist 目录中已编译的 JavaScript 文件
尝试使用
npm run build重建项目启用开发者模式并检查 MCP 日志文件(开发者 → 打开 MCP 日志文件)
使用“开发人员”→“重新加载所有 MCP 服务器”强制刷新
读取文件的权限错误
确保 Claude 有权访问 CSV 文件位置
尝试使用带有正斜杠(
/)或转义反斜杠(\\)的绝对路径
脚本中的 JavaScript 错误
检查您的脚本是否与允许的模块兼容
查看 Claude 回复中的任何错误消息
执照
MIT 许可证 - 详情请参阅 LICENSE 文件。
致谢
基于 Anthropic 的官方 MCP TypeScript SDK
感谢 MCP 社区提供的示例和灵感
Available Tools
2 toolsload-csvC
Load a CSV file into a DataFrame for analysis
| Name | Required | Description | Default |
|---|---|---|---|
| csv_path | Yes | Path to the CSV file to load | |
| df_name | No | Name for the DataFrame (optional, defaults to df_1, df_2, etc.) |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description carries the full burden of behavioral disclosure. It states the action 'load a CSV file into a DataFrame' but lacks details on permissions needed, error handling (e.g., invalid paths), rate limits, or what happens after loading (e.g., memory usage, persistence). For a tool with no annotation coverage, this is a significant gap.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, efficient sentence that front-loads the core action ('Load a CSV file') and purpose ('for analysis'). There is zero waste, making it highly concise and well-structured for quick understanding.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given no annotations, no output schema, and a tool that performs data loading (a potentially complex operation with file I/O), the description is incomplete. It doesn't cover behavioral aspects like error conditions, return values, or dependencies, leaving gaps for an AI agent to use it correctly in varied contexts.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 100%, so the schema already documents both parameters (csv_path and df_name) with clear descriptions. The description adds no additional meaning beyond implying CSV loading for analysis, which aligns with the schema but doesn't provide extra syntax or format details. Baseline 3 is appropriate when the schema does the heavy lifting.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the verb 'load' and resource 'CSV file', specifying it's for analysis via a DataFrame. It distinguishes from the sibling 'run-script' by focusing on data loading rather than script execution. However, it doesn't explicitly differentiate from potential other data loading tools (none listed), keeping it at 4.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance is provided on when to use this tool versus alternatives. The description implies it's for loading CSV files into DataFrames, but there's no mention of prerequisites (e.g., file accessibility), when not to use it (e.g., for non-CSV files), or alternatives like 'run-script' for other data processing. This leaves usage context vague.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
run-scriptC
Execute a JavaScript script for data analysis and visualization
| Name | Required | Description | Default |
|---|---|---|---|
| script | Yes | JavaScript script to execute |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description carries the full burden of behavioral disclosure. It states the tool executes a JavaScript script but doesn't describe safety aspects (e.g., sandboxing, permissions), performance traits (e.g., execution time limits, resource usage), or what happens upon execution (e.g., output format, side effects). For a tool that runs arbitrary code with no annotation coverage, this is a significant gap.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, efficient sentence that directly states the tool's purpose without unnecessary words. It is appropriately sized and front-loaded, with every part contributing essential information (verb, resource, domain).
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the complexity of executing arbitrary JavaScript code, the lack of annotations, and no output schema, the description is incomplete. It doesn't address critical aspects like security implications, error handling, or what the tool returns (e.g., visualization output, analysis results). For a tool with such potential impact, more context is needed.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The input schema has 100% description coverage, with one parameter 'script' fully documented in the schema. The description adds no additional meaning about parameters beyond what the schema provides (e.g., no examples of script content, no constraints on JavaScript features). With high schema coverage, the baseline score of 3 is appropriate as the description doesn't compensate but doesn't detract either.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose with a specific verb ('Execute') and resource ('JavaScript script'), and specifies the domain ('for data analysis and visualization'). It doesn't distinguish from the sibling tool 'load-csv', which appears to be a different operation, so it doesn't explicitly differentiate from siblings.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives. It mentions the domain (data analysis and visualization) but doesn't specify prerequisites, limitations, or when not to use it. There's no explicit comparison with the sibling tool 'load-csv' or other potential tools.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
2 tool updates
- First observed
load-csv - First observed
run-script
TDQS
Scored across 2 tools
The two tools have clearly distinct purposes: one loads CSV data into a DataFrame, while the other executes JavaScript scripts for analysis and visualization. There is no overlap or ambiguity between these functions, making it easy for an agent to select the correct tool.
Both tools use a verb-noun pattern (load-csv, run-script), which is consistent and readable. The hyphenated style is maintained throughout, though the specific convention (hyphens vs. underscores) is less important than the consistency, which is good here with only minor deviations from common patterns.
With only two tools, the server feels thin for a 'Data Explorer' purpose, as it lacks essential operations like data querying, filtering, transformation, or exporting. While the tools are functional, the count is too low to adequately cover the expected scope of data exploration and analysis.
For a data exploration server, there are significant gaps: no tools for querying data, filtering, aggregating, visualizing beyond scripts, or exporting results. The surface is severely incomplete, as agents cannot perform basic data exploration tasks without relying heavily on external scripts, leading to potential failures in common workflows.
Maintenance
Related MCP Connectors
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yo…
Query, join, profile, clean and convert CSV/JSON/Parquet with server-side DuckDB over MCP.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
Augments MCP Server - A comprehensive framework documentation provider for Claude Code
Related MCP Servers
- -licenseNot gradedqualityNot gradedmaintenanceA Model Context Protocol server that analyzes customer cancellation survey data, enabling Claude AI integration through HTTP/SSE transport.-
- AlicenseAqualityNot gradedmaintenanceAn MCP server that enables AI assistants to load, query, and analyze local CSV files using tools for filtering, aggregation, and grouping. It provides capabilities to describe schemas, calculate statistics, and sample data directly from CSV files.6-
- FlicenseNot gradedqualityDmaintenanceA local MCP server for analyzing CSV files from your filesystem, particularly suited for chatbot conversation logs. Allows listing, reading, filtering, merging, and statistical analysis of CSV data via natural language.-
- FlicenseAqualityDmaintenanceAn MCP server for dataset exploration and analysis, enabling LLM clients to perform summary, correlation, distribution, missing value analysis, data cleaning, and statistical tests directly on CSV files.3-