masterdata-schema-inspector

Schema extraction identifies table definitions, constraints, and ENUM options from a PascalCase model name. Pass the model name (e.g., OprGacha, MstUnit) to retrieve NOT NULL constraints, DEFAULT values, and complete field structure in structured format.

Yes. The Skill analyzes schema definitions to expose CSV structure and existing data patterns. It generates Markdown-formatted templates and structured outputs showing column names, types, and constraints for rapid template creation.

The Skill works with PascalCase model names for master data tables (OprGacha, MstUnit, MstAdventBattle, MstAbility). It converts these names to corresponding table definitions and queries schema JSON to extract complete metadata.

Provide the model name to retrieve all ENUM options and valid choices stored in schema definitions. The Skill parses schema JSON and surfaces enumeration values alongside field constraints in the output.

Output includes Markdown-formatted summaries, structured JSON suitable for RAG pipelines, CSV templates, and existing data pattern analysis. All outputs contain complete constraint information, field definitions, and ENUM metadata.

jq is the only dependency required. The Skill uses jq to parse and query schema JSON files, making it lightweight for environments where schema data is already available in JSON format.