What is Focus Mcp Sql

focus_mcp_sql is a Model Context Protocol (MCP) server that transforms natural language into SQL statements using a two-step SQL generation solution, enhancing accuracy, speed, and reliability.

Use cases

Use cases include generating SQL queries from user queries in customer support systems, enabling data analysts to retrieve information quickly, and assisting non-technical users in formulating database queries.

How to use

To use focus_mcp_sql, initialize the model and ensure you have JDK 23 or higher and Gradle 8.12 or higher installed. Register on Datafocus to obtain a bearer token, clone the repository, and follow the installation instructions.

Key features

Key features include a transparent two-step generation process, low hallucination risk through keyword verification, fast deterministic keyword-to-SQL conversion, and high user-friendliness for non-technical users.

Where to use

focus_mcp_sql can be utilized in various fields such as data analysis, business intelligence, and any application requiring the conversion of natural language queries into SQL statements.

FOCUS DATA MCP Server [中文]

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

There are already so many Text-to-SQL frameworks. Why do we still need another one?

In simple terms, focus_mcp_sql adopts a two-step SQL generation solution, which enables control over the hallucinations of LLM and truly builds the trust of non-technical users in the generated SQL results.

Below is the comparison table between focus_mcp_sql and others:

Comparison Analysis Table

Here’s a side-by-side comparison of focus_mcp_sql with other LLM-based frameworks:

Features

-Initialize the model
-Convert natural language to SQL statements

Prerequisites

• 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
     

Installation

1. Clone this repository:

git clone https://github.com/FocusSearch/focus_mcp_sql.git
cd focus_mcp_sql

2. Build the server:

gradle clean
gradle bootJar

The jar path: build/libs/focus_mcp_sql.jar

MCP Configuration

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"
      ]
    }
  }
}

Available Tools

1. gptText2sqlStart

initial model.

Parameters:

• model (required): table model
• bearer (required): bearer token
• language (optional): language [‘english’,‘chinese’]

Example:

{
  "model": {
    "tables": [
      {
        "columns": [
          {
            "columnDisplayName": "name",
            "dataType": "string",
            "aggregation": "",
            "columnName": "name"
          },
          {
            "columnDisplayName": "address",
            "dataType": "string",
            "aggregation": "",
            "columnName": "address"
          },
          {
            "columnDisplayName": "age",
            "dataType": "int",
            "aggregation": "SUM",
            "columnName": "age"
          },
          {
            "columnDisplayName": "date",
            "dataType": "timestamp",
            "aggregation": "",
            "columnName": "date"
          }
        ],
        "tableDisplayName": "test",
        "tableName": "test"
      }
    ],
    "relations": [],
    "type": "mysql",
    "version": "8.0"
  },
  "bearer": "ZTllYzAzZjM2YzA3NDA0ZGE3ZjguNDJhNDjNGU4NzkyYjY1OTY0YzUxYWU5NmU="
}

model 参数说明：

2. gptText2sqlChat

Convert natural language to SQL.

Parameters:

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

Example:

{
  "chatId": "03975af5de4b4562938a985403f206d4",
  "input": "what is the max age",
  "bearer": "ZTllYzAzZjM2YzA3NDA0ZGE3ZjguNDJhNDjNGU4NzkyYjY1OTY0YzUxYWU5NmU="
}

Response Format

All tools return responses in the following format:

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

Visual Studio Code Cline Sample

1. vsCode install cline plugin
2. mcp server config
   
3. use
   1. initial model
      
      
   2. transfer: what is the max age
      

Contact：

https://discord.gg/mFa3yeq9