oracle-aidp-codex

Run the full Oracle AI Data Platform (AIDP) data-engineering surface from Codex in natural language - 37 skills: discover catalog, ask in English, AI-in-SQL, optimize/time-travel, pipelines, clusters, governance, agent flows, MLOps, migration. Self-contained (OCI CLI + api_key DEFAULT profile); the AIDP MCP is an optional accelerator.

37 skills · hooks

Oracle AI Data Platform Workbench Spark connectors for Codex. Includes 27 connector skills for Oracle, OCI, SaaS, JDBC, object storage, streaming, REST, Excel, and multi-cloud data sources, including DB2 guidance. Includes Google BigQuery read-only ingestion and external-catalog guidance.

29 skills

Migrate a Snowflake database to Oracle AI Data Platform with a fixed, auditable runbook. Provisions a migration workspace and cluster, registers the Snowflake database as an EXTERNAL catalog and creates the INTERNAL target catalog, discovers the estate with an in-AIDP workflow, translates types and names into a reviewed plan, creates the target schemas and empty Delta tables on AIDP compute, and registers one copy job per schema (INSERT-SELECT, verified by row counts) for the customer to run. Inventories what is not a table or a view, security posture and table-maintenance state, and presents the data-movement options without choosing for you. Read-only against Snowflake, dry-run by default against AIDP, every create read back; teardown releases the compute or removes everything the migration created.

11 skills · 9 commands

Build and operate Oracle Fusion-to-AIDP medallion pipelines, gold marts, OAC datasets, and MCP-authored workbooks.

16 skills · 1 MCP server

Drive the Oracle AI Data Platform (AIDP) Databricks Migration Toolkit in natural language. Self-contained for Codex: the OpenAI-based Python migration engine ships bundled under engine/ and is staged by the SessionStart hook to ~/.aidp-migrator/engine. Teaches Codex how to plan and execute an automated end-to-end migration of Databricks (Unity Catalog / HMS) notebooks, jobs, schedules, and catalog DDL onto AIDP - Pass-1 dependency resolution plus Pass-2 cell-by-cell execute/verify/fix on a live AIDP cluster using an OpenAI model with tool use. Covers job_migrate.py orchestration, catalog migration, workflow DAG manifest building, fixup_cell rewind, pre-migration data-availability checks, write-redirect sandbox schema, and the acceptance-contract pattern for batch/streaming convergence.

16 skills · hooks

Migrate Informatica ETL onto Oracle AI Data Platform from Codex: mappings become PySpark notebooks, workflows become AIDP jobs carrying the session dependency graph, Quartz schedules and a declarable timezone, with worklets expanded. Reads IDMC/IICS cloud mapping JSON and PowerCenter 10.x repository XML; 8.x and 9.x are refused by a version gate rather than mis-migrated. The transformation compiler is deterministic and needs no model -- an OpenAI key only widens what the rules cannot reach, behind a validator and a hallucination check. Reads and writes are catalog-addressed, so no JDBC URLs or credentials appear in a generated notebook. Anything that cannot be converted faithfully becomes an explicit review item with a named reason and a rebuild path, never a silent approximation.

11 skills · hooks

Migrate a Microsoft Fabric workspace (notebooks, Warehouse T-SQL, OneLake shortcuts) to Oracle AI Data Platform: inventory, plan, translate deterministically, and verify.

1 skill · 5 commands · 1 MCP server

Ask and operate Oracle AI Data Platform resources from Codex through aidp-cli, signed REST, and native SDK Git tools.

1 skill · 1 MCP server

Migrate an AWS data stack (S3, Glue, Athena, EMR, SageMaker) to Oracle AI Data Platform: inventory, plan, translate (deterministic, flag-don't-guess), and verify. Exposed to Codex/Cursor via an MCP server.

1 skill · 1 MCP server