DOCSEARCHbyAlgolia
Submit Docs

Oracle Skills

repository·main·Indexed 20 days ago

https://github.com/oracle/skills

A centralized collection of practical, source-backed guidance for developers and AI agents working with Oracle technologies, including Oracle Database, OCI, GraalVM, and APEX. It features the APEXlang Skill for Oracle APEX generation, providing workflows for creating artifacts, validating code via SQLcl (version 26.1.2+), and managing page components, business logic, shared components, and localization.

Tokens
432.2K
Snippets
944
Records
1.5K
Agent score
73%

What's inside Oracle Skills

  1. Overview of SQLcl Built-in Liquibase

    main

    SQLcl includes Liquibase natively, meaning no separate installation, Java classpath configuration, or Oracle JDBC driver setup is required. The lb command (or its alias liquibase) is available directly at the SQLcl prompt and from the command line.

    Unlike the standalone Liquibase CLI, SQLcl's integration is purpose-built for Oracle and includes extensions to generate changelogs from an existing Oracle schema, allowing you to capture tables, views, packages, triggers, sequences, and more directly from the database catalog.

  2. Overview of ADRCI (Automatic Diagnostic Repository Command Interpreter)

    main
    adrci is Oracle's command-line interface for managing the Automatic Diagnostic Repository (ADR). It is used to search diagnostic data (alert logs, trace files, incidents), manage incidents, package diagnostic information for Oracle Support (IPS packages), and purge stale content. It provides structured, filterable access to diagnostic data that is more efficient than standard file system tools like grep or tail.

  3. Overview of OCI Functions Deploy skill

    main

    The oci-functions-deploy skill automates the building, configuring, scaffolding, and deploying of OCI Functions on local macOS/Linux workstations.

    Supported Runtimes:

    • Java
    • Python
    • Node

    Key Capabilities:

    • Validates dependencies (fn, oci, docker).
    • Configures and validates Fn contexts and OCI sessions.
    • Validates Docker registry authentication.
    • Manages OCI Functions applications (reuse or create).
    • Scaffolds function code using fn init.
    • Deploys functions using fn deploy.

    Important Limitations:

    • Windows automation is out of scope; Windows users must handle automation manually.
    • OCI Cloud Shell is out of scope; do not use this local automation flow within Cloud Shell.
    • Network creation is only supported via an explicit advanced branch.

  4. Overview of SQL Property Graphs in Oracle Database

    main

    Oracle SQL Property Graph allows you to model and query graph data (vertices and edges) directly on top of existing relational objects like tables, views, materialized views, or external tables without copying data. The graph definition acts as metadata, and queries run against the live relational data.

    Core Components:

    • CREATE PROPERTY GRAPH: Defines the mapping of tables to vertices and edges, including keys, labels, and properties.
    • GRAPH_TABLE operator: A table operator used within SQL SELECT statements to perform pattern matching using MATCH syntax.

    Requirements:

    • Requires Oracle Database 23ai (23c) or later. It is not available in Oracle 19c.

  5. Use OKE Generic VNIC Attachment (GVA) Node Pools

    main

    Use this skill to plan, create, or review OCI Kubernetes Engine (OKE) managed node pools that utilize Generic VNIC Attachment (GVA) secondary VNIC profiles for pod networking. GVA allows a node pool to expose multiple secondary VNIC profiles, each with its own subnet, NSGs, display name, and pod IP allocation.

    Note: If a pod requires multiple interfaces at the same time, use oci/oke/multus-multihome.md instead of GVA.

    Prerequisites:

    • The cluster must use VCN-native pod networking.
    • The target must be a managed node pool.
    • The selected shape must support the required number of VNICs and pod IP capacity.
    • Secondary VNIC subnets and NSGs must already exist.
    • Subnet CIDR capacity must be sufficient for the requested ipCount.
    • Multiple secondary VNIC pod networking is not supported with Flannel overlay networking.

  6. Navigate the Oracle Database Skills domain

    main

    The db domain provides guidance for Oracle Database administration, SQL/PL/SQL development, performance tuning, security, ORDS, SQLcl, migrations, and agent-safe workflows. To use this domain effectively:

    1. Use the Category Routing table to find the directory corresponding to your specific topic.
    2. Navigate directly to the relevant file within that directory.

    Directory Structure Overview:

    • db/admin/: Data Guard, redo/undo logs, users
    • db/agent/: Safe DML, destructive operation guards, idempotency, schema discovery, ORA- error handling
    • db/appdev/: JDBC, Python, .NET, pooling, JSON, XML, spatial, Oracle Text, transactions, MLE, language drivers
    • db/architecture/: RAC, Multitenant, Exadata, In-Memory, OCI database services, Data Guard architecture
    • db/backup-recovery/: Backup, recovery, RMAN, Autonomous Recovery Service, Cloud Protect
    • db/containers/: OCR database-category container images and pull guidance
    • db/design/: ERD, data modeling, partitioning, tablespaces
    • db/devops/: Schema migrations, online operations, edition-based redefinition, testing, version control
    • db/features/: AQ, DBMS_SCHEDULER, materialized views, DBLinks, APEX, vector search, SELECT AI
    • db/frameworks/: SQLAlchemy, Django, Pandas, Spring JPA, MyBatis, TypeORM, Sequelize, Dapper, GORM
    • db/migrations/: Migrations from PostgreSQL, MySQL, SQL Server, MongoDB, Snowflake, etc.
    • db/monitoring/: Alert log, ADR, health monitor, space management, top SQL
    • db/ords/: ORDS architecture, installation, REST design, authentication, monitoring
    • db/performance/: AWR, ASH, explain plan, indexes, optimizer stats, wait events, memory
    • db/plsql/: Package design, error handling, performance, collections, cursors, debugging
    • db/security/: Privileges, VPD, masking, auditing, encryption, network security
    • db/sql-dev/: SQL tuning, SQL patterns, dynamic SQL, injection avoidance
    • db/sqlcl/: SQLcl basics, scripting, Liquibase, formatting, DDL generation, data loading, MCP server, scheduler daemon, AWR, background jobs, schema comparison with DIFF

  7. Use the OKE Multihome Deployer skill

    main

    The oke-multihome-deployer skill is used to deploy and verify Multus-based pod multihoming on an OCI Kubernetes Engine (OKE) cluster that already has GVA secondary VNIC node pools attached.

    Important Constraints:

    • Prerequisite: You must have already created or updated GVA node pools using oke-gva-deployer. This skill does not manage node pools.
    • When NOT to use: For broad incident RCA, DPDK/SR-IOV failures, or non-Multus pod symptoms, use oke-troubleshooter instead.
    • Core Requirements: OKE CNI must be set to OCI_VCN_IP_NATIVE, and worker nodes must expose secondary VNIC interfaces (e.g., enp1s0, enp2s0).

  8. Generate Oracle APEX regions using the regions skill

    main

    The regions skill is used to generate or update Oracle APEX region-level artifacts (such as Interactive Reports, Dashboards, Charts, Calendars, and Maps) by orchestrating Tier 1 workflows. It coordinates the apexdev internal generate -> review -> fix loop to ensure region composition, logic, and acceptance gates align with the master contract.

    To use this skill effectively, ensure you provide the necessary context for the specific region type requested. The skill uses the component registry in assets/apex-generation/components.registry.json to select the appropriate workflow.

    // Example illustrative prompts:
