Mcp Data Visualization Server
@xoniks
关于 Mcp Data Visualization Server
Transform natural language into beautiful, interactive data visualizations. This server uniquely integrates powerful technologies like DuckDB, Ollama, and Plotly, streamlining complex data analysis workflows into a single, conversational experience within the Model Context Protoc
基本信息
配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"data-viz-server": {
"command": "C:/Github/mcp-visualization-duckdb/.venv/Scripts/python.exe",
"args": [
"C:/Github/mcp-visualization-duckdb/mcp_server.py"
],
"cwd": "C:/Github/mcp-visualization-duckdb",
"env": {
"DUCKDB_DATABASE_PATH": "C:/Github/mcp-visualization-duckdb/data/mcp.duckdb",
"PYTHONIOENCODING": "utf-8"
}
}
}
}工具
未检测到工具
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
概览
What is Mcp Data Visualization Server?
A Model Context Protocol server that transforms natural language into interactive data visualizations using DuckDB for data storage, Plotly for chart generation, and Ollama for local LLM processing. It integrates with Claude Desktop to let users manage databases, analyze data, and create charts through conversational commands.
How to use Mcp Data Visualization Server?
Install Python 3.8+, Ollama, and Claude Desktop. Clone the repository, create a virtual environment, install dependencies (mcp, duckdb, pandas, plotly, ollama, etc.), start Ollama, pull a model (e.g., qwen2:0.5b), and add the server configuration to Claude Desktop’s claude_desktop_config.json. Restart Claude Desktop and chat using natural language requests.
Key features of Mcp Data Visualization Server
- Natural language interface for database management and chart creation
- Interactive charts (bar, line, scatter, pie, histogram, box, heatmap, area)
- Flexible database switching with an interactive browser
- Local LLM processing via Ollama for privacy
- Automatic statistical insights and pattern detection
- SQL injection protection and input validation
Use cases of Mcp Data Visualization Server
- Business analytics: sales dashboards, customer segmentation, regional performance
- Data science: exploratory analysis, correlation heatmaps, outlier detection
- Quick ad‑hoc queries and visualizations without writing SQL or code
- Privacy‑focused analysis where all data stays on the local machine
FAQ from Mcp Data Visualization Server
What are the prerequisites for running the server?
Python 3.8+, Ollama installed and running, and Claude Desktop installed. A lightweight Ollama model such as qwen2:0.5b is recommended.
How is data stored and processed?
Data is stored in local DuckDB database files (.duckdb). All processing happens on your machine; no data is sent to external services.
Does the server require an internet connection?
No. The LLM runs locally via Ollama, and all database operations are local. An internet connection is only needed for initial installation of dependencies or pulling an Ollama model.
What chart types are available?
Bar, line, scatter, pie, histogram, box, heatmap, and area charts. Chart type suggestions and guided configuration are available through natural language.
How can I switch to a different database?
Use natural language commands like “Switch to in-memory database” or “Connect to C:/path/to/database.duckdb”, or use the browse_databases and change_database tools.
数据库 分类下的更多 MCP 服务器
mcp-server-qdrant: A Qdrant MCP server
qdrantAn official Qdrant Model Context Protocol (MCP) server implementation
Neon MCP Server
neondatabase-labsMCP server for interacting with Neon Management API and databases
Dbhub
bytebaseZero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
MongoDB Lens
furey🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases
评论