skills.rest
wwa-lab
wwa-labOFFICIAL
Explore all skills by this author →
GitHub

legacy-ibmi-data-model-analyzer

Analyze IBM i data models from DDS, DB2 metadata, SQL DDL, and program evidence.

Updated May 12, 2026
Search Tags:#modernization#reverse engineering#IBM i#Legacy Spec Factory#data model analysis
One-click install
npx skills add https://github.com/wwa-lab/legacy-spec-factory --skill legacy-ibmi-data-model-analyzer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: legacy-ibmi-data-model-analyzer
Source: https://github.com/wwa-lab/legacy-spec-factory/tree/main/.opencode/skills/legacy-ibmi-data-model-analyzer
Command: npx skills add https://github.com/wwa-lab/legacy-spec-factory --skill legacy-ibmi-data-model-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires legacy-ibmi-inventory, legacy-ibmi-program-analyzer, legacy-ibmi-flow-analyzer, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill automates the analysis of IBM i data models, significantly reducing the time and effort required for modernization projects.

Core Features & Use Cases

  • Data Model Analysis: Analyze IBM i data models from DDS, DB2 metadata, SQL DDL, and program/flow evidence.
  • Evidence-Backed Output: Produce a comprehensive data model package with dictionary, access paths, CRUD matrix, and SME review checklist.
  • Use Case: When reverse-engineering a business domain's data structure, this Skill can help teams understand the existing data model and prepare for modernization efforts.

Quick Start

Use the legacy-ibmi-data-model-analyzer skill to analyze the customer and order data model in the provided inventory.

Frequently Asked Questions about legacy-ibmi-data-model-analyzer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I reverse engineer an IBM i data model for modernization?▼

To reverse engineer an IBM i data model, this Skill analyzes DDS, DB2 metadata, SQL DDL, and program/flow evidence to produce an evidence-backed data model package supporting modernization efforts.

What is included in the IBM i data model analysis output?▼

The IBM i data model analysis output includes a comprehensive evidence-backed package containing a data dictionary, access paths, a CRUD matrix, and an SME review checklist.

Do I need the legacy-ibmi-inventory skill to analyze DB2 metadata?▼

Yes, analyzing DB2 metadata and producing a full data model package requires the legacy-ibmi-inventory, legacy-ibmi-program-analyzer, and legacy-ibmi-flow-analyzer skills to gather complete program and flow evidence.

Can I analyze DDS and SQL DDL together for IBM i modernization?▼

Yes, you can analyze DDS and SQL DDL together. The Skill extracts and combines DDS, DB2 metadata, SQL DDL, and program evidence to generate a unified, evidence-backed data model package.

What's the best way to generate a CRUD matrix for IBM i data models?▼

The best way to generate a CRUD matrix for IBM i data models is using an automated analyzer that extracts program and flow evidence from DB2 metadata and DDS to map data access accurately.

Why does data model analysis require program and flow evidence?▼

Data model analysis requires program and flow evidence because reverse engineering legacy IBM i systems demands understanding how programs interact with data to build an accurate, evidence-backed modernization model.

Related Skills

Explore More Software Engineering Skills→
wwa-labwwa-lab

legacy-ibmi-module-analyzer

Assemble and validate IBM i business modules from flow analyses and context packages.

Official
Advanced
wwa-labwwa-lab

legacy-ibmi-inventory

Automates inventory of IBM i legacy assets including RPGLE, CLLE, COBOL, and DDS.

Official
Advanced
wwa-labwwa-lab

legacy-ibmi-flow-analyzer

Analyze IBM i program flows and generate program-set core reviews.

Official
Advanced
RebelHawk-TKRebelHawk-TK

positioning-workshop

Guide product teams through a structured positioning discovery workflow.

Community
Intermediate