oracle/skills

db

Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows. Use when the user asks to write, edit, rewrite, review, format, debug, tune, or explain SQL; create or refactor PL/SQL; use SQLcl, Liquibase, ORDS, JDBC, node-oracledb, Python, Java, .NET, or database frameworks; troubleshoot queries, sessions, locks, waits, indexes, optimizer plans, AWR, ASH, migrations, schemas, users, roles, privileges,…

All-time #5733 Trending #4073 First seen Apr 29, 2026
8-week activity · all time api

Installation

$ npx skills add oracle/skills --skill db

Summary

  • Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows.
  • Use when the user asks to write, edit, rewrite, review, format, debug, tune, or explain SQL; create or refactor PL/SQL; use SQLcl, Liquibase, ORDS, JDBC, node-oracledb, Python, Java, .NET, or database frameworks; troubleshoot queries, sessions, locks, waits, indexes, optimizer plans, AWR, ASH, migrations, schemas, users, roles, privileges, backup, recovery, Data Guard, RAC, multitenant, containers, monitoring, auditing, encryption, VPD, or safe agent database operations.

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

Also in this package

Other skills from oracle/skills · top by installs.

npx skills add oracle/skills

Browse all from oracle/skills

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Repository health

Stars 833
License LICENSE.txt
Default branch main
Open issues 29
Status Active

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 4,673 B
  • docs SUMMARY.md 643 B

History

  1. First seen on skills.sh
  2. First recorded snapshot · 2,225 installs

SKILL.md

Oracle Database Skills

This 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.

How to Use This Domain

  1. Start with the routing table below.
  2. 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/

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/

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

Common Multi-Step Flows

Task Recommended Sequence
Diagnose a slow query explain-planwait-eventsoptimizer-statsawr-reports
Plan a migration migration-assessmentoracle-migration-tools → source-specific migrate-*.mdmigration-cutover-strategy
Build RAG on Oracle Database ai-profilesvector-searchdbms-vector
Build a Java JDBC service java-oracle-jdbcjava-oracle-jdbc/dependenciesjava-oracle-jdbc/connectionsjava-oracle-jdbc/sqljava-oracle-jdbc/pooling-production
Perform agent-safe schema change schema-discoverydestructive-op-guardsidempotency-patternsschema-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)