使用说明
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
