sql-extract-ddl-oracle-mcp
CommunityExport Oracle DDLs to Flyway-ready migrations.
Authordiegolirio
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill automates extracting a complete Oracle schema DDL via MCP and converts it into Flyway-compatible SQL migrations, enabling reproducible database deployment and versioning across environments.
Core Features & Use Cases
- Extracts all DDL objects (types, sequences, tables, views, indexes, triggers, procedures, functions, packages, synonyms) in a dependency-safe order suitable for clean-schema migrations.
- Writes migrations to migrations-staging/ with Flyway-style filenames and 1000-line split rules, ensuring manageable deployment units.
- Produces only SQL migration files (no scripts or non-SQL artifacts), ready for integration into CI/CD pipelines.
Quick Start
Run the skill to export all DDLs from your Oracle schema as Flyway-compatible migrations into migrations-staging.
Dependency Matrix
Required Modules
None requiredComponents
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: sql-extract-ddl-oracle-mcp Download link: https://github.com/diegolirio/ai-showcase-skills/archive/main.zip#sql-extract-ddl-oracle-mcp Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 510,000+ vetted skills library on demand.