MCP Server for Data Exploration

1# MCP Server for Data Exploration
2 
3MCP Server is a versatile tool designed for interactive data exploration.
4 
5Your personal Data Scientist assistant, turning complex datasets into clear, actionable insights.
6 
7<a href="https://glama.ai/mcp/servers/hwm8j9c422"><img width="380" height="200" src="https://glama.ai/mcp/servers/hwm8j9c422/badge" alt="mcp-server-data-exploration MCP server" /></a>
8 
9## 🚀 Try it Out
10 
111. **Download Claude Desktop**
12   - Get it [here](https://claude.ai/download)
13 
142. **Install and Set Up**
15   - On macOS, run the following command in your terminal:
16   ```bash
17   python setup.py
18   ```
19 
203. **Load Templates and Tools**
21   - Once the server is running, wait for the prompt template and tools to load in Claude Desktop.
22 
234. **Start Exploring**
24   - Select the explore-data prompt template from MCP
25   - Begin your conversation by providing the required inputs:
26     - `csv_path`: Local path to the CSV file
27     - `topic`: The topic of exploration (e.g., "Weather patterns in New York" or "Housing prices in California")
28 
29## Examples
30 
31These are examples of how you can use MCP Server to explore data without any human intervention.
32 
33### Case 1: California Real Estate Listing Prices
34- Kaggle Dataset: [USA Real Estate Dataset](https://www.kaggle.com/datasets/ahmedshahriarsakib/usa-real-estate-dataset)
35- Size: 2,226,382 entries (178.9 MB)
36- Topic: Housing price trends in California
37 
38[![Watch the video](https://img.youtube.com/vi/RQZbeuaH9Ys/hqdefault.jpg)](https://www.youtube.com/watch?v=RQZbeuaH9Ys)
39- [Data Exploration Summary](https://claude.site/artifacts/058a1593-7a14-40df-bf09-28b8c4531137)
40 
41### Case 2: Weather in London
42- Kaggle Dataset: [2M+ Daily Weather History UK](https://www.kaggle.com/datasets/jakewright/2m-daily-weather-history-uk/data)
43- Size: 2,836,186 entries (169.3 MB)
44- Topic: Weather in London
45- Report: [View Report](https://claude.site/artifacts/601ea9c1-a00e-472e-9271-3efafb8edede)
46- Graphs:
47  - [London Temperature Trends](https://claude.site/artifacts/9a25bc1e-d0cf-498a-833c-5179547ee268)
48<img width="1622" alt="Screenshot 2024-12-09 at 12 48 56 AM" src="https://github.com/user-attachments/assets/9e70fe97-8af7-4221-b1e7-00197c88bb47">
49 
50  - [Temperature-Humidity Relationship by Season](https://claude.site/artifacts/32a3371c-698d-48e3-b94e-f7e88ce8093d)
51<img width="1623" alt="Screenshot 2024-12-09 at 12 47 54 AM" src="https://github.com/user-attachments/assets/f4ac60a8-30e3-4b10-b296-ba412c2922fa">
52 
53  - [Wind Direction Pattern by Season](https://claude.site/artifacts/32a3371c-698d-48e3-b94e-f7e88ce8093d)
54<img width="1622" alt="Screenshot 2024-12-09 at 12 47 00 AM" src="https://github.com/user-attachments/assets/2db01054-f948-4d2e-ba39-8de8fa59f83d">
55 
56## 📦 Components
57 
58### Prompts
59- **explore-data**: Tailored for data exploration tasks
60 
61### Tools
621. **load-csv**
63   - Function: Loads a CSV file into a DataFrame
64   - Arguments:
65     - `csv_path` (string, required): Path to the CSV file
66     - `df_name` (string, optional): Name for the DataFrame. Defaults to df_1, df_2, etc., if not provided
67 
682. **run-script**
69   - Function: Executes a Python script
70   - Arguments:
71     - `script` (string, required): The script to execute
72 
73## ⚙️ Modifying the Server
74 
75### Claude Desktop Configurations
76- macOS: `~/Library/Application\ Support/Claude/claude_desktop_config.json`
77- Windows: `%APPDATA%/Claude/claude_desktop_config.json`
78 
79### Development (Unpublished Servers)
80```json
81"mcpServers": {
82  "mcp-server-ds": {
83    "command": "uv",
84    "args": [
85      "--directory",
86      "/Users/username/src/mcp-server-ds",
87      "run",
88      "mcp-server-ds"
89    ]
90  }
91}
92```
93 
94### Published Servers
95```json
96"mcpServers": {
97  "mcp-server-ds": {
98    "command": "uvx",
99    "args": [
100      "mcp-server-ds"
101    ]
102  }
103}
104```
105 
106## 🛠️ Development
107 
108### Building and Publishing
1091. **Sync Dependencies**
110   ```bash
111   uv sync
112   ```
113 
1142. **Build Distributions**
115   ```bash
116   uv build
117   ```
118   Generates source and wheel distributions in the dist/ directory.
119 
1203. **Publish to PyPI**
121   ```bash
122   uv publish
123   ```
124 
125## 🤝 Contributing
126 
127Contributions are welcome! Whether you're fixing bugs, adding features, or improving documentation, your help makes this project better.
128 
129### Reporting Issues
130If you encounter bugs or have suggestions, open an issue in the issues section. Include:
131- Steps to reproduce (if applicable)
132- Expected vs. actual behavior
133- Screenshots or error logs (if relevant)
134 
135## 📜 License
136 
137This project is licensed under the MIT License.
138See the LICENSE file for details.
139 
140## 💬 Get in Touch
141 
142Questions? Feedback? Open an issue or reach out to the maintainers. Let's make this project awesome together!
143 
144## About
145 
146This is an open source project run by [ReadingPlus.AI LLC](https://readingplus.ai). and open to contributions from the entire community.
147