oracle-samples/oracle-aidp-samples
Command
Pre-migration data-availability scan. Reads a manifest, probes every spark.read. / saveAsTable target on the AIDP cluster, reports OK / MISSING / EMPTY.
oracle-samples/oracle-aidp-samples
Command
Guided catalog migration flow. Extract Databricks Unity Catalog / HMS metadata, preview the 18-rule DDL rewrite, then batched replay on AIDP. Asks before destructive replay step.
oracle-samples/oracle-aidp-samples
Command
Guided full-job migration flow. Walks the user from "I want to migrate this Databricks job" through DAG → data check → migrate → status, asking before each phase.
oracle-samples/oracle-aidp-samples
Command
Parse + summarize the JOBREPORT.md produced by a prior migration run. Surfaces cell pass/fail/fix counts per task, lists the failing cells, and recommends a next-step skill (fixup-cell, resume, or all-clear).
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
YAML-driven acceptance contract for batch and streaming pipelines that need convergence verification, not just "no exceptions". Declares PASS only after K consecutive zero-result windows (consecutive-zero-window convergence). Use for streaming jobs, slowly-draining backfills, or any pipeline whose success is "the…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Configure the s3:// → oci:// bucket / namespace mapping the migrator uses to rewrite paths during notebook + catalog migration. Use when (a) the user has external tables / files at s3:// paths that need to land on OCI Object Storage, OR (b) checkdataavailability reports "S3 bucket X not found in OCI bucket mapping"…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Build a migration manifest (the execution DAG) from a Databricks workspace path or workflow ID. Walks %run dependency chains, captures dbutils.notebook.run invocations, and emits reports/ manifest.json — the input every other execute-skill consumes. Use when the user wants to see what would migrate, or before invoking…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Pre-migration data-availability scan. Reads every notebook in a migration manifest, extracts every spark.read.table / spark.read.parquet / saveAsTable reference, and probes whether each target schema/table/path exists on the AIDP cluster BEFORE you spend Pass-2 cluster time. Use after aidp-build-dag and before…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Targeted rewind of a migrated notebook. Re-executes cells from history index N onwards (or a specific cell range) through the execute+verify+fix loop, with a 'why' reason injected so Claude knows what to fix. Use when aidp-migrate-job left a notebook at RESULT=PARTIAL or the user identifies a specific cell that is…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Migrate Databricks Unity Catalog / HMS schemas + tables onto AIDP. Two-stage extract→rewrite→replay pipeline. The rewriter applies 18 DDL rules (3-part→2-part flatten, s3://→oci:// via bucket-map, source-format preserved (Delta stays Delta) with delta. property scrub, MV/streaming rejection, CREATE SCHEMA…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Run the full Databricks→AIDP migration against a manifest. Pass-1 walks the %run dep tree and rewrites Databricks APIs in each dep notebook code-only. Pass-2 executes each task cell-by-cell on a live AIDP cluster, runs 4-way verify (exec error / stderr patterns / Spark logs / Opus eval), and re-attempts up to 10 times…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
One-shot environment readiness check for the Oracle AIDP Databricks migrator. Verifies Python deps, OCI auth, AIDP cluster reachability, and your env-coords file. Use the first time the user invokes the migrator on a workstation, or when any other skill fails with an auth / connectivity error.
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Router skill. Read this first whenever the user mentions migrating a Databricks workload (notebooks, jobs, catalogs, schedules) onto Oracle AI Data Platform (AIDP). Lays out the toolkit, the two-pass migration architecture, and which of the other aidp- skills handles each phase. Compose those skills; this one adds no…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Resume an interrupted migration. The migrator caches already-migrated notebooks (in-memory + on-cluster) so subsequent runs skip them. Use when a prior aidp-migrate-job run was killed mid-flight (Ctrl-C, cluster restart, network drop) or when resuming after a manual fix to a specific dep notebook.
oracle-samples/oracle-aidp-samples
Plugin Claude Code
Operate the entire Oracle AI Data Platform (AIDP) Workbench in natural language — a 37-skill agent (not a single-engine orchestrator). Discovers your catalog into a grounding cache (FK/join hints + value dictionaries), turns plain English into accurate Spark SQL, and runs the full lakehouse SQL lifecycle…
oracle-samples/oracle-aidp-samples
Hook
Runs when a session starts on startup, resume and clear, executing check_env.py via python3. From oracle-samples/oracle-aidp-samples.
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Discover, author, deploy, and run AIDP agent flows. Use when the user wants to list/inspect agent flows, or create/update/deploy/run a flow, manage sessions/guardrails, attach compute, or attach a remote MCP server to a flow (an MCPTOOL node — AIDP's "Native MCP Client Support" LA feature, where the flow connects OUT…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Build AIDP agents in high-code Python with aidputils + LangGraph (the code-first alternative to the low-code agent-flow canvas). Use when the user wants to write an agent in Python, use LangGraph / createreactagent / StateGraph, call aidputils (OCIAIConf, AIDPToolConf, initocillm, createlanggraphtool), build a custom…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Run LLM functions inside Spark SQL on AIDP via aigenerate(). Use when the user wants to summarize/classify/extract/enrich rows with an LLM directly in SQL, generate narratives over aggregated results, or do grounded RAG-style analysis in the lakehouse. Signature is model-first; available models must be confirmed live…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Answer business questions over the AIDP lakehouse with Spark SQL. Use when the user asks a data question ("how many…", "top N…", "show me…", "trend of…", "revenue by…") or wants to run ad-hoc Spark SQL. Grounds in .aidp/catalog.md + .aidp/semantic.md and reuses validated verified queries before generating SQL, then…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Manage and search AIDP audit logs — enable/disable auditing, set retention, and query audit-log entries for a DataLake. Use when the user asks about audit logging, who did what, compliance/retention of AIDP activity, or wants to search audit events. Self-contained — official aidp audit CLI preferred, oci raw-request…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Deploy AIDP resources as a bundle — create a bundle, deploy all its assets atomically, query deployment status, and purge. Use when the user wants to promote/deploy a set of AIDP resources together, manage a deployment bundle, check bundle deployment status, or tear one down. Preview API via oci raw-request; verify…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
Browse the AIDP data catalog live — list catalogs, schemas, tables, and volumes, inspect a table's columns/properties, and resolve a human name to its catalog key. Use when the user asks "what catalogs/schemas/tables exist", "describe table X", "what columns does Y have", or needs a catalog/schema/table key for…
oracle-samples/oracle-aidp-samples
Skill Claude CodeCodex
One-time AIDP catalog discovery that writes a cached, version-controllable .aidp/catalog.md grounding file (tables, columns, FK/join hints, value dictionaries). Use when the user says "/aidp-catalog-init", asks to "map/discover my lakehouse", set up data discovery, or before answering data questions when no catalog…