Mybatis Mapper2sql

Created By

handsomestWei4 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.

# 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.

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}"
      }
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

ChatWiseThe second fastest AI chatbot™

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

Playwright McpPlaywright MCP server

MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.

EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.

TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.

Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

DeepChatYour AI Partner on Desktop

BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.

WindsurfThe new purpose-built IDE to harness magic