Oracle Database Expert

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.

48 stars 6 forksDatabases Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add frankxai/claude-skills-library

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add frankxai/claude-skills-library --skill oracle-database-expert
Manual install
git clone --depth 1 https://github.com/frankxai/claude-skills-library.git /tmp/claude-skills-library
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills-library/free-skills/oracle-database-expert ~/.claude/skills/oracle-database-expert

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# 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,
  keeping a single source of truth while serving document APIs.
- Apply constraints (PK, FK, `CHECK`, `NOT NULL`, unique) — they enable optimizer transformations.

### 2. SQL & PL/SQL Performance
- Read execution plans with `DBMS_XPLAN.DISPLAY_CURSOR(format => 'ALLSTATS LAST')`.
Read the full skill on GitHub

Details

Skill name
oracle-database-expert
Path
free-skills/oracle-database-expert/SKILL.md
License
MIT
Repo updated
18 November 2026

FAQ

What does the Oracle Database Expert skill do?

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.

How do I install the Oracle Database Expert skill?

Claude Code plugin: /plugin marketplace add frankxai/claude-skills-library. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Oracle Database Expert popular?

It lives in frankxai/claude-skills-library, which has 48 GitHub stars and 6 forks.

Related skills

Acos Meta

48

frankxai/claude-skills-library

ACOS self-description and configuration skill. Documents how ACOS works, how to extend it, how to add new skills/commands/agents, and how to debug the hook system. Use when building new ACOS capabilities, understanding the system architecture, or onboarding to ACOS for the first time.

Software Development

Acos Visual Gen

48

frankxai/claude-skills-library

Generate research-grounded visuals using the InfoGenius pipeline. Use when creating infographics, diagrams, educational visuals, or any image that benefits from factual accuracy. Supports 8 visual styles (3D, technical, minimalist, photorealistic, futuristic, vintage, cartoon, standard) and 4 audience levels.

Images, Video & Audio

Agent Harness Construction

48

frankxai/claude-skills-library

Shape an agent's tools, observations, and recovery without adding a second coordinator. Use when defining a tool, a skill, a hook, or a worktree lane.

AI, LLMs & Agents

SQL Query Builder

43

0xranx/agentbrief

When the user needs help writing SQL queries, analyzing data, building reports, or says 'write a query,' 'SQL help,' 'pull this data,' 'how many users,' 'funnel analysis,' 'cohort analysis,' 'retention query,' or needs to extract insights from a database.

Databases

Prisma Orm V7 Skills

23

gocallum/nextjs16-agent-skills

Key facts and breaking changes for upgrading to Prisma ORM 7. Consider version 7 changes before generation or troubleshooting

Databases

Audit Domain 03 Database

41

wolverin0/claude-skills

Audit the database and data layer — schema design, query patterns, migrations, indexing, RLS, soft-delete, transactions. Run as part of /audit Phase E.

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.