9 months ago
Automatically extract SQL statements from MyBatis mapper XML files. Support automatic mocking of SQL parameters, and support automatic connection to the database to execute SQL tests and output results.
Server Config
{
"mcpServers": {
"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": "/path/to/jdk17",
"PATH": "/path/to/jdk17/bin;${PATH}"
}
}
}
}