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.

Prerequisites

• uv
• Any MCP clients. There are many available, check out @punkpeye/awesome-mcp-clients

Configuration

{
  "mcpServers": {
    "data-explore": {
      "command": "uvx",
      "args": [
        "--from",
        "git+https://github.com/scottoasis/mcp-server-data-exploration",
        "mcp-server-ds"
      ]
    }
  }
}

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

• Data Exploration Summary

Case 2: Weather in London

• Kaggle Dataset: 2M+ Daily Weather History UK
• Size: 2,836,186 entries (169.3 MB)
• Topic: Weather in London
• Report: View Report
• Graphs:
  • London Temperature Trends

• Temperature-Humidity Relationship by Season

• Wind Direction Pattern by Season

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