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 serverskills/migrations/migration-assessment.md— start here for any database migration projectskills/performance/explain-plan.md— foundation for all SQL performance workskills/plsql/plsql-package-design.md— foundation for PL/SQL architecture questionsskills/devops/schema-migrations.md— Liquibase/Flyway with Oracle in CI/CD pipelines