skills.rest
hariinfo
hariinfoCOMMUNITY
Explore all skills by this author →
GitHub

schema-analyzer

Catalog Oracle database objects from DDL into an incremental inventory with dependency gap detection.

Updated Mar 22, 2026
Search Tags:#schema#analysis#migration#oracle#inventory#dependency#ddl
One-click install
npx skills add https://github.com/hariinfo/agentic-code-template --skill schema-analyzer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema-analyzer
Source: https://github.com/hariinfo/agentic-code-template/tree/main/.claude/skills/schema-analyzer
Command: npx skills add https://github.com/hariinfo/agentic-code-template --skill schema-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Oracle database schema analysis is error-prone and manual; this Skill provides controlled, incremental cataloging of objects with dependency gap detection to support migration readiness.

Core Features & Use Cases

  • Incremental cataloging of tables, procedures, functions, and packages from user-provided DDL to build oracle-inventory.json over multiple runs
  • Dependency gap detection when FK or PLSQL references point to objects not yet provided
  • Out-of-scope awareness for triggers, sequences, views, and other references, with explicit flags
  • Supports generation of schema-analysis.md and relationship mapping for migration planning

Quick Start

Paste your Oracle DDL into the prompt to start cataloging objects into the incremental inventory.

Frequently Asked Questions about schema-analyzer

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

FAQPage Schema
How do I analyze Oracle DDL for schema migration readiness?▼

Oracle DDL analysis for migration readiness involves cataloging tables, constraints, and PLSQL packages while detecting dependency gaps. Paste your DDL into the prompt to incrementally build an inventory and flag missing references across runs.

What is dependency gap detection in Oracle schema inventory?▼

Dependency gap detection identifies when foreign key or PLSQL references point to objects not yet provided in your DDL. It tracks missing references across runs to ensure complete schema coverage before migration.

Can I catalog Oracle packages and procedures incrementally from DDL?▼

Incremental cataloging of Oracle packages and procedures works by processing user-provided DDL across multiple runs. It captures PLSQL objects into oracle-inventory.json while tracking updates and maintaining dependency relationships.

Does this Oracle schema analysis tool handle triggers and sequences?▼

Triggers, sequences, and views are flagged as out-of-scope objects during Oracle schema analysis. The tool explicitly marks these references rather than cataloging them, maintaining awareness of dependencies it cannot fully inventory.

What artifacts are generated from Oracle schema dependency analysis?▼

Oracle schema dependency analysis generates oracle-inventory.json and schema-analysis.md artifacts. These files capture cataloged objects, dependency relationships, and gap detection results to support migration planning.

Related Skills

Explore More Software Engineering Skills→
cliffthelincliffthelin

reversa-data-master

Generate ERD, data dictionary, relationship map, and business-rules inventory from schema evidence.

Community
Advanced
pingcap-incpingcap-inc
2

oracle-to-tidb-migration

Assess Oracle compatibility and migrate schemas, PL/SQL, and data to TiDB Cloud.

Official
Advanced
rangerrick337rangerrick337
10

skill-creator

Create Claude skills with SKILL.md frontmatter and package them into .skill files.

Community
Advanced
hdtinh57hdtinh57
1

database

Design database schemas and migration plans with rollback guidance.

Community
Advanced