Mybatis Mapper2sql

Created By

handsomestWeia year 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.

# sql提取

# mybatis

Overview Content Tools Comments

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.

Try in Playground

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

a year ago

Updated At

10 months ago

Author Name

handsomestWei

Star

Language

License

Recommend Servers

View All

Brave Search

@modelcontextprotocol

Web and local search using Brave's Search API

a year ago

Frontrun

@jongall45

VC follow intelligence for AI agents. Track what top investors follow on X — detect new follows, convergence signals, and trending companies before they're announced.

5 days ago