Oracle Database Skills

This collection of skills aids in Oracle Database administration, SQL and PL/SQL development, performance tuning, and security. It is designed for database administrators and developers who need comprehensive guidance on various Oracle Database topics.

000Updated 3w ago

Database Management

Quick InstallView Source

$ npx skills add https://github.com/oracle/skills --skill db

Overview

About This Skill

Oracle Database Skills provide comprehensive guidance for database administrators and developers working with Oracle databases. The skill set covers SQL and PL/SQL development, database administration, performance tuning using AWR and ASH analysis, security management including VPD and encryption, and safe agent-database operations. It includes support for SQLcl, ORDS, Liquibase, multiple language drivers (Java, Python, .NET, Node.js), and framework integrations like SQLAlchemy and Spring JPA. The skills guide users through complex tasks including query optimization, schema migrations, backup and recovery strategies, multitenant and RAC configurations, and secure database access patterns for AI agents.

How to Use

Install the skill using the provided command and choose specific files as needed.

Use Cases

Database administration and management

SQL and PL/SQL development

Performance tuning of Oracle databases

Security management for database applications

Setup & Installation

Quick Install

Terminal

$ npx skills add https://github.com/oracle/skills --skill db

Alternative Install (Git Clone)

git clone https://github.com/oracle/skills

Requirements

Claude Code or compatible AI agent

Quick Start Guide

Install the Skill

Copy the install command above and run it in your terminal.

Open Your AI Agent

Launch Claude Code, Cursor, or your preferred AI coding agent.

Try It Out

Use the prompt template or examples below to test the skill.

Customize

Adapt the skill to your specific use case and workflow.

Usage Examples

📝

No Examples Available

Check the GitHub repository or documentation for usage examples.

Apply to these tools

Browse all tools

Oracle OPERA Cloud

Enterprise-grade PMS for hotel chains and resorts

Oracle HCM

Enhance enterprise HR management with talent management and payroll solutions.

Compatible MCP servers

Browse all MCP servers

Find the right skills for your stack

Take a free 3-minute scan and get personalized AI skill recommendations.

Take free scan