About Mysql Server
Mysql Server is an MCP server published by JamesSmith888 in the Data category: a Spring AI-based MCP capable of executing any SQL query. 一个基于 Spring AI 的MCP服务，可执行任意 SQL。.
The repository has 26 stars and 5 forks, with the last commit a year ago. Six months or more without a commit doesn't mean the server is broken, but check the open issues before depending on it in production.
Install
git clone https://github.com/JamesSmith888/mcp-mysql-serverThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Ask AI
Ask AI about Mysql Server
Powered by Claude · Grounded in docs
Security checks
Static checks derived from the repository 3 hours ago. Heuristics on the source, not an audit.
- ✓README presentThe repository ships documentation.
- !License declaredNo license file. Legally you have no right to use it in a product.
- ✓Tests presentA test suite exists in the repository.
- !Dependencies pinnedNo lockfile. Installs can pull different code over time.
- ✓No dynamic code executionSource scan found no eval, dynamic Function, or shell execution.
- !Scoped permissionsDoesn't declare a permission scope. Assume it can do anything its process can.
README
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+
README fetched from the repository 3 hours ago. The original is authoritative.