mcp-server-data-exploration

MCP.Pizza Chef: reading-plus-ai

The mcp-server-data-exploration is a versatile MCP server designed to facilitate interactive data exploration. Acting as a personal Data Scientist assistant, it helps users transform complex datasets, such as CSV files, into clear, actionable insights. By integrating with tools like Claude Desktop, it allows users to load data templates and tools seamlessly, enabling efficient exploration of topics within datasets. This server supports real-time interaction, making it ideal for data analysis, pattern recognition, and insight generation in various domains.

Use This MCP server To

Explore CSV datasets interactively Analyze data patterns and trends Generate actionable insights from data Assist in data-driven decision making Integrate with Claude Desktop for data tasks Load and use data exploration templates Support real-time data query and analysis

README

MCP Server for Data Exploration

MCP Server is a versatile tool designed for interactive data exploration.

Your personal Data Scientist assistant, turning complex datasets into clear, actionable insights.

mcp-server-data-exploration MCP server

🚀 Try it Out

  1. Download Claude Desktop

  2. Install and Set Up

    • On macOS, run the following command in your terminal:
    python setup.py
  3. Load Templates and Tools

    • Once the server is running, wait for the prompt template and tools to load in Claude Desktop.
  4. Start Exploring

    • Select the explore-data prompt template from MCP
    • Begin your conversation by providing the required inputs:
      • csv_path: Local path to the CSV file
      • topic: The topic of exploration (e.g., "Weather patterns in New York" or "Housing prices in California")

Examples

These are examples of how you can use MCP Server to explore data without any human intervention.

Case 1: California Real Estate Listing Prices

  • Kaggle Dataset: USA Real Estate Dataset
  • Size: 2,226,382 entries (178.9 MB)
  • Topic: Housing price trends in California

Watch the video

Case 2: Weather in London

Screenshot 2024-12-09 at 12 48 56 AM Screenshot 2024-12-09 at 12 47 54 AM Screenshot 2024-12-09 at 12 47 00 AM

📦 Components

Prompts

  • explore-data: Tailored for data exploration tasks

Tools

  1. load-csv

    • Function: Loads a CSV file into a DataFrame
    • Arguments:
      • csv_path (string, required): Path to the CSV file
      • df_name (string, optional): Name for the DataFrame. Defaults to df_1, df_2, etc., if not provided
  2. run-script

    • Function: Executes a Python script
    • Arguments:
      • script (string, required): The script to execute

⚙️ Modifying the Server

Claude Desktop Configurations

  • macOS: ~/Library/Application\ Support/Claude/claude_desktop_config.json
  • Windows: %APPDATA%/Claude/claude_desktop_config.json

Development (Unpublished Servers)

"mcpServers": {
  "mcp-server-ds": {
    "command": "uv",
    "args": [
      "--directory",
      "/Users/username/src/mcp-server-ds",
      "run",
      "mcp-server-ds"
    ]
  }
}

Published Servers

"mcpServers": {
  "mcp-server-ds": {
    "command": "uvx",
    "args": [
      "mcp-server-ds"
    ]
  }
}

🛠️ Development

Building and Publishing

  1. Sync Dependencies

    uv sync
  2. Build Distributions

    uv build

    Generates source and wheel distributions in the dist/ directory.

  3. Publish to PyPI

    uv publish

🤝 Contributing

Contributions are welcome! Whether you're fixing bugs, adding features, or improving documentation, your help makes this project better.

Reporting Issues

If you encounter bugs or have suggestions, open an issue in the issues section. Include:

  • Steps to reproduce (if applicable)
  • Expected vs. actual behavior
  • Screenshots or error logs (if relevant)

📜 License

This project is licensed under the MIT License. See the LICENSE file for details.

💬 Get in Touch

Questions? Feedback? Open an issue or reach out to the maintainers. Let's make this project awesome together!

About

This is an open source project run by ReadingPlus.AI LLC. and open to contributions from the entire community.

mcp-server-data-exploration FAQ

How do I set up the mcp-server-data-exploration?
Download Claude Desktop, run 'python setup.py' on macOS, then load templates and tools in Claude Desktop.
What input formats does the server support?
Primarily CSV files via local file paths for data exploration.
Can I use this server with other LLM providers besides Claude?
Yes, it is compatible with OpenAI, Claude, Gemini, and other MCP-compliant LLMs.
How do I start a data exploration session?
Select the 'explore-data' prompt template and provide inputs like 'csv_path' and 'topic' to begin.
Is the server suitable for large datasets?
It is optimized for interactive exploration but performance depends on dataset size and system resources.
Can I customize the exploration templates?
Yes, templates and tools can be modified to fit specific data analysis needs.
Does the server support real-time interaction?
Yes, it enables real-time querying and analysis of datasets during sessions.
What platforms is the server compatible with?
It runs on macOS and can be adapted for other platforms supporting Python and MCP.