VisiData MCP Server

A Model Context Protocol (MCP) server that provides access to VisiData functionality with enhanced data visualization and analysis capabilities.

🚀 Features

📊 Data Visualization

• create_correlation_heatmap - Generate correlation matrices with beautiful heatmap visualizations

• create_distribution_plots - Create statistical distribution plots (histogram, box, violin, kde)

• create_graph - Custom graphs (scatter, line, bar, histogram) with categorical grouping support

🧠 Advanced Skills Analysis

• parse_skills_column - Parse comma-separated skills into individual skills with one-hot encoding

• analyze_skills_by_location - Comprehensive skills frequency and distribution analysis by location

• create_skills_location_heatmap - Visual heatmap showing skills distribution across locations

• analyze_salary_by_location_and_skills - Advanced salary statistics by location and skills combination

🔧 Core Data Tools

• load_data - Load and inspect data files from various formats

• get_data_sample - Get a preview of your data with configurable row count

• analyze_data - Perform comprehensive data analysis with column types and statistics

• convert_data - Convert between different data formats (CSV ↔ JSON ↔ Excel, etc.)

• filter_data - Filter data based on conditions (equals, contains, greater/less than)

• get_column_stats - Get detailed statistics for specific columns

• sort_data - Sort data by any column in ascending or descending order

📦 Installation

🚀 Quick Install (Recommended)

npm install -g @moeloubani/visidata-mcp@beta

Prerequisites: Python 3.10+ (the installer will check and guide you if needed)

Alternative: Python Install

pip install visidata-mcp

Development Install

git clone https://github.com/moeloubani/visidata-mcp.git
cd visidata-mcp
pip install -e .

⚙️ Configuration

Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "visidata": {
      "command": "visidata-mcp"
    }
  }
}

Cursor AI

Create .cursor/mcp.json in your project:

{
  "mcpServers": {
    "visidata": {
      "command": "visidata-mcp"
    }
  }
}

Restart your AI application after configuration changes.

🎯 Example Usage

Data Visualization

# Create a correlation heatmap
create_correlation_heatmap("sales_data.csv", "correlation_heatmap.png")

# Generate distribution plots for all numeric columns
create_distribution_plots("sales_data.csv", "distributions.png", plot_type="histogram")

# Create a scatter plot with categorical grouping
create_graph("sales_data.csv", "price", "sales", "scatter_plot.png", 
            graph_type="scatter", category_column="region")

Skills Analysis

# Parse comma-separated skills into individual columns
parse_skills_column("jobs.csv", "required_skills", "skills_parsed.csv")

# Analyze skills distribution by location
analyze_skills_by_location("jobs.csv", "required_skills", "location", "skills_analysis.json")

# Create skills-location heatmap
create_skills_location_heatmap("jobs.csv", "required_skills", "location", "skills_heatmap.png")

# Comprehensive salary analysis
analyze_salary_by_location_and_skills("jobs.csv", "salary", "location", "required_skills", "salary_analysis.xlsx")

Basic Data Operations

# Load and analyze data
load_data("data.csv")
get_data_sample("data.csv", 10)
analyze_data("data.csv")

# Transform data
convert_data("data.csv", "data.json")
filter_data("data.csv", "revenue", "greater_than", "1000", "high_revenue.csv")
sort_data("data.csv", "date", False, "sorted_data.csv")

📊 Supported Data Formats

• Spreadsheets: CSV, TSV, Excel (XLSX/XLS)

• Structured Data: JSON, JSONL, XML, YAML

• Databases: SQLite

• Scientific: HDF5, Parquet, Arrow

• Archives: ZIP, TAR, GZ, BZ2, XZ

• Web: HTML tables

🔧 Troubleshooting

Common Issues

"No module named 'matplotlib'"

• Make sure you're using the correct MCP server path

• For local development: /path/to/visidata-mcp/venv/bin/visidata-mcp

• Restart your AI application after configuration changes

"0 tools available"

• Verify the MCP server path in your configuration

• Check that Python 3.10+ is installed

• Restart your AI application completely

Verification

Test your installation:

# Check if server starts
visidata-mcp

# Test with Python
python -c "from visidata_mcp.server import main; print('✅ Server ready')"

🎨 Key Features

• ✅ Complete visualization support with matplotlib, seaborn, and scipy

• ✅ Advanced skills analysis for job market and HR data

• ✅ Skills-location correlation analysis and visualization

• ✅ Salary analysis by location and skills combination

• ✅ Enhanced error handling with dependency validation

• ✅ Publication-ready visualizations (300 DPI PNG output)

📈 Use Cases

Job Market Analysis

• Skills demand analysis by geographic location

• Salary benchmarking across locations and skill sets

• Market trend visualization with correlation analysis

Data Science Workflows

• Complete statistical analysis pipeline

• Publication-ready visualizations

• Advanced text processing for categorical data

Business Intelligence

• Location-based performance analysis

• Skills gap identification

• Compensation analysis and benchmarking

🛠 Development

# Install for development
git clone https://github.com/moeloubani/visidata-mcp.git
cd visidata-mcp
pip install -e .

# Build package
python -m build

# Run tests
python -c "from visidata_mcp.server import main; print('✅ Ready')"

📄 License

MIT License - see LICENSE for details.

🔗 Links

• VisiData Website

• Model Context Protocol

• GitHub Repository