Focus MCP Sql

🚀 FOCUS Data MCP Server

The Model Context Protocol (MCP) server enables AI assistants to convert natural language into SQL statements.

🤔 Why Another Text-to-SQL Framework?

In simple terms, focus_mcp_sql adopts a two-step SQL generation solution, which controls the hallucination of large language models and truly builds non-technical users' trust in the generated SQL results.

The following table is a comparative analysis of focus_mcp_sql with other LLM-based frameworks:

Comparison Table

The following is a horizontal comparison between focus_mcp_sql and other LLM frameworks:

📑 Table of Contents

• Project Introduction
• Features
• Use Cases
• Quick Start
• API Documentation
• Code Examples
• Contact Information

📄 Project Introduction

The FOCUS Data MCP Server is a middleware service based on the Model Context Protocol (MCP), aiming to simplify the process of converting natural language to SQL. Through a two-step interactive process (initializing the model and having context conversations), this framework can efficiently and accurately transform user intentions into database query statements.

✨ Features

1. Two-step Interactive Design:
   • Initialize the model: Load database metadata (table structure, column information).
   • Context conversation: Parse natural language step by step to generate SQL statements.
2. High Interpretability:
   • Ensure that each operation step is clearly traceable through intermediate keywords and context information.
3. Low Resource Consumption:
   • Does not rely on complex deep learning models, suitable for local deployment and edge computing scenarios.
4. Flexible Extension:
   • Supports multiple database types (e.g., MySQL, PostgreSQL).
   • Can be extended to support more natural language expressions through rule libraries.

📋 Use Cases

1. Data analysis tools: Help users quickly generate complex query statements.
2. Low-code development platforms: Provide automatic SQL generation functionality to lower the development threshold.
3. Data visualization applications: Simplify the data acquisition process and enhance the user experience.
4. Education and training systems: Serve as a teaching aid to demonstrate the SQL generation process.

🚀 Quick Start

Install Dependencies

pip install focus-mcp-server

Initialize the Model

Configure the MCP server in VS Code:

1. Install the Cline plugin.

2. Add the MCP server configuration:

3. Usage example:

   • Initialize the model:

   • Convert natural language to SQL:

📚 API Documentation

Tool Return Format

All tool responses adopt the following JSON format:

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

📞 Contact Information

Join our Discord community: https://discord.gg/AVufPnpaad