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.
Install
/plugin marketplace add frankxai/claude-skills-libraryThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add frankxai/claude-skills-library --skill oracle-database-expertgit 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-expertPersonal 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')`.
Details
- Skill name
oracle-database-expert- Repository
- frankxai/claude-skills-library
- 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
48frankxai/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.
Acos Visual Gen
48frankxai/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.
Agent Harness Construction
48frankxai/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.
SQL Query Builder
430xranx/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.
Prisma Orm V7 Skills
23gocallum/nextjs16-agent-skills
Key facts and breaking changes for upgrading to Prisma ORM 7. Consider version 7 changes before generation or troubleshooting
Audit Domain 03 Database
41wolverin0/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.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.