drio
Open app

BI Chart MCP Server

Source

An MCP (Model Context Protocol) server for data transformation and BI charts will allow AI assistants to connect to your data sources, transform data, and generate high-quality visualizations through natural language requests.

Catalog onlyCatalog onlySTDIO

Overview

Data BI MCP Server is a Model Context Protocol (MCP) server designed for transforming data into high-quality Business Intelligence (BI) charts. It allows AI assistants to connect to various data sources, perform data transformations, and generate visualizations through natural language requests.

To use the server, clone the repository, install the dependencies, and start the server. Connect to it using an MCP-compatible AI assistant and issue natural language commands to interact with your data.

  • Data Source Connections: Connects to databases (PostgreSQL, MySQL, SQLite) and files (CSV, Excel, JSON). - Data Transformation: Capable of filtering, aggregating, joining, and sorting data. - BI Visualizations: Generates various types of charts including bar charts, line charts, pie charts, and scatter plots. - MCP Compatibility: Works seamlessly with any MCP-compatible AI assistant.
  1. Connecting to a PostgreSQL database to visualize sales data.
  2. Loading and transforming CSV data for analysis.
  3. Generating visual reports for business intelligence.

Add to your AI client

Use these steps to connect BI Chart MCP Server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "bi-chart-mcp-server-c-cf": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-bi-chart-mcp-server-c-cf"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "bi-chart-mcp-server-c-cf": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-bi-chart-mcp-server-c-cf"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "bi-chart-mcp-server-c-cf": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-bi-chart-mcp-server-c-cf"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "bi-chart-mcp-server-c-cf": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-bi-chart-mcp-server-c-cf"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "bi-chart-mcp-server-c-cf": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-bi-chart-mcp-server-c-cf"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "bi-chart-mcp-server-c-cf": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-bi-chart-mcp-server-c-cf"
      ]
    }
  }
}

FAQ

Can I connect to multiple data sources?

Yes! The server supports connections to various databases and file types.

Is there a specific AI assistant I need to use?

No, as long as the assistant is MCP-compatible, it can connect to the server.

How do I customize the server's port?

You can set the `PORT` environment variable to change the default port.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":2449,"uuid":"63a1f580-2ace-44a7-99ad-a3dfc9a4f1cc","name":"BI-Chart-MCP-Server","title":"BI Chart MCP Server","description":"An MCP (Model Context Protocol) server for data transformation and BI charts will allow AI assistants to connect to your data sources, transform data, and generate high-quality visualizations through natural language requests.","avatar_url":"https://avatars.githubusercontent.com/u/67451469?v=4","created_at":"2025-03-13T08:02:00.249Z","updated_at":"2025-03-13T08:03:54.942Z","status":"created","author_name":"c-cf","author_avatar_url":"https://avatars.githubusercontent.com/u/67451469?v=4","tags":"[]","category":"research-and-data","is_featured":false,"sort":1,"url":"https://github.com/c-cf/BI-Chart-MCP-Server","target":"_self","content":"$29","summary":"$2a","img_url":null,"type":null,"metadata":"{\"star\":\"4\",\"license\":\"Apache-2.0 license\",\"language\":\"Python\",\"is_official\":false,\"latest_commit_time\":\"2025-04-01 00:43:24\"}","user_uuid":null,"tools":null,"sse_url":null,"sse_provider":null,"sse_params":null,"is_official":false,"server_command":null,"server_params":null,"server_config":null,"allow_call":false,"is_innovation":false,"is_dxt":false,"dxt_manifest":null,"dxt_file_url":null,"is_audit":false},"randomProjects":[],"currentServerKey":"$undefined"}]]}]

Research and data