oracle-samples/oracle-aidp-samples

ask-aidp

Use when the user asks Codex to connect to Oracle AI Data Platform Workbench, run aidp-cli commands, manage AIDP agents/notebooks/workflows/clusters/catalogs/schemas/volumes/MLOps/bundles/audit/roles/credentials, execute a notebook workflow, export task…

Quellsprache: Englisch

aidp-fusion-incremental

Turn a natural-language refresh request into a guarded `aidp-fusion-autopilot run --mode incremental` (the daily delta-merge). Parses intent into scope flags (reusing the seed parser with --mode incremental), auto-satisfies preconditions, and runs the…

Quellsprache: Englisch

aidp-fusion-pipeline

Productized Fusion → Oracle AI Data Platform pipeline with curated BICC extracts (GL/AR/AP/PO/Suppliers/Items), bronze/silver/gold medallion in Delta, conformed dimensions (account/calendar/org/supplier/item), gold marts…

Quellsprache: Englisch

aidp-rest

AIDP control-plane REST client primitives: OCI signing, workspace/cluster discovery, notebook upload via contents API, Job + JobRun lifecycle, taskRun output fetch + marker parsing. Use when a skill or tool needs to talk to a live AIDP cluster — uploading…

Quellsprache: Englisch

aidp-migrate-job

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…

Quellsprache: Englisch

aidp-agent-flows

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 MCP_TOOL node — AIDP's "Native…

Quellsprache: Englisch

