MyBatis Mapper2SQL MCP

Name: MyBatis Mapper2SQL MCP
Author: handsomestWei

handsomestWeiChina

Get started Repository

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

Setup

Choose your client, copy the config, then fill in any required environment variables.

Add to Cursor Add to 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>"
      }
    }
  }
}

Environment variables

JAVA_HOME
PATH

Replace the placeholders with your own credentials and keep them out of version control.

Setup

Environment variables

Related