Focus_mcp_data

Focus_mcp_data

By FocusSearch GitHub

The intelligent data query plugin under DataFocus that supports multi-round conversations provides plug-and-play ChatBI capabilities.

data-query chatbi
Overview

what is Focus_mcp_data?

Focus_mcp_data is an intelligent data query plugin under DataFocus that enables users to perform multi-round conversations and provides plug-and-play ChatBI capabilities for data querying.

how to use Focus_mcp_data?

To use Focus_mcp_data, register on DataFocus to create an application space, import the data tables you want to analyze, and then use natural language to query data results.

key features of Focus_mcp_data?

  • Direct querying of data results using natural language.
  • Multi-round conversation support for interactive data querying.
  • Easy integration with DataFocus data tables.

use cases of Focus_mcp_data?

  1. Querying data insights from large datasets using simple language.
  2. Engaging in multi-turn conversations to refine data queries.
  3. Integrating with AI assistants for enhanced data interaction.

FAQ from Focus_mcp_data?

  • What is required to use Focus_mcp_data?

You need to register on DataFocus, have JDK 23 or higher, and Gradle 8.12 or higher installed.

  • Can I use Focus_mcp_data for any type of data?

Yes, as long as the data is imported into your DataFocus application space.

  • Is there a limit to the number of queries I can make?

No, you can make as many queries as needed within your session.

Content

# FOCUS DATA MCP Server [[中文](./README_CN.md)]

A Model Context Protocol (MCP) server enables artificial intelligence assistants to directly query data results. Users can obtain data results from DataFocus using natural language.

Features

  • Register on DataFocus to open an application space, and import (directly connect to) the data tables to be analyzed.
  • Select Datafocus data table initialization dialogue
  • Natural language data acquisition results

Prerequisites

Installation

  1. Clone this repository:

```bash git clone https://github.com/FocusSearch/focus\_mcp\_data.git cd focus_mcp_data ```

  1. Build the server:

```bash gradle clean gradle bootJar

The jar path: build/libs/focus_mcp_data.jar ```

MCP Configuration

Add the server to your MCP settings file (usually located at `~/AppData/Roaming/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json`):

```json { "mcpServers": { "focus_mcp_data": { "command": "java", "args": [ "-jar", "path/to/focus_mcp_data/focus_mcp_data.jar" ], "autoApprove": [ "tableList", "gptText2DataInit", "gptText2DataData" ] } } } ```

Available Tools

1. tableList

Get table list in datafocus.

**Parameters:**

  • `name` (optional): table name to filter
  • `bearer` (required): bearer token

**Example:**

```json { "name": "test", "bearer": "ZTllYzAzZjM2YzA3NDA0ZGE3ZjguNDJhNDjNGU4NzkyYjY1OTY0YzUxYWU5NmU=" } ```

2. gptText2DataInit

Initialize dialogue.

**Parameters:**

  • `names` (required): selected table names
  • `bearer` (required): bearer token
  • `language` (optional): language ['english','chinese']

**Example:**

```json { "names": [ "test1", "test2" ], "bearer": "ZTllYzAzZjM2YzA3NDA0ZGE3ZjguNDJhNDjNGU4NzkyYjY1OTY0YzUxYWU5NmU=" } ```

3. gptText2DataData

Query data results.

**Parameters:**

  • `chatId` (required): chat id
  • `input` (required): Natural language
  • `bearer` (required): bearer token

**Example:**

```json { "chatId": "03975af5de4b4562938a985403f206d4", "input": "max(age)", "bearer": "ZTllYzAzZjM2YzA3NDA0ZGE3ZjguNDJhNDjNGU4NzkyYjY1OTY0YzUxYWU5NmU=" } ```

Response Format

All tools return responses in the following format:

```json { "errCode": 0, "exception": "", "msgParams": null, "promptMsg": null, "success": true, "data": { } } ```

Visual Studio Code Cline Sample

  1. vsCode install cline plugin
  2. mcp server config ![config mcp server](./mcp_server_config.png)
  3. use
    1. get table list ![get table list1](./focus_mcp_data_table_1.png) ![get table list2](./focus_mcp_data_table_2.png)
    2. Initialize dialogue ![Initialize dialogue](./focus_mcp_data_init.png)
    3. query: what is the sum salary ![query](./focus_mcp_data_data.png)

Contact：

[https://discord.gg/mFa3yeq9\](https://discord.gg/mFa3yeq9) ![Datafocus](./wechat-qrcode.png)

No tools information available.
No content found.