mcp-mysql-server
A Spring AI-based MCP capable of executing any SQL query. 一个基于 Spring AI 的MCP服务,可执行任意 SQL。
Documentation
MCP MySQL Server
一个基于 Spring AI 的MCP,可执行任意 SQL。
> 关于其他数据库支持,请查看 mcp-db-server
快速上手
1. MCP JSON 配置
方式一:Maven Wrapper 启动
{
"mcpServers": {
"mcp-mysql-server": {
"command": "/Users/xin.y/IdeaProjects/mcp-mysql-server/mvnw",
"args": [
"-q",
"-f",
"/Users/xin.y/IdeaProjects/mcp-mysql-server/pom.xml",
"spring-boot:run"
]
}
}
}方式二:JAR 包启动
构建jar
./mvnw clean package配置MCP服务器
{
"mcpServers": {
"mcp-mysql-server": {
"command": "java",
"args": [
"-Dloader.path=/Users/xin.y/IdeaProjects/mcp-mysql-server/src/main/resources/groovy",
"-jar",
"/Users/xin.y/IdeaProjects/mcp-mysql-server/target/mcp-mysql-server-0.0.1-SNAPSHOT.jar"
]
}
}
}注意: `-Dloader.path` 参数为可选,仅在需要运行扩展功能时才需要指定。
2. 数据源配置
修改 `mcp-mysql-server/src/main/resources/datasource.yml` 文件:
datasource:
datasources:
your_db1_name:
url: jdbc:mysql://localhost:3306/db1
username: root
password: password
default: true # 标记为默认数据源功能特点
- 多数据源支持 - 配置和管理多个数据库数据源
- 动态数据源切换 - 运行时动态切换不同的数据源
- 扩展功能 - 通过 Groovy 脚本扩展功能
- SQL 安全控制 - 防止 AI 模型执行危险 SQL 操作
详细文档
| 文档 | 描述 |
|---|---|
| 扩展功能文档 | Groovy 脚本扩展的详细配置和开发指南 |
| 数据源配置文档 | 数据源的详细配置、多环境管理和最佳实践 |
| SQL 安全控制文档 | SQL 安全策略的配置和管理 |
环境要求
- JDK 21+
- Maven 3.6+
Frequently asked questions
What is mcp-mysql-server?
mcp-mysql-server is A Spring AI-based MCP capable of executing any SQL query. 一个基于 Spring AI 的MCP服务,可执行任意 SQL。
How do I install mcp-mysql-server?
Open the GitHub repository and follow its README. Most MCP servers are added to your client's MCP config, then called by your agent.
Is mcp-mysql-server open source?
Yes — it is hosted on GitHub at https://github.com/JamesSmith888/mcp-mysql-server and has 26 stars.
Related MCP tools
an open source, extensible AI agent that goes beyond code suggestions - install, execute, edit, and test with any LLM
The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
The Open-Source Multimodal AI Agent Stack: Connecting Cutting-Edge AI Models and Agent Infra
A MCP for Claude Desktop / Claude Code / Windsurf / Cursor to build n8n workflows for you
YC (S26) | Open Computer History | Record your screen continuously locally and provide context to your agents (Claude, Codex, Openclaw, Hermes, Runner...)
MCP server to provide Figma layout information to AI coding agents like Cursor
Run your own MCP server? See who uses it and what to fix.
Measure it with TrackMCP