What is Claude Mcp Data Explorer

Claude MCP Data Explorer is a TypeScript implementation of a Model Context Protocol (MCP) server designed for data exploration with Claude. It integrates with Claude Desktop, enabling advanced data analysis through tools for loading CSV files and executing JavaScript data analysis scripts.

Use cases

Use cases include analyzing sales trends by region, exploring customer behavior data, and conducting market research by processing large datasets efficiently.

How to use

To use Claude MCP Data Explorer, first install Node.js and Claude Desktop. Clone the repository, install dependencies, and run the setup script. After restarting Claude Desktop and enabling Developer Mode, select the ‘Explore Data’ prompt template, enter the CSV file path and exploration topic, and let Claude analyze the data.

Key features

Key features include the ability to load CSV data into memory for analysis, execute JavaScript code for data processing, and a prompt template that guides users through a structured data exploration process.

Where to use

Claude MCP Data Explorer can be used in various fields such as data analysis, business intelligence, research, and any domain that requires data exploration and insights generation from CSV files.

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

Installation (Updated for Windows)

1. Clone this repository

   git clone https://github.com/tofunori/claude-mcp-data-explorer.git
   cd claude-mcp-data-explorer
   

2. Install dependencies

   npm install
   

3. Build and run setup script

   npm run setup
   

   This will:

   • Build the TypeScript code to JavaScript
   • Configure Claude Desktop to use the compiled JavaScript
   • Create necessary directories

4. 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 start

The 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:

1. load-csv - Loads CSV data into memory for analysis
2. 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

1. Start Claude Desktop

2. Select the “Explore Data” prompt template

   • This prompt will appear in Claude Desktop after setup

3. Enter CSV file path and exploration topic

   • Example file path: C:/Users/YourName/Documents/data.csv
   • Example topic: “Sales trends by region”

4. Let Claude analyze your data

   • Claude will load the CSV file and generate insights automatically
   • The server handles large files efficiently using chunking

Troubleshooting

1. Claude doesn’t show the MCP server

   • Check the configuration file at %APPDATA%\Claude\claude_desktop_config.json
   • It should point to the compiled JavaScript file in the dist directory
   • Try rebuilding the project with npm run build
   • Enable Developer Mode and check the MCP Log File (Developer → Open MCP Log File)
   • Use Developer → Reload All MCP Servers to force refresh

2. Permission errors reading files

   • Make sure Claude has access to the CSV file location
   • Try using absolute paths with forward slashes (/) or escaped backslashes (\\)

3. 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