oracle-db-skills

Category: Databases & Storage | Uploader: krisrice | Downloads: 0 | Version: v1.0（Latest）

128 Oracle Database and OCR container reference guides covering SQL, PL/SQL, performance tuning, security, ORDS, SQLcl, container images, migrations, and more. Load individual skill files on demand for expert guidance on any Oracle topic.

Changelog: Source: GitHub https://github.com/krisrice/oracle-db-skills

Directory Structure

Current level: Root

📁 .github/
- 📁 rulesets/
  - 📄 main.json 871 B
📁 scripts/
- 📄 apply-github-ruleset.sh 965 B
📁 skills/
- 📁 admin/
  - 📄 backup-recovery.md 15.7 KB
  - 📄 redo-log-management.md 17.9 KB
  - 📄 rman-basics.md 17.3 KB
  - 📄 undo-management.md 13.9 KB
  - 📄 user-management.md 18.8 KB
- 📁 appdev/
  - 📄 connection-pooling.md 14.7 KB
  - 📄 dotnet-oracle.md 9.4 KB
  - 📄 golang-oracle.md 8.5 KB
  - 📄 java-oracle-jdbc.md 10.3 KB
  - 📄 json-in-oracle.md 17.8 KB
  - 📄 locking-concurrency.md 17.2 KB
  - 📄 nodejs-oracledb.md 8.0 KB
  - 📄 oracle-text.md 20.0 KB
  - 📄 python-oracledb.md 8.9 KB
  - 📄 sequences-identity.md 16.3 KB
  - 📄 spatial-data.md 17.6 KB
  - 📄 sql-property-graph.md 21.8 KB
  - 📄 transaction-management.md 16.8 KB
  - 📄 xml-in-oracle.md 16.9 KB
- 📁 architecture/
  - 📄 dataguard.md 22.5 KB
  - 📄 exadata-features.md 21.7 KB
  - 📄 inmemory-column-store.md 21.4 KB
  - 📄 multitenant.md 18.7 KB
  - 📄 oracle-cloud-oci.md 18.4 KB
  - 📄 rac-concepts.md 22.3 KB
- 📁 containers/
  - 📄 adb-free.md 2.4 KB
  - 📄 cman.md 2.4 KB
  - 📄 container-selection-matrix.md 6.3 KB
  - 📄 enterprise.md 2.3 KB
  - 📄 enterprise_ru.md 2.2 KB
  - 📄 free.md 2.3 KB
  - 📄 graph-quickstart.md 2.5 KB
  - 📄 gsm.md 2.2 KB
  - 📄 gsm_ru.md 2.3 KB
  - 📄 instantclient.md 2.2 KB
  - 📄 microtx-ee-console.md 2.5 KB
  - 📄 microtx-ee-coordinator.md 2.7 KB
  - 📄 observability-exporter.md 2.3 KB
  - 📄 operator.md 2.4 KB
  - 📄 ords.md 2.4 KB
  - 📄 otmm.md 2.4 KB
  - 📄 private-ai.md 2.6 KB
  - 📄 rac.md 2.5 KB
  - 📄 rac_ru.md 2.6 KB
  - 📄 SKILLS.md 2.0 KB
  - 📄 sqlcl.md 2.4 KB
- 📁 design/
  - 📄 data-modeling.md 23.3 KB
  - 📄 erd-design.md 19.9 KB
  - 📄 partitioning-strategy.md 22.3 KB
  - 📄 tablespace-design.md 24.9 KB
- 📁 devops/
  - 📄 database-testing.md 21.2 KB
  - 📄 edition-based-redefinition.md 16.3 KB
  - 📄 online-operations.md 17.3 KB
  - 📄 schema-migrations.md 20.7 KB
  - 📄 version-control-sql.md 20.9 KB
- 📁 features/
  - 📄 advanced-queuing.md 17.6 KB
  - 📄 database-links.md 16.0 KB
  - 📄 dbms-scheduler.md 21.5 KB
  - 📄 materialized-views.md 16.4 KB
  - 📄 oracle-apex.md 20.7 KB
  - 📄 virtual-columns.md 13.8 KB
- 📁 migrations/
  - 📄 migrate-db2-to-oracle.md 19.8 KB
  - 📄 migrate-mongodb-to-oracle.md 19.5 KB
  - 📄 migrate-mysql-to-oracle.md 19.9 KB
  - 📄 migrate-postgres-to-oracle.md 19.7 KB
  - 📄 migrate-redshift-to-oracle.md 18.3 KB
  - 📄 migrate-snowflake-to-oracle.md 19.2 KB
  - 📄 migrate-sqlite-to-oracle.md 19.7 KB
  - 📄 migrate-sqlserver-to-oracle.md 18.7 KB
  - 📄 migrate-sybase-to-oracle.md 20.3 KB
  - 📄 migrate-teradata-to-oracle.md 18.4 KB
  - 📄 migration-assessment.md 19.6 KB
  - 📄 migration-cutover-strategy.md 22.8 KB
  - 📄 migration-data-validation.md 22.2 KB
  - 📄 oracle-migration-tools.md 17.3 KB
