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.

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

-

Category

Tags

Homepage

https://github.com/handsomestWei/mybatis-mapper2sql-mcp-server

Recommend Servers

Aws Kb Retrieval Server

@modelcontextprotocol

An MCP server implementation for retrieving information from the AWS Knowledge Base using the Bedrock Agent Runtime.

a year ago

Croatia Payments Mcp

@junter1989k-ai

12 days ago

Zambia Payments Mcp

@junter1989k-ai

12 days ago

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

TypeScript

a year ago

@modelcontextprotocol

Location services, directions, and place details

a year ago

Ukraine Payments Mcp

@junter1989k-ai

12 days ago

Greece Payments Mcp

@junter1989k-ai

12 days ago

EdgeOne Pages MCP

@TencentEdgeOne

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

TypeScript

a year ago

Kenya Payments Mcp

@junter1989k-ai

12 days ago

Xiangguangyu Skills

5 AI skills as MCP tools: MBTI relationship sandbox (2-20 people), fact-checking (3 methods: source-tracing, cross-reference, logic-check), deep business analysis (5-layer), game audio brief generator, weekly skill radar. All monetized via Alipay AI Pay (¥0.10-0.50/call).

12 days ago

Lithuania Payments Mcp

@junter1989k-ai

12 days ago

@modelcontextprotocol

GitLab API, enabling project management

a year ago

Senegal Payments Mcp

@junter1989k-ai

12 days ago

302_sandbox_mcp

Create a remote sandbox that can execute code/run commands/upload and download files. 创建远程沙盒，可以执行代码/运行命令/上传下载文件

a year ago

Hungary Payments Mcp

@junter1989k-ai

12 days ago

Denmark Payments Mcp

@junter1989k-ai

12 days ago

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.

6 days ago

Songcheck Ai Music Detector

@afghanfansmedia-ai

Is this song AI or human? SongCheck detects AI-generated music (Suno, Udio, and more) and media from any AI agent. Point it at an audio file, an image/video, or a whole music folder and it returns a verdict (LIKELY AI-GENERATED / UNCERTAIN / LIKELY HUMAN), an AI-probability score, confidence, and provenance signals (Content Credentials / SynthID watermark, generator hints). Tools: detect_ai_music, detect_ai_media, scan_catalog (audit an entire catalog), and songcheck_health. Free tier is 5 checks/day; a paid key unlocks unlimited catalog scans. Powered by SongCheck (Khaled Media), a self-hosted v9 ensemble detector.

7 days ago

MCP Server for Milvus

The Milvus MCP server enables AI applications to interact with Milvus vector databases using natural language commands. It allows AI models to perform vector searches, manage collections, and retrieve data without writing custom database queries. This integration facilitates seamless access to vector data, enhancing the capabilities of AI tools like Claude Desktop and Cursor.

a year ago

Czechia Payments Mcp

@junter1989k-ai

12 days ago

Ivory Coast Payments Mcp

@junter1989k-ai

12 days ago

Arcgis Portal Mcp

MCP server for ArcGIS Portal and ArcGIS Online. Lets AI assistants search content, query feature layers, manage features, handle content operations, and administer users and groups. Built on the Model Context Protocol for integration with Claude Desktop, Cursor, VS Code Copilot, and other MCP clients. Disclaimer: This is an independent open-source project. It is not affiliated with, endorsed by, or sponsored by Esri Inc. "ArcGIS" is a registered trademark of Esri.

12 days ago

Mcp Server Chatsum

summarize chat message

typescript

a year ago

France Payments Mcp

@junter1989k-ai

12 days ago

Persistent Adaptive Planning Intelligence - structured loop engineering for AI coding assistants, with memory that persists across sessions, tools, and teammates.

12 days ago

South Africa Payments Mcp

@junter1989k-ai

12 days ago

高德地图官方 MCP Server

a year ago

Bulgaria Payments Mcp

@junter1989k-ai

12 days ago

Malta Payments Mcp

@junter1989k-ai

12 days ago

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

a year ago