Back to Discover

skills

skill

oracle

Oracle Skills is a curated, open-source collection of practical, installable skills for working with Oracle technologies. It provides developers, administrators, and AI agents with high-quality, source-backed guidance across the entire Oracle ecosystem.

View on GitHub
775 starsUPL-1.0Synced Aug 2, 2026

Install to Claude Code

/plugin marketplace add oracle/skills

README

Oracle Skills

Oracle Skills is a collection of practical, installable skills for working with Oracle technologies.

The goal is to give developers and agents a single place to find source-backed Oracle guidance across Oracle Database, Oracle Cloud Infrastructure, GraalVM, Oracle Fusion, Oracle APEX, and future domains.

Installation

Install a domain by appending the root-level domain directory to the repository name:

npx skills add oracle/skills/db
npx skills add oracle/skills/oci
npx skills add oracle/skills/graal
...

Install in Claude Code

This repository also ships as a Claude Code plugin marketplace (.claude-plugin/marketplace.json), where each domain folder (apex, db, fusion, graal, oci) is published as its own plugin.

Register the marketplace, then install the domain plugins you need:

# Register this repo as a marketplace
/plugin marketplace add oracle/skills

# Install one or more domain plugins
/plugin install db@oracle-skills
/plugin install graal@oracle-skills

Already cloned the repo locally? Point the marketplace at the local path instead:

/plugin marketplace add ./

Browse and toggle installed plugins anytime with /plugin. Enabled plugins are tracked in .claude/settings.json under enabledPlugins.

Repository Goals

  • Provide Oracle-wide skills in one repository.
  • Define domain entry points that help developers and agents route to the right topic quickly.
  • Keep each skill practical, source-backed, and easy to consume on demand.
  • Allow each domain to evolve its own taxonomy without breaking repo-wide consistency.

Domains

  • db/ is the active Oracle Database domain and includes database, ORDS, SQLcl, framework, container, and agent workflow skills.
  • oci/ contains Oracle Cloud Infrastructure skills, including OCI Functions deployment and troubleshooting, OCI Kubernetes Engine cluster design and troubleshooting, OCI IoT Platform digital twin workflows, plus Enterprise AI guidance for OCI Generative AI, agents, RAG, governance, model endpoints, Autonomous Database, APEX, and integrations.
  • fusion/ is the root for future Oracle Fusion skills.
  • apex/ is the root for future Oracle APEX skills.
  • graal/ contains GraalVM skills, starting with Native Image.

Start Here

  1. Pick the domain closest to your task.
  2. Install that domain skill.
  3. Add other domain skills only when needed.

Repository Layout

.
├── db/
│   ├── SKILL.md
│   ├── admin/
│   ├── agent/
│   ├── appdev/
│   ├── architecture/
│   ├── containers/
│   ├── design/
│   ├── devops/
│   ├── features/
│   ├── frameworks/
│   ├── migrations/
│   ├── monitoring/
│   ├── ords/
│   ├── performance/
│   ├── plsql/
│   ├── security/
│   ├── sql-dev/
│   └── sqlcl/
├── fusion/
│   └── SKILL.md
├── apex/
│   └── SKILL.md
├── graal/
│   ├── SKILL.md
│   └── native-image/
│       ├── build-native-image.md
│       ├── native-build-tools.md
│       ├── reachability-metadata.md
│       └── troubleshooting.md
└── oci/
    ├── SKILL.md
    ├── enterprise-ai/
    │   ├── SKILL.md
    │   ├── models/
    │   ├── agent-workflows/
    │   ├── governance/
    │   ├── data/
    │   ├── cost/
    │   └── integrations/
    ├── functions/
    │   ├── oci-functions-deploy/
    │   └── oci-functions-troubleshoot/
    ├── iot-platform/
    │   ├── SKILL.md
    │   ├── agents/
    │   ├── references/
    │   ├── scripts/
    │   ├── templates/
    │   └── tests/
    └── oke/
        ├── cluster-design.md
        ├── troubleshooting.md
        ├── gva-node-pools.md
        ├── multus-multihome.md
        ├── skills/
        ├── scripts/
        ├── agents/
        ├── shared/
        ├── examples/
        └── tests/

Each domain has its own SKILL.md and any supporting index files it needs.

For a real domain, organize content by category directories and use SKILL.md as the table of contents. A domain SKILL.md should normally include:

  • ## How to Use This Domain
  • ## Directory Structure
  • ## Category Routing
  • ## Key Starting Points
  • ## Common Multi-Step Flows

For stub domains, keep SKILL.md minimal and point users back to this README.md and SKILL_AUTHORING_GUIDE.md.

Version Coverage Standard

  • Skills that include version-specific behavior must include a section named ## Oracle Version Notes (19c vs 26ai).
  • Use Oracle Database 19c as the baseline compatibility target unless stated otherwise.
  • Explicitly call out features that require newer releases and provide 19c-compatible alternatives where practical.

Sources

Rendered live from oracle/skills's GitHub README — not stored, always reflects the source repo.

5 Plugins

NameDescriptionCategorySource
apexOracle APEX skills for Oracle APEX application development, including the APEXlang router with deterministic local-context discovery and compact machine-readable contracts.oracle./apex
dbOracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows. Use when the user asks to write, edit, rewrite, review, format, debug, tune, or explain SQL; create or refactor PL/SQL; use SQLcl, Liquibase, ORDS, JDBC, node-oracledb, Python, Java, .NET, or database frameworks; troubleshoot queries, sessions, locks, waits, indexes, optimizer plans, AWR, ASH, migrations, schemas, users, roles, privileges, backup, recovery, Data Guard, RAC, multitenant, containers, monitoring, auditing, encryption, VPD, or safe agent database operations.oracle./db
fusionOracle Fusion domain. Placeholder for future Oracle Fusion skills.oracle./fusion
graalBuild, configure, and troubleshoot GraalVM Native Image applications. Use this skill for native-image CLI builds, Maven or Gradle Native Build Tools, reachability metadata, and build or run time issue diagnosis.oracle./graal
ociOracle Cloud Infrastructure guidance for OKE, OCI IoT Platform digital twins and publish flows, Enterprise AI models, agents, RAG, governance, and Oracle platform integrations.oracle./oci

0 Comments

Login required
Log in to post a comment or update on this repo.

No comments yet — be the first to share an update.