Labsco
Beaulewis1977 logo

Quick Data for Windows MCP

β˜… 1

from Beaulewis1977

A Windows-optimized server for performing data analytics on JSON and CSV files, designed for Claude Desktop integration.

πŸ”₯πŸ”₯πŸ”₯βœ“ VerifiedFreeNeeds API keys

Quick Data for Windows MCP

Windows-optimized fork of disler/quick-data-mcp for Claude Desktop

Universal data analytics capabilities for JSON/CSV files - now working seamlessly on Windows!

Python 3.9+ Windows Claude Desktop Original Project

πŸš€ What This Does

This is a Windows-optimized fork of the excellent quick-data-mcp project by @disler.

The original project provides powerful MCP server capabilities for data analytics, and this fork specifically addresses Windows compatibility issues and Claude Desktop integration challenges.

**This is my first ever try at this. Please feel free to give suggestions and or criticisms. I loved the quick data mcp for claude code. There was nothing available like it for claude desktop so with the help of claude code we now have it.

Key Improvements Over Original:

  • βœ… Windows Path Handling - Proper Windows file path support
  • βœ… Claude Desktop Ready - Pre-configured batch launchers and setup
  • βœ… Dependency Management - Automated installation scripts
  • βœ… Troubleshooting - Complete guides for common Windows issues

✨ Key Features

  • Universal Data Support - Works with any CSV/JSON file structure
  • Windows Path Optimization - Handles Windows file paths correctly
  • Claude Desktop Integration - Pre-configured for seamless setup
  • Automatic Schema Discovery - Analyzes your data and suggests analyses
  • 32+ Analytics Tools - From basic stats to advanced ML features
  • Interactive Visualizations - Create charts with Plotly
  • Memory Management - Optimized for large datasets

πŸ”§ Available Tools

Dataset Management

  • load_dataset - Load CSV/JSON files with automatic schema discovery
  • list_loaded_datasets - View all datasets in memory
  • get_dataset_info - Get detailed dataset information
  • clear_dataset / clear_all_datasets - Memory management

Core Analytics

  • segment_by_column - Analyze categorical data segments
  • find_correlations - Discover relationships between variables
  • analyze_distributions - Statistical distribution analysis
  • detect_outliers - Identify data anomalies
  • suggest_analysis - AI-powered analysis recommendations

Visualization

  • create_chart - Generate interactive charts (bar, scatter, line, histogram)
  • generate_dashboard - Multi-chart dashboards

Advanced Analytics

  • validate_data_quality - Comprehensive data quality scoring
  • compare_datasets - Multi-dataset comparison analysis
  • merge_datasets - Join datasets with flexible strategies
  • calculate_feature_importance - ML feature importance analysis
  • export_insights - Export results in multiple formats

πŸ“‚ Supported File Formats

CSV Files

  • Standard CSV with headers
  • Custom delimiters automatically detected
  • UTF-8 encoding support
  • Large file handling with sampling options

JSON Files

  • Flat JSON structures
  • Nested JSON (automatically flattened)
  • JSON Lines format
  • Array of objects format

πŸ§ͺ Testing the Server

Test the server standalone (before Claude Desktop integration):

python main.py

Expected output:

Quick Data for Windows MCP v1.0.0
Server running on stdio...

πŸ“Š Example Workflows

Sales Data Analysis

1. Load sales_data.csv as "sales"
2. Show correlations in sales dataset
3. Create bar chart of sales by product_category 
4. Detect outliers in revenue column
5. Generate dashboard with top products and regional trends

Data Quality Assessment

1. Load customer_data.csv as "customers"
2. Validate data quality for customers dataset
3. Analyze distributions for age column
4. Segment by customer_type column

🀝 Contributing

This is a community-driven Windows adaptation of the original quick-data-mcp project. Contributions welcome!

Development Setup

# Clone and setup
git clone https://github.com/Beaulewis1977/quick-data-for-windows-mcp.git
cd quick-data-for-windows-mcp

# Install development dependencies
pip install -r requirements.txt
pip install pytest black ruff

# Run tests (when implemented)
pytest tests/

πŸ“ License

MIT License - see LICENSE file for details.

πŸ™ Acknowledgments

This project is a Windows-optimized fork of the original quick-data-mcp by @disler.

Original Project Credits

  • Original Author: @disler
  • Original Repository: disler/quick-data-mcp
  • Original Purpose: MCP server for data analytics with Claude Code
  • License: MIT (maintained in this fork)

Windows Fork Contributions

  • Windows Compatibility: @Beaulewis1977
  • Claude Desktop Integration: Community-driven improvements
  • Troubleshooting & Documentation: Enhanced for Windows users

Technology Stack

  • Model Context Protocol: Anthropic
  • Data Processing: pandas, numpy, plotly, scikit-learn
  • Platform: Optimized for Windows + Claude Desktop

⭐ Please star both repositories:

Special thanks to @disler for creating the foundational work that made this Windows adaptation possible!

πŸ”— Links


**This is my first ever try at this. Please feel free to give suggestions and or criticisms. I loved the quick data mcp for claude code. There was nothing available like it for claude desktop so with the help of claude code we now have it.

Ready to analyze your data with AI? Load a CSV and start exploring! πŸš€