Claude MCP Data Explorer
Hosts the repository for the MCP data explorer, allowing users to clone the codebase from GitHub to set up the service.
Supports running JavaScript code for data processing and analysis through the run-script tool, allowing Claude to execute custom data analysis logic.
Enables execution of JavaScript data analysis scripts within the MCP environment, supporting data processing and analysis of loaded CSV files.
Implements the MCP server using TypeScript, providing type-safe integration with Claude Desktop for data exploration capabilities.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Claude MCP Data Explorer load sales_data.csv and show me the top 5 products by revenue"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Claude MCP Data Explorer for Windows
A TypeScript implementation of a Model Context Protocol (MCP) server for data exploration with Claude. This server integrates with Claude Desktop and enables advanced data analysis by providing tools to load CSV files and execute JavaScript data analysis scripts.
Prerequisites
Node.js v16+ - Download Node.js
Claude Desktop - Download Claude Desktop
Related MCP server: mcp-csv-analyst
Installation (Updated for Windows)
Clone this repository
git clone https://github.com/tofunori/claude-mcp-data-explorer.git cd claude-mcp-data-explorerInstall dependencies
npm installBuild and run setup script
npm run setupThis will:
Build the TypeScript code to JavaScript
Configure Claude Desktop to use the compiled JavaScript
Create necessary directories
Restart Claude Desktop and enable Developer Mode
Close Claude Desktop completely
Start Claude Desktop
Go to Help → Enable Developer Mode
Manual Testing
You can test the server directly by running:
npm run build
npm run startThe server should start without errors. If you can run this successfully, Claude Desktop should be able to use the server as well.
How It Works
This MCP server provides two main tools for Claude:
load-csv - Loads CSV data into memory for analysis
run-script - Executes JavaScript code for data processing and analysis
It also includes a prompt template that guides Claude through a structured data exploration process.
Usage
Start Claude Desktop
Select the "Explore Data" prompt template
This prompt will appear in Claude Desktop after setup
Enter CSV file path and exploration topic
Example file path:
C:/Users/YourName/Documents/data.csvExample topic: "Sales trends by region"
Let Claude analyze your data
Claude will load the CSV file and generate insights automatically
The server handles large files efficiently using chunking
Troubleshooting
Claude doesn't show the MCP server
Check the configuration file at
%APPDATA%\Claude\claude_desktop_config.jsonIt should point to the compiled JavaScript file in the dist directory
Try rebuilding the project with
npm run buildEnable Developer Mode and check the MCP Log File (Developer → Open MCP Log File)
Use Developer → Reload All MCP Servers to force refresh
Permission errors reading files
Make sure Claude has access to the CSV file location
Try using absolute paths with forward slashes (
/) or escaped backslashes (\\)
JavaScript errors in scripts
Check that your script is compatible with the allowed modules
Review any error messages in Claude's response
License
MIT License - see LICENSE file for details.
Acknowledgments
Based on the official MCP TypeScript SDK from Anthropic
Thanks to the MCP community for examples and inspiration
Available Tools
2 toolsload-csvC
Load a CSV file into a DataFrame for analysis
Inputs: csv_path (required), df_name.
run-scriptC
Execute a JavaScript script for data analysis and visualization
Inputs: script (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
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.
Hosted BigQuery MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
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-