SuperSQL MCP Service
About
Super SQL is a Java framework based on advanced generative large models, focusing on transforming database table structures through Retrieval-Augmented Generation (RAG) technology into intelligent conversions from natural language text to SQL queries (Text to SQL). This framework
Details
- Author
- guocjsh
- Downloads
- 283
- Categories
- Database
Jump to
- Generative SQL: automatically converts natural language to precise SQL queries.
- RAG training: deep learning on table structures for higher accuracy.
- Type-safe and flexible: uses Java generics for compile-time type checking.
- Multi-database support: compatible with various mainstream database systems.
- Performance optimized: efficient execution with good readability.
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:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
SuperSQL MCP ServiceCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
The README does not provide installation, configuration, or invocation instructions. It describes SuperSQL as a Java framework with a concise API design and easy integration into existing projects.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"supersql mcp service": {
"super-sql-mcp-server": {
"command": "java",
"args": [
"-jar",
"-Dspring.ai.mcp.server.stdio=true",
"-Dspring.main.web-application-type=none",
"-Dlogging.pattern.console=",
"-Dspring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver",
"-Dspring.datasource.url=jdbc:mysql://localhost:3306/supersql?characterEncoding=utf8&useSSL=false",
"-Dspring.datasource.username=root",
"-Dspring.datasource.password=123456",
"-Dspring.ai.azure.openai.api-key=your_openai_api_key",
"-Dspring.ai.azure.openai.chat.options.deployment-name=your_chat_model_deployment_name",
"-Dspring.ai.azure.openai.endpoint=your_openai_endpoint",
"-Dspring.ai.azure.openai.embedding.options.deployment-name=your_embedding_model_deployment_name",
"-Dspring.ai.vectorstore.chroma.client.host=http://127.0.0.1",
"-Dspring.ai.vectorstore.chroma.client.port=8000",
"-Dspring.ai.vectorstore.chroma.collection-name=super-sql",
"-Dspring.ai.vectorstore.chroma.initialize-schema=true",
"D:\\your_jar_file_path\\super-sql-mcp-stdio-1.0.0-M1.jar"
],
"env": []
}
}
}
}McpServers
{
"super-sql-mcp-server": {
"command": "java",
"args": [
"-jar",
"-Dspring.ai.mcp.server.stdio=true",
"-Dspring.main.web-application-type=none",
"-Dlogging.pattern.console=",
"-Dspring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver",
"-Dspring.datasource.url=jdbc:mysql://localhost:3306/supersql?characterEncoding=utf8&useSSL=false",
"-Dspring.datasource.username=root",
"-Dspring.datasource.password=123456",
"-Dspring.ai.azure.openai.api-key=your_openai_api_key",
"-Dspring.ai.azure.openai.chat.options.deployment-name=your_chat_model_deployment_name",
"-Dspring.ai.azure.openai.endpoint=your_openai_endpoint",
"-Dspring.ai.azure.openai.embedding.options.deployment-name=your_embedding_model_deployment_name",
"-Dspring.ai.vectorstore.chroma.client.host=http://127.0.0.1",
"-Dspring.ai.vectorstore.chroma.client.port=8000",
"-Dspring.ai.vectorstore.chroma.collection-name=super-sql",
"-Dspring.ai.vectorstore.chroma.initialize-schema=true",
"D:\\your_jar_file_path\\super-sql-mcp-stdio-1.0.0-M1.jar"
],
"env": []
}
}SuperSQL 介绍
SuperSQL 是一个基于国内外先进生成式大模型实现Nl2sql的Java框架，专注于将数据库表结构通过检索增强生成（RAG, Retrieval-Augmented Generation）技术进行训练，从而实现从自然语言文本到SQL查询的智能转换（Text to SQL）。该框架旨在简化复杂的数据库查询过程，使开发者和用户能够通过简单的自然语言描述获取所需数据。主要特性包括：
- 生成式SQL：利用强大的生成式大模型，自动将自然语言问题转化为精确的SQL查询语句。
- RAG训练：通过检索增强生成技术对数据库表结构进行深度学习训练，提高SQL生成的准确性和效率。
- 类型安全与灵活易用：结合Java的泛型机制确保编译期类型检查，同时提供简洁直观的API设计，易于集成到现有项目中。
- 多数据库支持：兼容多种主流数据库系统，满足不同应用场景的需求。
- 性能优化：经过精心设计与调优，在保证高效执行的同时保持良好的可读性。
SuperSQL 适用于希望在Java应用程序中快速、安全地进行复杂数据库操作，并且希望通过自然语言处理技术为传统企业应用快速的实现AI赋能。
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
