MyBatis Mapper2SQL MCP

Name: MyBatis Mapper2SQL MCP
Author: handsomestWei

handsomestWei国内厂商

开始使用源码仓库

从 MyBatis mapper XML 提取 SQL 并自动填充参数，可执行测试并记录结果，无需运行整个项目。

接入配置

选择客户端，复制配置，再按项目文档补齐环境变量。

一键添加到 Cursor 一键添加到 VS Code

claude mcp add mybatis-mapper2sql --env JAVA_HOME='<JAVA_HOME>' --env PATH='<PATH>' -- java -DdbType=mysql -DjdbcDriver=com.mysql.cj.jdbc.Driver -DjdbcDriverJar=/path/to/mysql-connector-java-8.0.33.jar -DjdbcUrl=jdbc:mysql://localhost:3306/testdb -DuserName=root -Dpassword=your_password_here -jar mapper2sql-mcp-server-1.0.0.jar

~/.codex/config.toml

[mcp_servers.mybatis-mapper2sql]
command = "java"
args = ["-DdbType=mysql", "-DjdbcDriver=com.mysql.cj.jdbc.Driver", "-DjdbcDriverJar=/path/to/mysql-connector-java-8.0.33.jar", "-DjdbcUrl=jdbc:mysql://localhost:3306/testdb", "-DuserName=root", "-Dpassword=your_password_here", "-jar", "mapper2sql-mcp-server-1.0.0.jar"]
env = { JAVA_HOME = "<JAVA_HOME>", PATH = "<PATH>" }

# codex mcp add mybatis-mapper2sql --env JAVA_HOME='<JAVA_HOME>' --env PATH='<PATH>' -- java -DdbType=mysql -DjdbcDriver=com.mysql.cj.jdbc.Driver -DjdbcDriverJar=/path/to/mysql-connector-java-8.0.33.jar -DjdbcUrl=jdbc:mysql://localhost:3306/testdb -DuserName=root -Dpassword=your_password_here -jar mapper2sql-mcp-server-1.0.0.jar

~/.cursor/mcp.json

{
  "mcpServers": {
    "mybatis-mapper2sql": {
      "command": "java",
      "args": [
        "-DdbType=mysql",
        "-DjdbcDriver=com.mysql.cj.jdbc.Driver",
        "-DjdbcDriverJar=/path/to/mysql-connector-java-8.0.33.jar",
        "-DjdbcUrl=jdbc:mysql://localhost:3306/testdb",
        "-DuserName=root",
        "-Dpassword=your_password_here",
        "-jar",
        "mapper2sql-mcp-server-1.0.0.jar"
      ],
      "env": {
        "JAVA_HOME": "<JAVA_HOME>",
        "PATH": "<PATH>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "mybatis-mapper2sql": {
      "type": "stdio",
      "command": "java",
      "args": [
        "-DdbType=mysql",
        "-DjdbcDriver=com.mysql.cj.jdbc.Driver",
        "-DjdbcDriverJar=/path/to/mysql-connector-java-8.0.33.jar",
        "-DjdbcUrl=jdbc:mysql://localhost:3306/testdb",
        "-DuserName=root",
        "-Dpassword=your_password_here",
        "-jar",
        "mapper2sql-mcp-server-1.0.0.jar"
      ],
      "env": {
        "JAVA_HOME": "<JAVA_HOME>",
        "PATH": "<PATH>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "mybatis-mapper2sql": {
      "command": "java",
      "args": [
        "-DdbType=mysql",
        "-DjdbcDriver=com.mysql.cj.jdbc.Driver",
        "-DjdbcDriverJar=/path/to/mysql-connector-java-8.0.33.jar",
        "-DjdbcUrl=jdbc:mysql://localhost:3306/testdb",
        "-DuserName=root",
        "-Dpassword=your_password_here",
        "-jar",
        "mapper2sql-mcp-server-1.0.0.jar"
      ],
      "env": {
        "JAVA_HOME": "<JAVA_HOME>",
        "PATH": "<PATH>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "mybatis-mapper2sql": {
      "command": "java",
      "args": [
        "-DdbType=mysql",
        "-DjdbcDriver=com.mysql.cj.jdbc.Driver",
        "-DjdbcDriverJar=/path/to/mysql-connector-java-8.0.33.jar",
        "-DjdbcUrl=jdbc:mysql://localhost:3306/testdb",
        "-DuserName=root",
        "-Dpassword=your_password_here",
        "-jar",
        "mapper2sql-mcp-server-1.0.0.jar"
      ],
      "env": {
        "JAVA_HOME": "<JAVA_HOME>",
        "PATH": "<PATH>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "mybatis-mapper2sql": {
      "command": "java",
      "args": [
        "-DdbType=mysql",
        "-DjdbcDriver=com.mysql.cj.jdbc.Driver",
        "-DjdbcDriverJar=/path/to/mysql-connector-java-8.0.33.jar",
        "-DjdbcUrl=jdbc:mysql://localhost:3306/testdb",
        "-DuserName=root",
        "-Dpassword=your_password_here",
        "-jar",
        "mapper2sql-mcp-server-1.0.0.jar"
      ],
      "env": {
        "JAVA_HOME": "<JAVA_HOME>",
        "PATH": "<PATH>"
      }
    }
  }
}

需要的环境变量

JAVA_HOME
PATH

把占位值换成你自己的密钥；不要把密钥提交到代码仓库。

接入配置

需要的环境变量

相关推荐