mapper-to-api-spec

What problem does it solve?

This Skill automates the complex and time-consuming process of analyzing SQL Server Mapper files (like MyBatis or JPA) and automatically generating comprehensive RESTful API specifications. It bridges the gap between direct database access and modern API-driven architectures.

Core Features & Use Cases

• Automated API Specification Generation: Analyzes SQL Server Mapper configurations (MyBatis XML/Java, JPA) to derive API endpoints, request/response structures, and OpenAPI 3.0 specifications.
• Mapper to API Mapping: Creates detailed documentation mapping original Mapper methods to their corresponding API endpoints, including how parameters are translated and how merged methods can be restored.
• RESTful Design Adherence: Designs APIs following RESTful best practices, including correct HTTP method usage, resource naming, and parameter standardization.
• Use Case: Imagine a legacy system with extensive direct database access via MyBatis Mappers. This Skill can analyze those Mappers and generate a complete OpenAPI specification for a new RESTful API layer, significantly accelerating the migration to an API-first architecture.

Quick Start

Use the mapper-to-api-spec skill to analyze the SQL Server Mapper files located at D:\workspace\oms\OMS_StudyProgress\dal_products and generate the corresponding API specification documents.