About text2sql-mcp-server
text2sql-mcp-server is an MCP server connected to a MySQL data source, for users who want to query a database through prompts. Its README documents configuration, startup, and SSE client connection.
Key features
- 01Configure a MySQL data source
- 02Start through application.yml
- 03Start with Docker Compose
- 04Configure an SSE client
Use cases
- 01Configure a MySQL data source for access
- 02Connect the server through Cherry Studio
- 03Query a specified database using prompts
MCP support
The server accepts MCP client connections over SSE, with the configured endpoint at http://localhost:8080/sse.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMEtext2sql-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
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.