Oracle DB Skills

A collection of 103 standalone reference guides for Oracle Database. Each file covers one topic with explanations, practical examples, best practices, and common mistakes.

How to Use

• Find the right skill using the category routing table below.

• Read only the file(s) relevant to the user's task — do not load all files at once.

• Apply the guidance to answer questions, generate code, or review existing work.

Category Routing

User asks about… Read from

Backup, recovery, RMAN, Data Guard, redo/undo logs, users skills/admin/

JDBC, connection pooling, JSON, XML, spatial, full-text, transactions skills/appdev/

RAC, CDB/PDB, Exadata, In-Memory, OCI, ATP/ADW skills/architecture/

ERD, data modeling, partitioning, tablespaces skills/design/

Liquibase, Flyway, online operations, EBR, utPLSQL, git for SQL skills/devops/

Advanced Queuing, DBMS_SCHEDULER, materialized views, DBLinks, APEX skills/features/

Migrating from PostgreSQL, MySQL, SQL Server, MongoDB, etc. skills/migrations/

Alert log, ADR, adrci, space, top SQL, health checks skills/monitoring/

ORDS, REST APIs, OAuth2, AutoREST, PL/SQL gateway skills/ords/

AWR, ASH, explain plan, indexes, optimizer stats, wait events, memory skills/performance/

Packages, cursors, collections, error handling, unit testing, debugging skills/plsql/

Privileges, VPD, TDE, encryption, auditing, network security skills/security/

SQL patterns, window functions, CTEs, dynamic SQL, injection skills/sql-dev/

SQLcl commands, scripting, Liquibase CLI, MCP server, CI/CD skills/sqlcl/

Skills Directory

skills/ ├── admin/ Database administration (backup, recovery, users, redo/undo) ├── appdev/ Application development (JSON, XML, spatial, text, pooling) ├── architecture/ Infrastructure (RAC, Multitenant, Exadata, In-Memory, OCI) ├── design/ Schema design (ERD, modeling, partitioning, tablespaces) ├── devops/ CI/CD and DevOps (migrations, EBR, testing, version control) ├── features/ Oracle features (AQ, Scheduler, MVs, DBLinks, APEX) ├── migrations/ Migrating from other databases to Oracle ├── monitoring/ Diagnostics (alert log, ADR, health, space, top SQL) ├── ords/ Oracle REST Data Services ├── performance/ Tuning (AWR, ASH, indexes, optimizer, wait events, memory) ├── plsql/ PL/SQL development (packages, cursors, collections, testing) ├── security/ Security (privileges, VPD, TDE, auditing, network) ├── sql-dev/ SQL development (tuning, patterns, dynamic SQL, injection) └── sqlcl/ SQLcl CLI tool (basics, scripting, Liquibase, MCP server)

Key Starting Points

• skills/sqlcl/sqlcl-mcp-server.md — connecting AI assistants to Oracle via the SQLcl MCP server

• skills/migrations/migration-assessment.md — start here for any database migration project

• skills/performance/explain-plan.md — foundation for all SQL performance work

• skills/plsql/plsql-package-design.md — foundation for PL/SQL architecture questions

• skills/devops/schema-migrations.md — Liquibase/Flyway with Oracle in CI/CD pipelines