広告掲載
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.

コメント

「データベース」の他のコンテンツ

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539
広告掲載