Skip to main content
Glama
mcp-server-data-exploration

mcp-server-data-exploration

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.

πŸš€ 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")

Related MCP server: MCP Tabular Data Analysis Server

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

Watch the video

Case 2: Weather in London

πŸ“¦ 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.

Available Tools

2 tools
load_csvB

Load CSV File Tool

Purpose: Load a local CSV file into a DataFrame.

Usage Notes: β€’ If a df_name is not provided, the tool will automatically assign names sequentially as df_1, df_2, and so on.

Inputs: csv_path (required), df_name.

run_scriptB

Python Script Execution Tool

Purpose: Execute Python scripts for specific data analytics tasks.

Allowed Actions 1. Print Results: Output will be displayed as the script’s stdout. 2. [Optional] Save DataFrames: Store DataFrames in memory for future use by specifying a save_to_memory name.

Prohibited Actions 1. Overwriting Original DataFrames: Do not modify existing DataFrames to preserve their integrity for future tasks. 2. Creating Charts: Chart generation is not permitted.

Inputs: script (required), save_to_memory.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.2/5.0

    Scored across 2 tools

    Disambiguation5/5

    The two tools have clearly distinct purposes: load_csv is for loading CSV files into DataFrames, while run_script is for executing Python scripts for data analytics tasks. There is no overlap in functionality, and an agent would easily distinguish between them.

    Naming Consistency4/5

    Both tools use snake_case naming, which is consistent, but they follow different patterns: load_csv uses a verb_noun format, while run_script uses verb_noun as well but with a more generic noun. This minor deviation keeps it mostly consistent but not perfectly aligned.

    Tool Count2/5

    With only two tools, the server feels severely under-scoped for data exploration. Key operations like data transformation, filtering, aggregation, or visualization are missing, making it incomplete for typical data analysis workflows.

    Completeness2/5

    The tool set is highly incomplete for data exploration. It covers only loading data and running scripts, with no tools for common tasks like data cleaning, analysis, or exporting results. This will likely cause agent failures when trying to perform comprehensive data exploration.

    Maintenance

    ActivityInactive
    ResponsivenessLimited data

    Related MCP Connectors

    Related MCP Servers