FOCUS DATA MCP Server

by focussearch

18 398 downloads Not rated yet Apache-2.0

About

Converts natural language queries into SQL by registering database schema information and handling text-to-SQL transformations through a Spring Boot implementation.

Details

Repository
FocusSearch/focus_mcp_sql
License
Apache-2.0

Explore

-Initialize the model
-Convert natural language to SQL statements

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. Configure the plugin with the settings below
    Plugin Name FOCUS DATA MCP Server
    Command (node, npx, python, etc.) java
    Arguments
    • Argument 1 -jar
    • Argument 2 path/to/focus_mcp_sql/focus_mcp_sql.jar

    Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

- jdk 23 or higher. Download jdk
- gradle 8.12 or higher. Download gradle
- register Datafocus to obtain bearer token:
1. Register an account in Datafocus
2. Create an application
3. Enter the application
4. Admin -> Interface authentication -> Bearer Token -> New Bearer Token
bearer token

Add the server to your MCP settings file:

{
  "mcpServers": {
    "focus_mcp_data": {
      "command": "java",
      "args": [
        "-jar",
        "path/to/focus_mcp_sql/focus_mcp_sql.jar"
      ],
      "autoApprove": [
        "gptText2sqlStart",
        "gptText2sqlChat"
      ]
    }
  }
}

gptText2sqlStart

Initializes the model with a specified table structure and bearer token. Parameters: model (object, required), bearer (string, required), language (string, optional)

gptText2sqlChat

Converts natural language input into SQL statements based on a given chat ID and bearer token. Parameters: chatId (string, required), input (string, required), bearer (string, required)

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "focus data mcp server": {
            "cwd": "",
            "env": {},
            "args": [
                "-jar",
                "path/to/focus_mcp_sql/focus_mcp_sql.jar"
            ],
            "shell": false,
            "command": "java"
        }
    }
}

Linux

{
    "cwd": "",
    "env": [],
    "args": [
        "-jar",
        "path/to/focus_mcp_sql/focus_mcp_sql.jar"
    ],
    "shell": false,
    "command": "java"
}

Macos

{
    "cwd": "",
    "env": [],
    "args": [
        "-jar",
        "path/to/focus_mcp_sql/focus_mcp_sql.jar"
    ],
    "shell": false,
    "command": "java"
}

Windows

{
    "cwd": "",
    "env": [],
    "args": [
        "-jar",
        "path/to/focus_mcp_sql/focus_mcp_sql.jar"
    ],
    "shell": false,
    "command": "java"
}

A Model Context Protocol (MCP) server enables artificial intelligence assistants to convert natural language into SQL statements.

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.