schema-analyzer

Community

Incremental Oracle schema analysis with deps.

Authorhariinfo
Version1.0.0
Installs0

System Documentation

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.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: schema-analyzer
Download link: https://github.com/hariinfo/agentic-code-template/archive/main.zip#schema-analyzer

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.