Skills
.Work. You
Rest

oracle-migration

Community

Automate Oracle ADB migrations with headers.

Software Engineering#automation#devops#migration#oracle#code-generation#ddl-patterns
Authoracedergren
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Manually creating Oracle ADB 26AI migrations is error-prone and time-consuming; this Skill automates the process by generating properly numbered migration files with standardized headers and DDL patterns, ensuring consistency across the project.

Core Features & Use Cases

  • Auto-increment migration numbering by scanning existing migrations in apps/frontend/src/lib/server/oracle/migrations and creating the next NNN-name.sql file.
  • Enforces the migration header format and file naming conventions, including Created date and description.
  • Applies Oracle-specific DDL patterns (primary keys, timestamps, JSON constraints, foreign keys, org scoping, vector columns, and indexing) to ensure production-ready migrations.
  • Creates migrations directly in the project structure for seamless integration with the self-service portal's deployment workflow.

Quick Start

Run the oracle-migration skill to generate the next migration file by scanning existing migrations and applying the standard header and DDL patterns.

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: oracle-migration
Download link: https://github.com/acedergren/oci-self-service-portal/archive/main.zip#oracle-migration

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 223,000+ vetted skills library on demand.