Agent skill · software engineering · jeremylongshore
oraclecloud-schema-migration
Migrate to OCI Autonomous Database \u2014 wallet setup, mTLS, Data Pump,\
Why this skill is useful
Adds executable scripts for provisioning and migrating to OCI Autonomous Database, including wallet setup and mTLS configuration that are not commonly documented.
What it needs
Requires oci, oracledb installed locally. Requires oraclecloud account access. About 5k tokens when loaded. Last updated 2026-08-07. 2,604 stars on the source repository.
What this skill does
OCI Autonomous Database — Migration & Connection Overview Migrate to and connect with OCI Autonomous Database (ADB) using the Python SDK and python-oracledb. Autonomous Database is OCI's crown jewel but migrating to it from standard Oracle DB or other databases is full of gotchas — wallet downloads require SDK calls (not just console clicks), mTLS is mandatory by default, connection strings use a different format than standard Oracle, and Data Pump exports need specific parameter adjustments for ADB compatibility. Purpose: Provision an Autonomous Database, download the wallet, establish a connection, and migrate data using Data Pump. Prerequisites OCI Python SDK — pip install oci Oracle DB driver — pip install oracledb Config file at ~/.oci/config with fields: user, fingerprint, tenancy, region, keyfile IAM policy — Allow group Developers to manage autonomous-databases in compartment <name> Python 3.8+ For Data Pump: access to the source Oracle database with DBA privileges Instructions Step 1: Provision an Autonomous Database Step 2: Wait for Provisioning and Download Wallet The wallet contains certificates and connection descriptors needed for mTLS. You must download it via the SDK — the wallet password is set at download time, not during provisioning. Step 3: Connect Using python-oracledb (Thin Mode) python-oracledb thin mode does not require Oracle Client libraries. It connects directly using the wallet files. Step 4: Data Pump Export from Source Database Data Pump is the standard Oracle tool for bulk data migration. These parameters ensure ADB compatibility. Critical ADB exclusions: ADB manages its own indexes, clusters, and materialized views. Including them causes import failures. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills jeremylongshore/oraclecloud-schema-migration