oracle-database-expert SKILL.md skillA

oracle-database-expert from frankxai/claude-skills-library is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add frankxai/claude-skills-library/oracle-database-expert@v1.0.0

Pins v1.0.0 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
frankxai/claude-skills-library
Path
free-skills/oracle-database-expert/SKILL.md
Versions recorded
2
Latest version
v1.0.0, committed Jun 5, 2026
First version recorded
Oct 31, 2025
Size
4,120 bytes
Repository stars
47
License
MIT

Expert Oracle Database engineering across Oracle Database 23ai, Autonomous Database, SQL/PLSQL tuning, AI Vector Search, JSON Relational Duality, partitioning, high availability, and security. Use when designing schemas, optimizing queries, or operating Oracle databases in production.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Oracle Database Expert

You are a senior Oracle Database engineer with deep, production-grade expertise spanning
Oracle Database 23ai, Autonomous Database (ADB), Exadata, and the modern converged-database
feature set. You give precise, version-aware guidance and always favor correctness, security,
and measurable performance.

## When to Use This Skill

Activate when the user needs to:
- Design or refactor a relational/JSON schema for Oracle Database
- Diagnose and fix slow SQL or PL/SQL (execution plans, indexing, statistics)
- Adopt 23ai features (AI Vector Search, JSON Relational Duality, SQL property graphs)
- Configure high availability, backup/recovery, or disaster recovery
- Harden a database (least privilege, TDE, auditing, data redaction)
- Migrate to or operate Autonomous Database

## Core Competencies

### 1. Schema & Data Modeling
- Normalize to 3NF for OLTP; use star/snowflake for analytics.
- Choose data types deliberately: `NUMBER` precision/scale, `TIMESTAMP WITH TIME ZONE`,
  `VARCHAR2` with explicit `CHAR`/`BYTE` semantics, `JSON` (native 23ai type), `VECTOR`.
- Use **JSON Relational Duality Views** (23ai) to expose relational tables as documents,
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add frankxai/claude-skills-library/oracle-database-expert@sha256:395334e6fd6a156e

The line at the top of this page pins the label v1.0.0, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_4t2xwwzf5ete7ryd.svg)](https://markdownregistry.com/a/art_4t2xwwzf5ete7ryd)

1 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 2 versions of this file, between Oct 31, 2025 and Jun 5, 2026, about one every 217 days. Its first recorded version is graded C and its latest A.

versioncommittedcommitsizeaudit
v1.0.0 latest2026-06-05 7e49dea 4,120 BA view · diff
git:20251031.a2fdac92025-10-31 a2fdac9 0 BC view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (4120 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

frankxai/claude-skills-library · 47 stars · license MIT · pushed 2026-10-20 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_4t2xwwzf5ete7ryd
GET https://markdownregistry.com/api/v1/resolve?ref=frankxai/claude-skills-library/oracle-database-expert
GET https://markdownregistry.com/api/v1/blob/395334e6fd6a156eb78b6d1081324a36287668f03da108201c59fcd5eca28350

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from frankxai/claude-skills-library

excellence-review SKILL.md skill
frankxai/claude-skills-library · .grok/skills/excellence-review/SKILL.md · Mandatory excellence gates for Grok+ACOS. verification-loop, santa-method, gstack-qa, plan-reviews, repo-mastery, cso…
git:20260820.5d4ee7a · audit A · 47 stars
harness-integration SKILL.md skill
frankxai/claude-skills-library · .grok/skills/harness-integration/SKILL.md · ACOS Grok bridge. SessionStart loads repo-mastery + excellence gates. PreToolUse enforces rules read + suggests harness…
git:20261014.6571e8d · audit A · 47 stars
multi-harness-orchestrator SKILL.md skill
frankxai/claude-skills-library · .grok/skills/multi-harness-orchestrator/SKILL.md · Automatically detect tasks suited for delegation to other agent harnesses (Claude Code as canonical, agy/antigravity…
git:20260820.5d4ee7a · audit A · 47 stars
repo-mastery SKILL.md skill
frankxai/claude-skills-library · .grok/skills/repo-mastery/SKILL.md · Master ACOS, FrankX, Starlight-Intelligence-System, arcanea, claude-code-config and full starlight/repos ecosystem…
git:20261014.6571e8d · audit A · 47 stars
AGENTS.md AGENTS.md file
frankxai/claude-skills-library · AGENTS.md
git:20261014.6571e8d · audit F · 47 stars
agent-harness-construction SKILL.md skill
frankxai/claude-skills-library · absorbed/harness/agent-harness-construction/SKILL.md · Shape an agent's tools, observations, and recovery without adding a second coordinator. Use when defining a tool, a…
git:20261010.682b2ce · audit A · 47 stars
context-budget SKILL.md skill
frankxai/claude-skills-library · absorbed/harness/context-budget/SKILL.md · Count what a session loads before adding another skill or MCP server. Use when the default prompt is heavy, a new…
git:20261010.682b2ce · audit A · 47 stars
cost-aware-llm-pipeline SKILL.md skill
frankxai/claude-skills-library · absorbed/harness/cost-aware-llm-pipeline/SKILL.md · Pick the smallest model that can finish the task, and record the class of work. Use when routing a search, a multi-file…
git:20261010.682b2ce · audit A · 47 stars
santa-method SKILL.md skill
frankxai/claude-skills-library · absorbed/harness/santa-method/SKILL.md · Send a finished change to two reviewers who did not write it, using one rubric, and stop after three rounds. Use before…
git:20261011.854bb48 · audit A · 47 stars
search-first SKILL.md skill
frankxai/claude-skills-library · absorbed/harness/search-first/SKILL.md · Look for an existing repo, package, and skill before writing a new one. Use when starting a feature, adding a…
git:20261010.682b2ce · audit A · 47 stars
security-review SKILL.md skill
frankxai/claude-skills-library · absorbed/harness/security-review/SKILL.md · Scan a port or a diff before it lands, and apply the narrow deny list for this machine. Use before copying upstream…
git:20261010.682b2ce · audit A · 47 stars
strategic-compact SKILL.md skill
frankxai/claude-skills-library · absorbed/harness/strategic-compact/SKILL.md · Write what worked, what failed, and what is still open to a file, then compact at a phase boundary. Use when a long…
git:20261010.682b2ce · audit A · 47 stars

Every file in frankxai/claude-skills-library

Other files named oracle-database-expert

oracle-database-expert SKILL.md skill
frankxai/agentic-creator-os · .claude/skills/oracle-database-expert/SKILL.md
git:20260124.0bc6f23 · audit C · 12 stars

Browse by kind, by grade A, or by owner.