MCP MySQL Server
About
An MCP server based on Spring AI that executes arbitrary SQL queries against a configured MySQL database.
Details
- Author
- JamesSmith888
- GitHub stars
- 26
- Downloads
- 259
- Categories
- Database
Jump to
- Multi-datasource support (configure multiple MySQL databases)
- Dynamic datasource switching at runtime
- Groovy script based extension functionality
- SQL security control (prevents dangerous operations)
- Built on Spring AI framework
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MCP MySQL ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Configure the MCP server in JSON by either using Maven Wrapper (mvnw spring-boot:run) or running a packaged JAR (java -jar ...). Supply the -Dloader.path argument to enable extended Groovy features. Then set up datasources in datasource.yml, marking one as default with default: true.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mcp mysql server": {
"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"
]
}
}
}
}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"
]
}
}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+
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
