Mysql MCP Server For Java

@6000fish

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

6000fish

提交者

qianyu liu

关于 Mysql MCP Server For Java

Java 生态的 MCP 基础设施，包含 SDK + 常用 Server 实现

#v0-1-1

Mysql MCP Server For Java 配置

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

{
  "mcpServers": {
    "mysql": {
      "type": "stdio",
      "command": "java",
      "args": [
        "-jar",
        "/absolute/path/to/mcp-java/mcp-server-collection/mcp-server-mysql/target/mcp-server-mysql-0.1.1.jar"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_DATABASE": "mcp_demo",
        "MYSQL_USERNAME": "root",
        "MYSQL_PASSWORD": "your_password"
      }
    }
  }
}

Mysql MCP Server For Java 工具

工具列表暂未提供

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

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

概览

What is Mysql Mcp Server For Java?

Mysql Mcp Server For Java is a ready-to-run MySQL database server implementation for the Model Context Protocol (MCP), built with the MCP Java SDK. It allows MCP clients (e.g., Claude Code, Codex) to connect to a MySQL database and perform SQL operations through natural language.

How to use Mysql Mcp Server For Java?

Build the jar with mvn package -pl mcp-server-collection/mcp-server-mysql -am -DskipTests. Then configure your MCP client’s mcpServers entry with "type": "stdio", the java command pointing to the generated jar, and environment variables MYSQL_HOST, MYSQL_PORT, MYSQL_DATABASE, MYSQL_USERNAME, MYSQL_PASSWORD. Restart the client and the server tools become available.

Key features of Mysql Mcp Server For Java

Built with the MCP Java SDK for custom MCP servers.
Uses stdio transport for local Agent integration.
Exposes seven MySQL tools: query, execute, list_databases, list_tables, describe_table, explain_query, get_table_status.
Ready-to-run jar with no additional project setup.
Verified compatibility with Claude Code and Codex clients.

Use cases of Mysql Mcp Server For Java

Allow AI agents to run natural-language SQL queries against a MySQL database.
Enable schema exploration (list databases, tables, describe columns) through MCP.
Execute administrative SQL commands via an MCP-enabled chat interface.
Integrate MySQL data access into MCP-based workflow automation tools.

常见问题

What runtime dependencies are required?

Java 17+ and a running MySQL server accessible via the configured environment variables.

How does Mysql Mcp Server For Java handle authentication?

Credentials are passed through environment variables (`MYSQL_USERNAME`, `MYSQL_PASSWORD`) at configuration time. No secrets are stored in the jar.

Where does the data live?

Data remains in the MySQL database. The server only sends SQL queries and receives results; it does not store any data locally.

What transport does it support?

Only stdio transport is supported. The server communicates over standard input/output, suitable for local MCP clients.

Is it compatible with all MCP clients?

It has been verified with Claude Code and Codex. Other clients that follow the standard stdio JSON-RPC MCP protocol should work with the documented configuration.