aidp-agent-highcode

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 / create_react_agent / StateGraph, call aidputils (OCIAIConf,…

Quellsprache: Englisch

aidp-catalog-init

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…

Quellsprache: Englisch

aidp-credentials

Manage the AIDP credential store (secrets) — list, get, create, update, delete credentials used by AIDP workflows. Use when the user wants to store/rotate a secret centrally instead of embedding it, or manage connection credentials. Primary engine is the…

Quellsprache: Englisch

aidp-engineer-bootstrap

First-run setup for the self-contained AIDP plugin. Verifies the oci CLI + a DEFAULT api_key profile, installs the bundled Python deps, discovers region + DataLake OCID + workspace, then smoke-tests both engines (a control-plane GET /catalogs via oci…

Quellsprache: Englisch

aidp-engineer-overview

Router + setup/auth troubleshooting for Oracle AI Data Platform (AIDP) data-engineering work. Use when the user mentions AIDP and isn't sure which skill applies, asks "what can you do with AIDP", describes a task by capability, or hits an AIDP…

Quellsprache: Englisch

aidp-pipelines

Author, schedule, run, and monitor AIDP Jobs (task DAGs of notebooks/python with cron). Use when the user wants to build a pipeline, create/update/run a Job, schedule a recurring run, check a run's status, read a task's output, or cancel a run.

Quellsprache: Englisch

aidp-spark-debugging

Diagnose slow or failed AIDP Spark work using cluster logs, metrics, and the Spark UI REST API. Use when a job/query is slow or failed, the user asks "why did this fail / why is it slow", or you need stage/task timings, skew, shuffle/spill, executor, or…

Quellsprache: Englisch

aidp-sql-ddl

Write-side Spark SQL on the AIDP lakehouse — DDL (CREATE/ALTER/DROP table·view·schema), DML (INSERT/UPDATE/DELETE/MERGE upsert), and Delta maintenance (OPTIMIZE, VACUUM, time travel, RESTORE, schema evolution, liquid clustering). Use when the user wants to…

Quellsprache: Englisch

aidp-tools

Create and manage standalone reusable AIDP agent Tools — SQL, Prompt, RAG, HTTP, Custom, and MCP tools that can be shared across agent flows by key. Use when the user wants to define a reusable tool (not inline in one flow), list/create/update/delete a tool,…

Quellsprache: Englisch

aidp-user-settings

Manage AIDP user settings / preferences — list, get, create, update, delete a user's settings for the DataLake. Use when the user wants to view or change their AIDP workbench preferences/settings, or manage stored user-setting entries. Self-contained —…

Quellsprache: Englisch

infa-discover

Extract mappings and workflows from a live Informatica PowerCenter repository via `infa2aidp cli discover` (SOAP or pmrep). Use when the user wants to pull assets directly from a running PowerCenter installation rather than starting from an export file they…

Quellsprache: Englisch

infa-rag

Manage the learned conversion-pattern store via `infa2aidp cli rag` (stats/list/export/import/clear). Use when the user asks what the tool has learned, wants to back up or move approved patterns between environments, or wants to reset the store. This is local…

Quellsprache: Englisch

snowflake-stage-board

Show the Snowflake-to-AIDP migration as a stage table before running it - which stages are supposed to run, which have run, and what each one found, with the writing stages marked. Use when the user asks what the plugin will do, what stage comes next, where a…

Quellsprache: Englisch

aidp-aws-s3

Read and write AWS S3 (`s3a://`) from an AIDP notebook. Use when the user mentions S3, AWS S3 bucket, s3a, or has AWS access keys. Auth is access key + secret key via the Hadoop S3A connector. boto3 is also available for non-Spark management operations (list,…

Quellsprache: Englisch

aidp-connectors-overview

Help the user pick the right connector skill for their data source from an AIDP notebook. Use as a router when the user mentions multiple sources, isn't sure which connector applies, or asks "how do I connect to X from AIDP". Covers 26 data sources — Oracle…

Quellsprache: Englisch

aidp-epm-cloud

Run a Planning data-slice export against Oracle EPM Cloud (Planning / EPBCS) and materialize as a Spark DataFrame in an AIDP notebook. Use when the user mentions EPM Cloud, EPBCS, Hyperion Planning, planning app, MDX export, or wants Planning data in Spark.…

Quellsprache: Englisch

aidp-essbase

Run an MDX query against an Oracle Essbase 21c cube and materialize the result as a Spark DataFrame in an AIDP notebook. Use when the user mentions Essbase, MDX, Essbase 21c, OLAP cube, or wants to read cube data into Spark. Auth is HTTP Basic.

Quellsprache: Englisch

aidp-fusion-bicc

Pull a Fusion BICC bulk extract into a Spark DataFrame from an AIDP notebook. Use when the user mentions BICC, Fusion bulk extract, BI Cloud Connector, PVO, or needs >50k rows from Fusion. The recommended path uses AIDP's built-in…

Quellsprache: Englisch

aidp-postgresql

Read or write PostgreSQL from an AIDP notebook via the AIDP `aidataplatform` Spark format handler. Use when the user mentions PostgreSQL, Postgres, "psql", or has a Postgres host/port to connect to. Prefer the official `POSTGRESQL` connector sample; use…

Quellsprache: Englisch

aidp-fusion-incremental

Run guarded incremental Fusion refreshes with drift, watermark, plan-hash, and precondition checks. Use for daily deltas, scoped refreshes, resume requests, or incremental-run failures.

Quellsprache: Englisch

aidp-rest

Use AIDP control-plane REST primitives for OCI signing, discovery, notebook upload, job dispatch, polling, output retrieval, and marker parsing. Use when another workflow must operate a live AIDP cluster through REST.

Quellsprache: Englisch

aidp-migrate-job

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…

Quellsprache: Englisch

aidp-catalog-init

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…

Quellsprache: Englisch

aidp-credentials

Manage the AIDP credential store (secrets) — list, get, create, update, delete credentials used by AIDP workflows. Use when the user wants to store/rotate a secret centrally instead of embedding it, or manage connection credentials. Primary engine is the…

Quellsprache: Englisch

aidp-engineer-overview

Router + setup/auth troubleshooting for Oracle AI Data Platform (AIDP) data-engineering work. Use when the user mentions AIDP and isn't sure which skill applies, asks "what can you do with AIDP", describes a task by capability, or hits an AIDP…

Quellsprache: Englisch

aidp-pipelines

Author, schedule, run, and monitor AIDP Jobs (task DAGs of notebooks/python with cron). Use when the user wants to build a pipeline, create/update/run a Job, schedule a recurring run, check a run's status, read a task's output, or cancel a run.

Quellsprache: Englisch

aidp-spark-debugging

Diagnose slow or failed AIDP Spark work using cluster logs, metrics, and the Spark UI REST API. Use when a job/query is slow or failed, the user asks "why did this fail / why is it slow", or you need stage/task timings, skew, shuffle/spill, executor, or…

Quellsprache: Englisch

aidp-sql-ddl

Write-side Spark SQL on the AIDP lakehouse — DDL (CREATE/ALTER/DROP table·view·schema), DML (INSERT/UPDATE/DELETE/MERGE upsert), and Delta maintenance (OPTIMIZE, VACUUM, time travel, RESTORE, schema evolution, liquid clustering). Use when the user wants to…

Quellsprache: Englisch

aidp-user-settings

Manage AIDP user settings / preferences — list, get, create, update, delete a user's settings for the DataLake. Use when the user wants to view or change their AIDP workbench preferences/settings, or manage stored user-setting entries. Self-contained —…

Quellsprache: Englisch

infa-discover

Extract mappings and workflows from a live Informatica PowerCenter repository via `infa2aidp cli discover` (SOAP or pmrep). Use when the user wants to pull assets directly from a running PowerCenter installation rather than starting from an export file they…

Quellsprache: Englisch

aws-aidp-migrator

Migrate an AWS data stack (S3, Glue, Athena, EMR, SageMaker) to Oracle AI Data Platform (AIDP). Use when the user wants to inventory an AWS data estate, plan a migration to AIDP, translate Athena SQL or Glue ETL/PySpark to Spark on AIDP, or verify a…

Quellsprache: Englisch

fabric-aidp-migrator

Migrate a Microsoft Fabric workspace (notebooks, Warehouse T-SQL, Dataflow Gen2 / Power Query M, Data Pipelines, Lakehouse shortcuts, OneLake paths) to Oracle AI Data Platform. Use when the user wants to inventory a Fabric estate, plan a migration to AIDP,…

Quellsprache: Englisch

infa-migrator-overview

Router skill. Read this first whenever the user mentions migrating Informatica ETL (IDMC/IICS cloud mappings, PowerCenter 10.5 XML) onto Oracle AI Data Platform (AIDP). Lays out the toolkit, the CLI command sequence, which infa-* skill handles each phase, and…

Quellsprache: Englisch

aidp-db2

Read or write IBM Db2 from an AIDP notebook through the AIDP `aidataplatform` Spark format handler. Use when the user mentions DB2, IBM Db2, LUW, or `type=DB2`. Auth is host/port + database name + user/password.

Quellsprache: Englisch