What is Bi Chart Mcp Server

BI-Chart-MCP-Server is a Model Context Protocol (MCP) server designed for data transformation and generating high-quality Business Intelligence (BI) charts. It allows AI assistants to connect to various data sources, transform data, and create visualizations based on natural language requests.

Use cases

Use cases include connecting to databases to analyze sales data, loading data from CSV files for visualization, filtering data to display specific transactions, and generating charts to represent data insights visually.

How to use

To use BI-Chart-MCP-Server, clone the repository, install dependencies using npm, and start the server. Connect to the server from an MCP-compatible AI assistant using the specified protocol and endpoint, then use natural language commands to interact with your data.

Key features

Key features include connections to various data sources (PostgreSQL, MySQL, SQLite, CSV, Excel, JSON), data transformation capabilities (filtering, aggregating, joining, sorting), generation of various BI visualizations (bar charts, line charts, pie charts, scatter plots), and compatibility with any MCP-compatible AI assistant.

Where to use

BI-Chart-MCP-Server can be used in fields such as business analytics, data visualization, reporting, and any domain requiring data transformation and visualization through AI assistance.

BI Chart MCP Server

This project implements the BI Chart MCP Server using Python. Previously, the functionality was prototyped with TypeScript, but the current and maintained version is built with Python.

Project Structure

• mcp_bi_visualizer/: Contains the main server code and modules.
  • server.py: Main entry point for starting the MCP server.
  • data/: Data loading and processing modules.
    • loader.py
    • processor.py
  • resources/: Modules to manage project resources.
    • manager.py
    • memo.py
  • visualization/: Visualization components.
    • renderer.py
    • vega_lite.py
• scripts/
  • run_server.py: A script to launch the server.
• tests/: Unit tests for the server and visualization components.
• Other files include configuration files (e.g., pyproject.toml, requirements.txt, setup.py) and documentation.

Installation

1. Clone the repository.
2. Create a virtual environment and activate it:

   python -m venv .venv
   .venv\Scripts\activate   # On Windows
   

3. Install the required dependencies:

   pip install -r requirements.txt
   

Running the Server

You can run the server using the provided script:

python scripts/run_server.py

Alternatively, you can start the server directly from the module:

python -m mcp_bi_visualizer.server

Testing

Run the tests using your preferred test runner. For example, with pytest:

pytest

Notes

• The project has been migrated from a TypeScript-based implementation to Python.
• For any issues or contributions, please refer to the CONTRIBUTING.md file.

Enjoy using the BI Chart MCP Server!