Text2sql Mcp Server
What is Text2sql Mcp Server
text2sql-mcp-server is a server that enables users to convert natural language queries into SQL queries, facilitating easier database interactions.
Use cases
Use cases include generating SQL queries from user questions in customer support systems, automating report generation in data analytics, and enabling non-technical users to interact with databases.
How to use
To use text2sql-mcp-server, modify the ‘application.yml’ or ‘docker-compose.yaml’ files to set up the database connection parameters. Then, run the server using the appropriate command. Client configuration is also required to connect to the server.
Key features
Key features include natural language processing for SQL query generation, support for MySQL databases, and easy deployment via Docker.
Where to use
text2sql-mcp-server can be used in various fields such as data analysis, business intelligence, and application development where database queries are needed.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Text2sql Mcp Server
text2sql-mcp-server is a server that enables users to convert natural language queries into SQL queries, facilitating easier database interactions.
Use cases
Use cases include generating SQL queries from user questions in customer support systems, automating report generation in data analytics, and enabling non-technical users to interact with databases.
How to use
To use text2sql-mcp-server, modify the ‘application.yml’ or ‘docker-compose.yaml’ files to set up the database connection parameters. Then, run the server using the appropriate command. Client configuration is also required to connect to the server.
Key features
Key features include natural language processing for SQL query generation, support for MySQL databases, and easy deployment via Docker.
Where to use
text2sql-mcp-server can be used in various fields such as data analysis, business intelligence, and application development where database queries are needed.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
text2sql-mcp-server
使用
服务启动
修改application.yml，直接运行
datasource:
url: ${SPRING_DATASOURCE_URL:jdbc:mysql://127.0.0.1:3306/mysql?characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true}
username: ${SPRING_DATASOURCE_USERNAME:root}
password: ${SPRING_DATASOURCE_PASSWORD:password}
或者修改docker-compose.yaml，使用docker compose up --build -d
environment:
SPRING_DATASOURCE_URL: "jdbc:mysql://127.0.0.1:3306/mysql?characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true"
SPRING_DATASOURCE_USERNAME: "root"
SPRING_DATASOURCE_PASSWORD: "password"
客户端配置
cherry-studio配置
{
"name": "text2sql-mcp-server",
"type": "sse",
"description": "",
"isActive": true,
"baseUrl": "http://localhost:8080/sse"
}
提示词模板
数据库：xxx
查询xxx
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
