MCP Analyst logo

MCP Analyst

by unravel-team

MCP Analyst is an MCP server that empowers Claude to analyze local CSV or Parquet files. It's designed for datasets larger than Claude's context window or when you want to avoid uploading the entire file to optimize costs.

View on GitHub

Last updated: N/A

What is MCP Analyst?

MCP Analyst is a server that allows Claude to analyze CSV or Parquet files stored locally on your machine. It acts as an intermediary, enabling Claude to process data without needing to upload the entire file, which is beneficial for large datasets or cost optimization.

How to use MCP Analyst?

  1. Install uv. 2. Update the Claude config file (claude_desktop_config.json) to include the MCP Analyst server configuration, specifying the command to run the server and the file location (or glob pattern) of your CSV or Parquet files. Ensure you replace <replace_this_with_path_to_csv_or_parquet_files_on_your_machine> with the correct path. 3. Start the MCP Analyst server.

Key features of MCP Analyst

  • Analyze local CSV/Parquet files

  • Handles datasets larger than Claude's context window

  • Cost optimization by avoiding full file uploads

  • Supports glob patterns for multiple files

  • Integration with Claude via MCP

Use cases of MCP Analyst

  • Analyzing large CSV datasets with Claude

  • Analyzing Parquet datasets with Claude

  • Data analysis without uploading sensitive data

  • Cost-effective data analysis with Claude

  • Analyzing multiple CSV files at once

FAQ from MCP Analyst

How do I install uv?

Use brew install uv on Mac or winget install --id=astral-sh.uv -e on Windows.

Where is the Claude config file located?

On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json. On Windows: %APPDATA%/Claude/claude_desktop_config.json

How do I specify the file location?

In the Claude config file, replace <replace_this_with_path_to_csv_or_parquet_files_on_your_machine> with the path to your CSV or Parquet file(s).

Can I provide more than one CSV file?

Yes, the server supports using globs in the file location. For example, <parent_path_to_data>/data/*.csv.

What is MCP?

MCP stands for Multi-Cloud Processing. In this context, it refers to the mechanism by which Claude interacts with external servers like MCP Analyst.