Mybatis Mapper2sql
Overview
what is Mybatis Mapper2sql?
Mybatis Mapper2sql is a tool that automatically extracts SQL statements from MyBatis mapper XML files, enabling efficient SQL testing and analysis.
how to use Mybatis Mapper2sql?
To use Mybatis Mapper2sql, you can run the server with the appropriate command and provide the path to your mapper XML files. The tool will extract SQL statements, mock parameters, and execute tests against a database.
key features of Mybatis Mapper2sql?
- SQL Extraction: Extracts SQL statements from MyBatis mapper XML files.
- Parameter Mocking: Automatically generates SQL parameters based on resultMap and JDBC type inference.
- SQL Testing: Connects to a database to execute SQL and record results.
use cases of Mybatis Mapper2sql?
- Extracting SQL for quick analysis and debugging.
- Testing SQL statements against a live database to ensure correctness.
- Mocking parameters for SQL statements to simulate different scenarios.
FAQ from Mybatis Mapper2sql?
- Can Mybatis Mapper2sql handle all types of SQL?
Yes! It supports various SQL types as long as they are defined in the MyBatis mapper XML files.
- Is Mybatis Mapper2sql free to use?
Yes! It is open-source and available for everyone to use.
- How do I set up Mybatis Mapper2sql?
You need to configure the server with the correct database connection details and run the provided command.
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}"
}
}
}
}Project Info
Created At
10 months agoUpdated At
9 months agoAuthor Name
handsomestWeiStar
-Language
-License
-Recommend Servers
View Allmcp-server-flomo MCP Server
@chatmcp
Write notes to Flomo
JavaScript
a year ago
Tavily Mcp
@tavily-ai
JavaScript
a year ago
Test
@modelcontextprotocol
test
6 months ago
Filesystem
@modelcontextprotocol
2 months ago
Mcp Server Chatsum
@chatmcp
summarize chat message
typescript
a year ago