Skip to main content
Glama
FocusSearch

focus_mcp_data

by FocusSearch

FOCUS DATA MCP 服务器 [中文]

模型上下文协议(MCP)服务器使人工智能助手能够直接查询数据结果。用户可以通过自然语言从DataFocus获取数据结果。

特征

  • 在DataFocus上注册开通一个应用空间,导入(直连)需要分析的数据表。

  • 选择Datafocus数据表初始化对话框

  • 自然语言数据采集结果

Related MCP server: MCPDemo - Visual SQL Chat Platform

先决条件

  • jdk 23 或更高版本。下载jdk

  • gradle 8.12 或更高版本。下载gradle

  • 注册Datafocus以获取 bearer token:

    1. 在Datafocus注册一个账户

    2. 创建应用程序

    3. 进入应用程序

    4. 管理 -> 接口认证 -> Bearer Token -> 新建 Bearer Token持有者令牌

安装

  1. 克隆此存储库:

git clone https://github.com/FocusSearch/focus_mcp_data.git
cd focus_mcp_data
  1. 构建服务器:

gradle clean
gradle bootJar

The jar path: build/libs/focus_mcp_data.jar

MCP 配置

将服务器添加到您的 MCP 设置文件(通常位于~/AppData/Roaming/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json ):

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

可用工具

1. 表列表

获取 datafocus 中的表格列表。

参数:

  • name (可选):要过滤的表名

  • bearer (必需):持有者令牌

例子:

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

2. gptText2DataInit

初始化对话。

参数:

  • names (必需):选定的表名称

  • bearer (必需):持有者令牌

  • language (可选):语言['english','chinese']

例子:

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

3. gptText2DataData

查询数据结果。

参数:

  • chatId (必填):聊天ID

  • input (必需):自然语言

  • bearer (必需):持有者令牌

例子:

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

响应格式

所有工具都以以下格式返回响应:

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

Visual Studio Code Cline 示例

  1. vsCode 安装 cline 插件

  2. mcp 服务器配置配置 mcp 服务器

  3. 使用

    1. 获取表格列表获取表格列表1获取表格列表2

    2. 初始化对话初始化对话

    3. 查询:工资总额是多少询问

接触:

https://discord.gg/mFa3yeq9数据焦点

Related MCP Connectors

Related MCP Servers

  • A
    license
    Not graded
    quality
    F
    maintenance
    A NL2SQL plugin based on FocusSearch keyword parsing, offering greater accuracy, higher speed, and more reliability!
    39
    Apache 2.0
  • A
    license
    Not graded
    quality
    D
    maintenance
    An AI-driven data visualization and SQL chat platform that enables natural language to SQL conversion, interactive chart generation, and database querying through a comprehensive MCP interface. Supports multiple databases, intelligent chart recommendations, and secure data management with temporary link sharing.
    3 npm
    ISC
  • A
    license
    Not graded
    quality
    A
    maintenance
    Enables AI assistants to analyze cloud billing data in FOCUS format through natural language queries. Provides 36+ predefined cost analysis queries, custom SQL execution, and schema documentation for multi-cloud cost optimization and FinOps practices.
    13 PyPI
    11
    Apache 2.0
  • A
    license
    B
    quality
    D
    maintenance
    Enables users to interact with Cube's AI agent for real-time analytics and data exploration through a chat interface. It supports generating data visualizations, performing SQL queries, and analyzing trends using natural language.
    1
    37 npm
    13
    MIT