VisiData MCP Server

Interact with VisiData, a terminal spreadsheet multitool for discovering and arranging tabular data in various formats like CSV, JSON, and Excel.

GitHub

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

Servidores relacionados