广告合作
MCP.so
登录

MCP MySQL Server

@JamesSmith888

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

JamesSmith888

关于 MCP MySQL Server

A Spring AI-based MCP capable of executing any SQL query. 一个基于 Spring AI 的MCP服务，可执行任意 SQL。

MCP MySQL Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "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 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MCP MySQL Server?

MCP MySQL Server is a Spring AI based MCP (Model Context Protocol) server that can execute arbitrary SQL queries on MySQL databases. It supports multiple datasources, dynamic switching, Groovy script extensions, and SQL security controls. It is intended for developers integrating AI models with MySQL databases.

How to use MCP MySQL Server?

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.

Key features of MCP MySQL Server

  • 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

Use cases of MCP MySQL Server

  • Allow an AI assistant to query a MySQL database on demand.
  • Manage multiple database connections and switch between them dynamically.
  • Extend query capabilities with custom Groovy scripts for specific business logic.
  • Safely expose SQL operations to AI models while preventing harmful statements.

常见问题

1

What does MCP MySQL Server do?

It is a Spring AI based MCP server that enables AI models to execute arbitrary SQL on configured MySQL databases.

2

How do I configure datasources?

Edit `mcp-mysql-server/src/main/resources/datasource.yml` and specify the JDBC URL, username, password, and optionally set one datasource as `default: true`.

3

What are the runtime requirements?

JDK 21+ and Maven 3.6+ are required.

4

Can MCP MySQL Server work with other databases?

No, it is MySQL specific. For other databases, please see the related [mcp-db-server](https://github.com/JamesSmith888/mcp-db-server) project.

5

How do I enable advanced extensions?

Use the `-Dloader.path` argument when starting via JAR to point to a directory containing Groovy scripts.

评论

数据库 分类下的更多 MCP 服务器

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K
广告合作