Audit MyBatis Mapper XML for SQL mappings and ResultMap issues.
npx skills add https://github.com/HTRTan/paperclip-skills --skill mybatis-schema
Please help me install this Agent Skill. Skill: mybatis-schema Source: https://github.com/HTRTan/paperclip-skills/tree/main/skills/mybatis-schema Command: npx skills add https://github.com/HTRTan/paperclip-skills --skill mybatis-schema
Provide a structured guide to audit and optimize MyBatis Mapper XML, including ResultMap design, type alias management, dynamic SQL crafting, and careful tradeoffs between annotations and XML, with templates, anti-pattern detection, and performance tips.
Load your MyBatis Mapper XML files and apply the standard anti-pattern checks to generate a prioritized remediation plan.
High-intent search queries and answers about installing and using this skill.
Auditing MyBatis Mapper XML involves loading your files to check SQL readability, parameter mappings, and ResultMap correctness, generating a prioritized remediation plan for identified anti-patterns.
Advanced ResultMaps in MyBatis use associations, collections, and discriminators to map nested results, while properly configuring type aliases and TypeHandlers to ensure accurate data representation.
Dynamic SQL in MyBatis is crafted using <if>, <foreach>, and <choose> tags alongside SQL fragments to build flexible query templates that adapt to varying runtime parameters.
Choosing XML mappers over annotations in MyBatis depends on complexity; XML suits advanced ResultMaps and dynamic SQL templates, while annotations often fit simpler single-table scenarios.
Optimizing MyBatis performance for joined and nested queries involves auditing ResultMap structures, eliminating anti-patterns, and applying targeted dynamic SQL template improvements.
xmx0632Analyze MyBatis SQL to identify performance bottlenecks and provide optimization recommendations.
chrysaliscatOptimize MySQL queries, MyBatis XML mappings, and schema design.
jeremylongshoreGenerate ORM models and database schemas across multiple frameworks.
LuohaothuDesign and optimize JPA/Hibernate entity models and repositories for Spring Boot applications.
