Labsco
xoniks logo

MCP Data Visualization Server

★ 19

from xoniks

Generate interactive data visualizations from natural language queries on a DuckDB database.

🔥🔥🔥🔥✓ VerifiedFreeNeeds API keys
#automation#e-commerce#database#git#maps#finance#security#marketing

🎯 MCP Data Visualization Server

Transform natural language into beautiful, interactive data visualizations using Claude Desktop with DuckDB and Databricks support - one-command installation!

✨ Features

  • 🚀 One-Command Installation - pip install mcp-visualization-duckdb
  • 🔧 Automatic Configuration - Automatically sets up Claude Desktop
  • 🗣️ Natural Language Interface - Chat with Claude to create visualizations
  • 📊 Interactive Charts - Plotly-powered HTML widgets
  • 🏢 Databricks Integration - Connect to Databricks SQL warehouses with secure credential management
  • 🗃️ DuckDB Support - Local database with CSV import and interactive browser
  • 🔄 Multi-Database - Seamlessly switch between DuckDB and Databricks
  • 🧠 Rule-Based Analysis - Smart chart suggestions without external LLM dependencies
  • 📈 Multiple Chart Types - Bar, line, scatter, pie, histogram, box plots, heatmaps, and area charts
  • 🔍 Smart Insights - Automatic statistical analysis and pattern detection
  • 🛡️ Security First - SQL injection protection, encrypted credential storage
  • ⚡ No External Dependencies - Works entirely offline with Claude Desktop

🔧 CLI Commands

The package includes a powerful CLI:

# Configuration
mcp-viz configure              # Interactive setup (auto-detects database type)
mcp-viz configure --auto       # Automatic setup with defaults
mcp-viz status                 # Check configuration status

# Management  
mcp-viz test                   # Test server functionality
mcp-viz remove                 # Remove server from Claude Desktop

# DuckDB Database
mcp-viz create-db              # Create sample database
mcp-viz create-db --path ./my-data.duckdb  # Create at specific path

# Databricks Integration
mcp-viz databricks configure   # Setup Databricks credentials (interactive)
mcp-viz databricks status      # Check Databricks connection status
mcp-viz databricks test        # Test connection and browse catalogs
mcp-viz databricks remove      # Remove stored credentials

📊 Supported Chart Types

Chart TypeUse CaseExample Request
BarCompare categories"Show sales by region"
LineShow trends over time"Plot revenue over months"
ScatterExplore relationships"Price vs quantity relationship"
PieShow proportions"Customer segment breakdown"
HistogramAnalyze distributions"Distribution of order values"
BoxCompare distributions"Price ranges by category"
HeatmapShow correlations"Correlation matrix of metrics"
AreaCumulative trends"Cumulative sales over time"

💾 Sample Data

🎯 Built-in Sample Data

The package automatically creates sample data including:

  • Sales Data - 365 days of sales across regions and products
  • Customer Data - 1000 customer records with demographics
  • Product Data - 100 products with categories and pricing

🌟 Additional Sample Databases

Want more data to explore? Check out these high-quality sample databases:

TimeStored Sample DuckDB Databases

Available datasets include:

  • Financial Data - Stock prices, trading data, market analysis
  • NYC Taxi - Real NYC taxi trip records with geospatial data
  • TPC-H Benchmark - Standard database performance testing data
  • E-commerce - Product catalogs, orders, customer behavior
  • IoT Sensor Data - Time-series sensor readings and telemetry

Simply download any .duckdb file and load it:

# Download a sample database, then:
"Load database from Downloads/nyc-taxi.duckdb"
"What tables are available in this database?"
"Create a heatmap of taxi pickups by hour and day"

Perfect for testing, learning, and demonstrating data visualization capabilities!

❓ Frequently Asked Questions

Q: Do I need to run mcp-viz databricks configure every time?

A: No! You only run it once during initial setup. After that:

  • ✅ Credentials are stored securely and auto-loaded
  • ✅ Just open Claude Desktop and start chatting
  • ✅ No repeated authentication needed

Q: How do I know if my Databricks is still connected?

A: Check anytime with:

mcp-viz databricks status    # Shows connection status
mcp-viz databricks test      # Tests connection and shows catalogs

Q: When do I need to reconfigure?

A: Only when:

  • Your access token expires
  • You change Databricks workspaces
  • You switch to a different SQL warehouse
  • Credentials get corrupted (rare)

Q: Are my credentials safe?

A: Yes! Credentials are:

  • 🔒 Encrypted on disk or stored in system keyring
  • 🚫 Never stored in plain text or command history
  • ⚡ Automatically loaded when needed

Q: Can I use both DuckDB and Databricks?

A: Yes! The server auto-detects which database type to use:

  • Configure Databricks: mcp-viz databricks configure
  • Configure DuckDB: mcp-viz configure
  • Server automatically uses the appropriate one

📦 Package Information

🤝 Contributing

We welcome contributions! The package is structured for easy development:

  1. Fork the repository
  2. Create a feature branch
  3. Make your changes
  4. Run tests: python test_package.py
  5. Submit a pull request

🙏 Acknowledgments

Ready to transform your data analysis with Claude Desktop?

pip install mcp-visualization-duckdb && mcp-viz configure

🎉 That's it! Start chatting with Claude about your data!