Oracle Database Skills

This domain contains Oracle Database skills for administration, SQL and PL/SQL development, performance tuning, security, ORDS, SQLcl, migrations, frameworks, VecDB SDK/REST/PL/SQL workflows, OCR container guidance, and agent-safe database workflows.

How to Use This Domain

Start with the routing table below.
Read only the specific file or category you need.

Directory Structure

db/
├── admin/
├── agent/
├── appdev/
├── architecture/
├── backup-recovery/
├── containers/
├── design/
├── devops/
├── features/
├── frameworks/
├── migrations/
├── monitoring/
├── ords/
├── performance/
├── plsql/
├── security/
├── sql-dev/
├── sqlcl/
└── vecdb/

Category Routing

Topic	Directory
Data Guard, redo/undo logs, users	`db/admin/`
Safe DML, destructive operation guards, idempotency, schema discovery, ORA- error handling	`db/agent/`
JDBC, Python, .NET, pooling, JSON, XML, spatial, Oracle Text, transactions, MLE, language drivers	`db/appdev/`
RAC, Multitenant, Exadata, In-Memory, OCI database services, Data Guard architecture	`db/architecture/`
Backup, recovery, RMAN, Autonomous Recovery Service, Cloud Protect	`db/backup-recovery/`
OCR database-category container images and pull guidance	`db/containers/`
ERD, data modeling, partitioning, tablespaces	`db/design/`
Schema migrations, online operations, edition-based redefinition, testing, version control	`db/devops/`
AQ, DBMS_SCHEDULER, materialized views, DBLinks, APEX, vector search, SELECT AI	`db/features/`
SQLAlchemy, Django, Pandas, Spring JPA, MyBatis, TypeORM, Sequelize, Dapper, GORM	`db/frameworks/`
Migrations from PostgreSQL, MySQL, SQL Server, MongoDB, Snowflake, and more	`db/migrations/`
Alert log, ADR, health monitor, space management, top SQL	`db/monitoring/`
ORDS architecture, installation, REST design, authentication, monitoring, ORDS Concert Sample App	`db/ords/`
AWR, ASH, explain plan, indexes, optimizer stats, wait events, memory	`db/performance/`
Package design, error handling, performance, collections, cursors, debugging	`db/plsql/`
Privileges, Deep Data Security, VPD, masking, auditing, encryption, network security	`db/security/`
SQL tuning, SQL patterns, dynamic SQL, injection avoidance	`db/sql-dev/`
SQLcl basics, scripting, Liquibase, formatting, DDL generation, data loading, MCP server, scheduler daemon, AWR, background jobs, schema comparison with DIFF	`db/sqlcl/`
Oracle Vector SDK setup and configuration, including database preparation, Python SDK, REST API, PL/SQL package, version prerequisites, vector tables, ingestion, models, search, reranking, indexes, and jobs	`db/vecdb/`

Key Starting Points

db/sqlcl/sqlcl-mcp-server.md
db/migrations/migration-assessment.md
db/performance/explain-plan.md
db/plsql/plsql-package-design.md
db/appdev/java-oracle-jdbc.md
db/devops/schema-migrations.md
db/security/deep-data-security.md
db/agent/schema-discovery.md
db/containers/container-selection-matrix.md
db/backup-recovery/autonomous-recovery-service.md
db/backup-recovery/cloud-protect.md
db/vecdb/vecdb-provisioning.md
db/vecdb/vecdb-architecture.md

Common Multi-Step Flows

Task	Recommended Sequence
Diagnose a slow query	`explain-plan` → `wait-events` → `optimizer-stats` → `awr-reports`
Plan a migration	`migration-assessment` → `oracle-migration-tools` → source-specific `migrate-*.md` → `migration-cutover-strategy`
Build RAG on Oracle Database	`ai-profiles` → `vector-search` → `dbms-vector`
Build a Java JDBC service	`java-oracle-jdbc` → `java-oracle-jdbc/dependencies` → `java-oracle-jdbc/connections` → `java-oracle-jdbc/sql` → `java-oracle-jdbc/pooling-production`
Perform agent-safe schema change	`schema-discovery` → `destructive-op-guards` → `idempotency-patterns` → `schema-migrations`
Set up AI-driven database access via MCP	`security/deep-data-security` (end-user authorization) → `sqlcl-basics` (save connections) → `sqlcl-mcp-server` (configure + start)
Set up an Oracle Vector SDK database deployment	`vecdb-provisioning` → Oracle Vector SDK Quick Start → Prepare an AI Database
Build vector-based applications for semantic search, RAG, or recommendations using Oracle Vector SDK's fixed-schema APIs through the Python SDK, REST, or PL/SQL	`vecdb-architecture` → `vecdb-api-reference` → relevant capability file (`vecdb-models`, `vecdb-vector-tables`, `vecdb-search`, or `vecdb-indexes`)