skills.rest
Percona-Lab
Percona-LabOFFICIAL
Explore all skills by this author →
GitHub

oracle-to-percona

Map Oracle schemas and PL/SQL to Percona Server for MySQL.

1|1|Updated May 29, 2026
Search Tags:#migration#oracle#mysql#data-types#plsql#percona
One-click install
npx skills add https://github.com/Percona-Lab/skills --skill oracle-to-percona
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: oracle-to-percona
Source: https://github.com/Percona-Lab/skills/tree/main/oracle-to-percona
Command: npx skills add https://github.com/Percona-Lab/skills --skill oracle-to-percona

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Migrating Oracle databases to Percona Server for MySQL requires substantial schema and code rewrites because Oracle compatibility is not available in MySQL/Percona. This migration involves translating data types, SQL constructs, and PL/SQL logic into MySQL-compatible equivalents to ensure correctness and performance.

Core Features & Use Cases

  • Data-type mapping guidance (e.g., NUMBER to DECIMAL, VARCHAR2 to VARCHAR with utf8mb4)
  • PL/SQL to SQL/PSM rewrites and procedural translation guidance
  • Schema and code translation patterns for common Oracle constructs (ROWNUM, CONNECT BY, sequences) and recommended tooling
  • Use cases include migrating a standalone schema, a suite of PL/SQL packages, or an application relying on Oracle-specific features to Percona Server for MySQL

Quick Start

Provide your Oracle schema definitions and sample PL/SQL to generate an initial migration plan.

Frequently Asked Questions about oracle-to-percona

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

FAQPage Schema
How do I migrate Oracle schemas to Percona Server for MySQL?▼

Migrating Oracle schemas to Percona Server for MySQL requires mapping Oracle data types like NUMBER to DECIMAL and VARCHAR2 to VARCHAR using utf8mb4. You provide Oracle schema definitions to generate an initial migration plan and rewrite Oracle-specific constructs.

What is the best way to convert PL/SQL packages to MySQL stored procedures?▼

Converting PL/SQL packages to MySQL stored procedures involves translating PL/SQL logic into MySQL-compatible SQL/PSM rewrites. You provide sample PL/SQL to generate procedural translation guidance and ensure Oracle constructs are rewritten to MySQL equivalents.

How do I rewrite Oracle ROWNUM and CONNECT BY queries for MySQL 8.0+?▼

Rewriting Oracle ROWNUM and CONNECT BY queries for MySQL 8.0+ requires replacing them with MySQL equivalents using 8.0+ features. The migration process provides schema and code translation patterns for these common Oracle constructs to ensure correctness.

Can I use AWS Schema Conversion Tool to port Oracle sequences to Percona MySQL?▼

AWS Schema Conversion Tool can be used to port Oracle sequences to Percona MySQL as part of your migration strategy. The process requires applying best practices for tooling like AWS Schema Conversion Tool and MySQL Workbench migration wizard.

What are the limitations of migrating Oracle databases to Percona Server for MySQL?▼

Migrating Oracle databases to Percona Server for MySQL requires substantial schema and code rewrites because Oracle compatibility is not available in MySQL or Percona. You must translate data types, SQL constructs, and PL/SQL logic manually to ensure correctness and performance.

Related Skills

Explore More Software Engineering Skills→
jeremylongshorejeremylongshore
2.6k

generating-stored-procedures

Generate stored procedures, functions, and triggers for PostgreSQL, MySQL, and SQL Server.

Community
Intermediate
arrowInkneeeeearrowInkneeeee
1

db-migration-generator

Generate SQL migration scripts for schema changes across multiple databases.

Community
Intermediate
wfukatsuwfukatsu
12

migrate-mysql-to-scalardb

Automate MySQL schema migration to ScalarDB with data type mapping and step-by-step instructions.

Community
Advanced
wfukatsuwfukatsu
12

migrate-database

Automates Oracle, MySQL and PostgreSQL migrations to ScalarDB with schema analysis and documentation generation.

Community
Advanced