Official agent skill

Oracle Data Guard

by oracle in oracle/skills

Provide operational guidance for Oracle Data Guard and SQLcl DG.

OfficialUPL-1.0Auto-check passedDatabases

Install Oracle Data Guard

skills CLI
$ npx skills add oracle/skills --skill oracle-data-guard -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install oracle/skills oracle-data-guard --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/oracle/skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/db/data-guard .claude/skills/oracle-data-guard && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
oracle-data-guard
GitHub stars
873
Token cost
~646 tokens
SKILL.md length
249 words
Files
13 (incl. references)
Skills in repo
15
Repo updated
First seen
Licence
UPL-1.0

At a glance

Provide operational guidance for Oracle Data Guard and SQLcl DG.

  • Works in 5 steps: Identify the topology and concern:… → Read the selected reference. Read… → State the evidence needed, provide safe… → …
  • A user asks about SQLcl DG commands
  • SKILL.md covers Route the request, Response workflow and Safety
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Oracle Data Guard is an agent skill from oracle/skills, published by the product's own GitHub organization. Provide operational guidance for Oracle Data Guard and SQLcl DG. Use when a user asks about SQLcl DG commands, Data Guard Broker fixed views, FSFO or observer state, transport or apply lag, ASYNC/SYNC/FASTSYNC performance, redo apply tuning, SIRA/MIRA, or runnable Data Guard diagnostic SQL.

Its SKILL.md is about 650 tokens, which your agent loads only when the skill is triggered. The skill folder holds 14 other files, including reference files (for example `agents/openai.yaml`, `references/00_DG_RESOURCE_INDEX.md` and `references/01_SQLCL_DG_COMMANDS.md`).

It sits in Databases, covering SQL. It works with SQL. The repository describes itself as: Oracle Skills is a curated, open-source collection of practical, installable skills for working with Oracle technologies. It provides developers, administrators, and AI agents…

When your agent uses it

  • A user asks about SQLcl DG commands
  • Data Guard Broker fixed views
  • ASYNC/SYNC/FASTSYNC performance
  • Redo apply tuning

Example prompts

  • “/oracle-data-guard”

Workflow steps

5 steps, taken from the first numbered list in SKILL.md.

  1. Identify the topology and concern: Broker versus SQLcl, transport versus apply, and ASYNC versus SYNC/FASTSYNC where relevant.
  2. Read the selected reference. Read 09_SQL_QUERY_COOKBOOK.md only when executable SQL directly helps.
  3. State the evidence needed, provide safe diagnostic steps, and distinguish facts from hypotheses.
  4. Treat example timestamps as placeholders; ask for the actual incident window when it affects a query.
  5. When both transport and apply lag are zero, frame guidance as a health check, baseline, configuration review, or commit-latency…

What it can do on your machine

Read from SKILL.md and the folder at commit 6c57a52. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Oracle Data Guard loads about 646 tokens when it runs, and up to ~12k if it reads all its reference files. Until then it costs about 77 tokens; SKILL.md has 249 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~77
When it runs · the whole SKILL.md, loaded when a task matches
~646
With references · SKILL.md plus every file in references/, read only if the agent opens them
~12k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Its licence (UPL-1.0) doesn't allow us to republish the file, so here is its outline and opening line. It has 249 words (~646 tokens).

“Use the bundled references as the source of truth for SQLcl MCP Data Guard guidance. Read only the smallest relevant reference. Do not claim to have inspected a live database, Broker configuration, or observer unless the user provides output or…”

— opening of SKILL.md by oracle, UPL-1.0
name
oracle-data-guard

Read the full SKILL.md on GitHub

Files

SKILL.md and 12 other files (references) in db/data-guard of oracle/skills.

  • SKILL.md
  • agents/openai.yaml
  • references/00_DG_RESOURCE_INDEX.md
  • references/01_SQLCL_DG_COMMANDS.md
  • references/02_BROKER_FIXED_VIEW_ROUTING.md
  • references/03_OVERVIEW_AND_LAG_MODEL.md
  • references/04_TRANSPORT_TROUBLESHOOTING.md
  • references/05_ASYNC_TRANSPORT_ADVANCED.md
  • references/06_SYNC_TRANSPORT_PERFORMANCE.md
  • references/07_APPLY_TROUBLESHOOTING.md
  • references/08_APPLY_TUNING_SIRA_MIRA.md
  • references/09_SQL_QUERY_COOKBOOK.md
  • references/10_DECISION_TREES_AND_PLAYBOOKS.md

Open the folder on GitHubat commit 6c57a52

Compare with similar skills

Oracle Data Guard next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Oracle Data Guard compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Oracle Data Guard this skilloracle/skills873—~646Automated safety check: PassUPL-1.0
Evolving The Data ModelTriliumNext/Trilium38k—~2.1kAutomated safety check: PassAGPL-3.0
Orchardcore Data MigrationOrchardCMS/OrchardCore8.2k—~1.7kAutomated safety check: PassBSD-3-Clause
SQL Optimization Patternsynulihao/AgentSkillOS61711 repos~3.3kAutomated safety check: PassNone
SQL PortabilityHL7/sql-on-fhir150—~512Automated safety check: PassCustom licence
StmoSAP/project-foxhound1802 repos~1.8kAutomated safety check: PassGPL-3.0

