Mybatis Mapper2sql

Created By

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

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.

ChatWiseThe second fastest AI chatbot™

RedisA Model Context Protocol server that provides access to Redis databases. This server enables LLMs to interact with Redis key-value stores through a set of standardized tools.

Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。

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

Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题； Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"

MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs

DeepChatYour AI Partner on Desktop

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

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