Mysql Mcp Server For Java

Name: Mysql Mcp Server For Java
Author: 6000fish

@6000fish

Repository

About Mysql Mcp Server For Java

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

#v0-1-1

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "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"
      }
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.