- 📁 monitoring/
  - 📄 adrci-usage.md 17.9 KB
  - 📄 alert-log-analysis.md 17.0 KB
  - 📄 health-monitor.md 20.0 KB
  - 📄 space-management.md 21.9 KB
  - 📄 top-sql-queries.md 22.1 KB
- 📁 ords/
  - 📄 ords-architecture.md 13.1 KB
  - 📄 ords-authentication.md 14.2 KB
  - 📄 ords-auto-rest.md 13.1 KB
  - 📄 ords-file-upload-download.md 16.4 KB
  - 📄 ords-installation.md 14.7 KB
  - 📄 ords-metadata-catalog.md 13.8 KB
  - 📄 ords-monitoring.md 17.5 KB
  - 📄 ords-pl-sql-gateway.md 16.6 KB
  - 📄 ords-rest-api-design.md 17.5 KB
  - 📄 ords-security.md 16.2 KB
- 📁 performance/
  - 📄 ash-analysis.md 15.9 KB
  - 📄 awr-reports.md 13.7 KB
  - 📄 explain-plan.md 15.7 KB
  - 📄 index-strategy.md 20.8 KB
  - 📄 memory-tuning.md 18.5 KB
  - 📄 optimizer-stats.md 15.7 KB
  - 📄 wait-events.md 18.9 KB
- 📁 plsql/
  - 📄 plsql-code-quality.md 14.9 KB
  - 📄 plsql-collections.md 14.5 KB
  - 📄 plsql-compiler-options.md 15.0 KB
  - 📄 plsql-cursors.md 15.1 KB
  - 📄 plsql-debugging.md 15.6 KB
  - 📄 plsql-dynamic-sql.md 17.7 KB
  - 📄 plsql-error-handling.md 16.9 KB
  - 📄 plsql-package-design.md 13.9 KB
  - 📄 plsql-patterns.md 18.9 KB
  - 📄 plsql-performance.md 16.1 KB
  - 📄 plsql-security.md 14.7 KB
  - 📄 plsql-unit-testing.md 16.1 KB
- 📁 security/
  - 📄 auditing.md 20.5 KB
  - 📄 data-masking.md 20.3 KB
  - 📄 encryption.md 20.5 KB
  - 📄 network-security.md 22.1 KB
  - 📄 privilege-management.md 19.0 KB
  - 📄 row-level-security.md 20.3 KB
- 📁 sql-dev/
  - 📄 dynamic-sql.md 19.2 KB
  - 📄 pl-sql-best-practices.md 19.5 KB
  - 📄 sql-best-practices.md 47.6 KB
  - 📄 sql-injection-avoidance.md 16.5 KB
  - 📄 sql-patterns.md 18.9 KB
  - 📄 sql-tuning.md 14.9 KB
- 📁 sqlcl/
  - 📄 sqlcl-basics.md 13.1 KB
  - 📄 sqlcl-cicd.md 19.4 KB
  - 📄 sqlcl-data-loading.md 14.7 KB
  - 📄 sqlcl-ddl-generation.md 16.6 KB
  - 📄 sqlcl-formatting.md 15.5 KB
  - 📄 sqlcl-liquibase.md 15.2 KB
  - 📄 sqlcl-mcp-server.md 9.1 KB
  - 📄 sqlcl-scripting.md 15.9 KB
📄 .gitignore 20 B
📄 AGENTS.md 4.7 KB
📄 CLAUDE.md 4.9 KB
📄 LICENSE 1.0 KB
📄 README.md 16.8 KB
📄 SKILL.md 4.0 KB
📄 SKILL_GENERATION_PROMPT.md 4.4 KB
📄 skills-index.md 12.9 KB
📄 SKILLS.md 16.4 KB

SKILL.md

---
name: oracle-db-skills
description: 128 Oracle Database and OCR container reference guides covering SQL, PL/SQL, performance tuning, security, ORDS, SQLcl, container images, migrations, and more. Load individual skill files on demand for expert guidance on any Oracle topic.
---

# Oracle DB Skills

A collection of 128 standalone reference guides for Oracle Database and OCR database-category container images. Each file covers one topic with explanations, practical examples, best practices, and common mistakes.

## How to Use

1. **Find the right skill** using the category routing table below.
2. **Read only the file(s)** relevant to the user's task — do not load all files at once.
3. **Apply the guidance** to answer questions, generate code, or review existing work.

## Category Routing

| User asks about… | Read from |
|------------------|-----------|
| Backup, recovery, RMAN, redo/undo logs, users | `skills/admin/` |
| JDBC, connection pooling, JSON, XML, spatial, full-text, transactions, property graphs | `skills/appdev/` |
| RAC, CDB/PDB, Exadata, In-Memory, OCI, ATP/ADW, Data Guard | `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/` |
| Oracle Container Registry images, container pull commands, tags, and OCR repository selection | `skills/containers/` |

## 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)
├── containers/     OCR Database-category container repositories
├── 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
- **`skills/containers/container-selection-matrix.md`** — quick decision matrix for choosing the right OCR database-category image

Comments 0

Latest | Hot

Please login before commenting.

No comments yet. Be the first one!

oracle-db-skills

Directory Structure

SKILL.md

Report

Notice