MCP MySQL Server
An MCP server based on Spring AI that executes arbitrary SQL queries against a configured MySQL database.
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+
Related Servers
ThoughtSpot MCP Server
Securely query and retrieve data from your ThoughtSpot instance.
CoinCap
A MCP server that provides real-time cryptocurrency market data through CoinCap's public API without requiring authentication
Metabase MCP Server
Integrates AI assistants with the Metabase business intelligence and analytics platform.
Secret Network
Provides secure access to Secret Network blockchain functionality, designed for deployment in Trusted Execution Environments (TEEs).
memory-v2
Brain-inspired persistent memory MCP server with hybrid BM25+vector search, ACT-R activation scoring, FadeMem decay, and knowledge graphs — 17 tools, fully local via Ollama, zero API keys.
Simple PostgreSQL MCP Server
An MCP server for interacting with PostgreSQL databases using tools, resources, and prompts.
Blackbaud FE NXT by CData
A read-only MCP server for Blackbaud FE NXT by CData, enabling LLMs to query live data. Requires a separate CData JDBC Driver.
dbt-docs
MCP server for dbt-core (OSS) users as the official dbt MCP only supports dbt Cloud. Supports project metadata, model and column-level lineage and dbt documentation.
FinBrain MCP
Access institutional-grade alternative financial data directly in your LLM workflows.
CData MYOB AccountRight
A read-only MCP server for MYOB AccountRight, enabling LLMs to query live data using the CData JDBC Driver.