1---2name: db3description: Provides guidance for Oracle Database administration, SQL and PL/SQL development, performance tuning, security, ORDS, SQLcl, migrations, frameworks, and agent-safe database workflows.4---56# Oracle Database Skills78This domain contains Oracle Database skills for administration, SQL and PL/SQL development, performance tuning, security, ORDS, SQLcl, migrations, frameworks, OCR container guidance, and agent-safe database workflows.910## How to Use This Domain11121. Start with the routing table below.132. Read only the specific file or category you need.1415## Directory Structure1617```text18db/19├── admin/20├── agent/21├── appdev/22├── architecture/23├── backup-recovery/24├── containers/25├── design/26├── devops/27├── features/28├── frameworks/29├── migrations/30├── monitoring/31├── ords/32├── performance/33├── plsql/34├── security/35├── sql-dev/36└── sqlcl/37```3839## Category Routing4041| Topic | Directory |42|-------|-----------|43| Data Guard, redo/undo logs, users | `db/admin/` |44| Safe DML, destructive operation guards, idempotency, schema discovery, ORA- error handling | `db/agent/` |45| JDBC, pooling, JSON, XML, spatial, Oracle Text, transactions, MLE, language drivers | `db/appdev/` |46| RAC, Multitenant, Exadata, In-Memory, OCI database services, Data Guard architecture | `db/architecture/` |47| Backup, recovery, RMAN, Autonomous Recovery Service, Cloud Protect | `db/backup-recovery/` |48| OCR database-category container images and pull guidance | `db/containers/` |49| ERD, data modeling, partitioning, tablespaces | `db/design/` |50| Schema migrations, online operations, edition-based redefinition, testing, version control | `db/devops/` |51| AQ, DBMS_SCHEDULER, materialized views, DBLinks, APEX, vector search, SELECT AI | `db/features/` |52| SQLAlchemy, Django, Pandas, Spring JPA, MyBatis, TypeORM, Sequelize, Dapper, GORM | `db/frameworks/` |53| Migrations from PostgreSQL, MySQL, SQL Server, MongoDB, Snowflake, and more | `db/migrations/` |54| Alert log, ADR, health monitor, space management, top SQL | `db/monitoring/` |55| ORDS architecture, installation, REST design, authentication, monitoring, ORDS Concert Sample App | `db/ords/` |56| AWR, ASH, explain plan, indexes, optimizer stats, wait events, memory | `db/performance/` |57| Package design, error handling, performance, collections, cursors, debugging | `db/plsql/` |58| Privileges, VPD, masking, auditing, encryption, network security | `db/security/` |59| SQL tuning, SQL patterns, dynamic SQL, injection avoidance | `db/sql-dev/` |60| SQLcl basics, scripting, Liquibase, formatting, DDL generation, data loading, MCP server, scheduler daemon, AWR, background jobs, schema comparison with DIFF | `db/sqlcl/` |6162## Key Starting Points6364- `db/sqlcl/sqlcl-mcp-server.md`65- `db/migrations/migration-assessment.md`66- `db/performance/explain-plan.md`67- `db/plsql/plsql-package-design.md`68- `db/appdev/java-oracle-jdbc.md`69- `db/devops/schema-migrations.md`70- `db/agent/schema-discovery.md`71- `db/containers/container-selection-matrix.md`72- `db/backup-recovery/autonomous-recovery-service.md`73- `db/backup-recovery/cloud-protect.md`7475## Common Multi-Step Flows7677| Task | Recommended Sequence |78|------|----------------------|79| Diagnose a slow query | `explain-plan` → `wait-events` → `optimizer-stats` → `awr-reports` |80| Plan a migration | `migration-assessment` → `oracle-migration-tools` → source-specific `migrate-*.md` → `migration-cutover-strategy` |81| Build RAG on Oracle Database | `ai-profiles` → `vector-search` → `dbms-vector` |82| 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` |83| Perform agent-safe schema change | `schema-discovery` → `destructive-op-guards` → `idempotency-patterns` → `schema-migrations` |84| Set up AI-driven database access via MCP | `sqlcl-basics` (save connections) → `security/privilege-management` (least-privilege user) → `sqlcl-mcp-server` (configure + start) |
Oracle