Similar skills

  • Evolving The Data Model

    TriliumNext/Trilium

    A skill your agent uses when adding a DB migration or a new column/field to a Becca entity in Trilium ("add a migration", "new column on notes/attributes", "ALTER TABLE", "add a field to…

    38k GitHub stars~2.1k tokensUpdated today
    DatabasesAuto-check passed
  • Orchardcore Data Migration

    OrchardCMS/OrchardCore

    Creates and updates OrchardCore data migrations (DataMigration classes with CreateAsync/UpdateFromX).

    8.2k GitHub stars~1.7k tokensUpdated today
    DatabasesAuto-check passed
  • SQL Optimization Patterns

    ynulihao/AgentSkillOS

    Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.

    617 GitHub starsUsed in 11 repos~3.3k tokens
    DatabasesAuto-check passed
  • SQL Portability

    HL7/sql-on-fhir

    Analyse whether a SQL query is portable across database implementations using sqlglot transpilation.

    150 GitHub stars~512 tokensUpdated 2 days ago
    DatabasesAuto-check passed
  • Stmo

    SAP/project-foxhound

    Official

    Manage Redash queries and dashboards on Mozilla's STMO (sql.telemetry.mozilla.org) using stmo-cli.

    180 GitHub starsUsed in 2 repos~1.8k tokens
    DatabasesAuto-check passed
  • DB Migrations

    kurealnum/dotfiles

    A skill your agent uses when generating or regenerating Drizzle migration files, changing database schema tables or columns, resolving migration sequence conflicts after rebase, reviewing migration…

    290 GitHub stars~820 tokensUpdated 5 mo ago
    DatabasesAuto-check passed

More from oracle/skills

All 15 skills in this repo
  • Official

    Deploy and troubleshoot multihome networking on OCI Kubernetes Engine using existing GVA secondary VNIC node pools, Multus thick plugin, OCI CNI/IPAM, NetworkAttachmentDefinitions, and test pods.

    873 GitHub stars~1.8k tokensUpdated 2 days ago
    Auto-check passed
  • Official

    Build, configure, scaffold, and deploy OCI Functions from a local machine using a dependency-first, Fn-context-guided flow with argv-safe mutation execution, nonce-scoped confirmations, and a…

    873 GitHub stars~4.6k tokensUpdated 2 days ago
    Auto-check passed
  • Oci Iot Platform

    oracle/skills

    Official

    Explore, create, and troubleshoot Oracle Cloud Infrastructure Internet of Things Platform resources, including domains, digital twin models, adapters, instances, relationships, and device publish…

    873 GitHub stars~1.5k tokensUpdated 2 days ago
    Auto-check passed
  • DB

    oracle/skills

    Official

    Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, Oracle Vector SDK, administration, app development, performance, security, migrations, and agent-safe database workflows.

    873 GitHub stars~1.4k tokensUpdated 2 days ago
    Auto-check passed
  • Enterprise AI

    oracle/skills

    Official

    Oracle Enterprise AI guidance for building, deploying, securing, estimating cost for, and integrating AI models, agents, RAG, Responses API workflows, custom or imported models, fine-tuning, model…

    873 GitHub stars~1.4k tokensUpdated 2 days ago
    Auto-check passed
  • Oke Gva Deployer

    oracle/skills

    Official

    A skill your agent uses when the user asks to enable, deploy, or configure Generic VNIC Attachment (GVA) for OCI Kubernetes Engine (OKE), create node pools with secondary VNIC profiles, review…

    873 GitHub stars~3.6k tokensUpdated 2 days ago
    Auto-check: warnings

Works with

Categories

Questions about Oracle Data Guard

What does Oracle Data Guard do?

Provide operational guidance for Oracle Data Guard and SQLcl DG. Oracle Data Guard is an agent skill from oracle/skills, published by the product's own GitHub organization. Provide operational guidance for Oracle Data Guard and SQLcl DG.

When should I use Oracle Data Guard?

Oracle Data Guard fits situations like: A user asks about SQLcl DG commands; data Guard Broker fixed views; ASYNC/SYNC/FASTSYNC performance; redo apply tuning.

How do I install Oracle Data Guard in Claude Code?

Run `npx skills add oracle/skills --skill oracle-data-guard -a claude-code`. Or copy the skill folder (db/data-guard in oracle/skills) into .claude/skills/oracle-data-guard in your project. Claude Code loads it when a task matches its description.

How do I install Oracle Data Guard in Codex?

Run `npx skills add oracle/skills --skill oracle-data-guard -a codex`. Or copy the skill folder (db/data-guard in oracle/skills) into .agents/skills/oracle-data-guard in your project. Codex loads it when a task matches its description.

Can I use Oracle Data Guard in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add oracle/skills --skill oracle-data-guard -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/oracle-data-guard, .gemini/skills/oracle-data-guard, .github/skills/oracle-data-guard and .opencode/skills/oracle-data-guard in your project.

What does Oracle Data Guard need to run?

SKILL.md names no scripts, command-line tools or credentials: Oracle Data Guard is instructions for the agent only.

Does Oracle Data Guard access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Oracle Data Guard safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Oracle Data Guard use?

Oracle Data Guard is published under the UPL-1.0 licence (the repository's licence).

How many tokens does Oracle Data Guard use?

About 646 tokens (SKILL.md is roughly 2.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 12k tokens, read only when the agent opens those files.

What are the alternatives to Oracle Data Guard?

Skills that share tags, products or a category with Oracle Data Guard: Evolving The Data Model (TriliumNext/Trilium, 38k stars), Orchardcore Data Migration (OrchardCMS/OrchardCore, 8.2k stars), SQL Optimization Patterns (ynulihao/AgentSkillOS, 617 stars) and SQL Portability (HL7/sql-on-fhir, 150 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Oracle Data Guard?

oracle (a GitHub organization, an official publisher) maintains it in oracle/skills, which has 873 GitHub stars. The repository holds 15 skills in this directory. The repository was last updated on October 6, 2026.

Source: oracle/skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.