text2sql-mcp-server
Description
# text2sql-mcp-server ## 使用 ### 服务启动 修改`application.yml`，直接运行 ```yaml datasource: url: ${SPRING_DATASOURCE_URL:jdbc:mysql://127.0.0.1:3306/mysql?characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true} username…
About
# text2sql-mcp-server ## 使用 ### 服务启动 修改`application.yml`，直接运行 ```yaml 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…
Details
- Author
- mariaccc
- GitHub stars
- 12
- Downloads
- 198
- Categories
- Other
Jump to
- MySQL database integration with configurable credentials
- Supports both Spring Boot and Docker deployment
- Uses MCP SSE transport protocol
- Designed for use with cherry-studio or similar MCP clients
- Environment-variable-based configuration for secure secrets
Configure the MySQL datasource in application.yml or via environment variables in docker-compose.yaml, then start the server directly or with Docker. Point an MCP client (e.g., cherry-studio) to http://localhost:8080/sse.
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 查询xxxSign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
