Mysql Mcp Server For Java

Name: Mysql Mcp Server For Java
Author: 6000fish

@6000fish

代码仓库

关于 Mysql Mcp Server For Java

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

#v0-1-1

基本信息

分类

数据库

许可证

MIT

运行时

java

传输方式

stdio

发布者

6000fish

提交者

qianyu liu

配置

使用下面的配置,将此服务器添加到你的 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"
      }
    }
  }
}

工具

未检测到工具

工具是从 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.

FAQ from Mysql Mcp Server For Java

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.