"Create an interactive report on {{source.table}} with modal form for edits and dynamic action to refresh after submit."
"Add dashboard cards for Sales KPIs using existing page 10."
"Apply dynamic action batch to refresh regions on pages 12, 14, 20 when timer fires."

  9. Use the OKE Generic VNIC Attachment (GVA) Deployer skill

    main

    Use the oke-gva-deployer skill to enable, deploy, or configure Generic VNIC Attachment (GVA) for Oracle Cloud Infrastructure Kubernetes Engine (OKE). This includes creating node pools with secondary VNIC profiles, reviewing update plans for existing GVA node pools, mapping Application Resources to workloads, or explaining GVA functionality and constraints.

    Note: Do not use this skill for general OKE incident Root Cause Analysis (RCA) or for deploying Multus test pods after a GVA node pool already exists. For those tasks, use oke-troubleshooter or oke-multihome-deployer respectively.

  10. Browse the Container Skills Index

    main
    The db/containers/ directory contains a complete index of container-related skills and images for Oracle products. Use the index to locate specific guidance for common database images, client tools, or advanced deployment scenarios like RAC or Microservices.

  11. Navigate the APEXlang Domain Index

    main

    The APEXlang Domain References package serves as the canonical entrypoint for domain-specific guidance. Use the Domain Index to locate the correct support folder for your specific task:

    • Page Components: references/domains/page-components/
    • Business Logic: references/domains/business-logic/
    • Shared Components: references/domains/shared-components/
    • Template Components: references/domains/template-components/
    • Universal Attribute Configuration: references/domains/universal-attr-config/
    • Debugging: references/domains/debugging/

  12. Diagnose OCI Functions issues using the troubleshoot skill

    main

    The oci-functions-troubleshoot skill is designed to isolate the cause of OCI Functions problems (setup, deployment, invocation, or observability) using a deterministic, diagnosis-first workflow.

    Key Principles:

    • Non-mutating by default: The skill prefers read-only checks. It will not edit Fn context, Docker auth, app configurations, or infrastructure unless explicitly requested.
    • Diagnosis before remediation: If a fix is requested, the skill completes the diagnosis first and then hands off mutating remediation to $oci-functions-deploy.
    • Evidence-based: It uses error text, command output, and observability signals (logs, traces, metrics) to classify issues into specific stages.

    Troubleshooting Stages:

    • setup_or_control_plane: Local Fn/OCI/OCIR/tooling/auth/context/policy problems.
    • create: Application creation failures.
    • deploy: fn deploy, image build/push, func.yaml, app config, or registry issues.
    • invoke: Runtime invocation, HTTP, image pull, timeout, memory, or networking failures.
    • observability_first: Issues identified via logs, traces, metrics, or service limits.