概览
What is Mybatis Mapper2sql?
A Model Context Protocol (MCP) service that extracts SQL statements from MyBatis mapper XML files, optionally mocks parameters using resultMap and JDBC type inference, and tests SQL against a database. It is aimed at developers who need deterministic SQL analysis and AI collaboration.
How to use Mybatis Mapper2sql?
—
Key features of Mybatis Mapper2sql
- Extracts SQL from MyBatis mapper XML files
- Automatically mocks SQL parameters based on type inference
- Tests extracted SQL by connecting to a real database
- Uses MyBatis’s official parsing engine for deterministic results
- Supports multiple database types
Use cases of Mybatis Mapper2sql
- Quickly reviewing SQL structure from mapper files without parameter details
- Generating executable SQL with mocked parameters for offline analysis
- Validating SQL correctness by running it against a live database
FAQ from Mybatis Mapper2sql
What databases does Mybatis Mapper2sql support?
It supports multiple database types through JDBC connections.
What input does Mybatis Mapper2sql require?
The server expects a file path to a mapper XML file or a directory containing such files.
What tools does Mybatis Mapper2sql provide?
Three tools: parse_mapper (basic extraction), parse_mapper_and_mock (extraction with parameter mocking), and parse_mapper_and_run_test (extraction, mocking, and execution).
How does Mybatis Mapper2sql mock parameters?
It automatically generates SQL parameters based on resultMap definitions and JDBC type inference.
