oracle-db-skills

Name: oracle-db-skills
Author: oracle

github.com/oracleData & databases904288 installsUpdated 3w ago

About oracle-db-skills

oracle-db-skills is a collection of standalone reference guides for Oracle Database users and developers. Its 103 topic-specific files cover practical examples, best practices, and common mistakes.

Key features

01103 topic-specific guides
02Category-based topic routing
03Practical examples and best practices
04Coverage from administration to SQLcl

Use cases

01Finding guidance for Oracle database administration
02Reviewing SQL performance and PL/SQL design
03Planning database migrations
04Connecting AI assistants to Oracle via SQLcl MCP server

MCP support

One guide covers connecting AI assistants to Oracle through the SQLcl MCP server.

Install

Copy the command and run it in a terminal.

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

After installing, type/oracle-db-skillsin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

README.md

.gitignore

AGENTS.md

CLAUDE.md

SKILL_GENERATION_PROMPT.md

GUIDELINES.md

LICENSE

SKILLS.md

skills-index.md

.github/rulesets/

main.json

scripts/

apply-github-ruleset.sh

skills/admin/

dataguard.md

undo-management.md

redo-log-management.md

backup-recovery.md

rman-basics.md

user-management.md

skills/agent/

client-identification.md

destructive-op-guards.md

idempotency-patterns.md

intent-disambiguation.md

nl-to-sql-patterns.md

safe-dml-patterns.md

schema-discovery.md

ora-error-catalog.md

skills/appdev/

connection-pooling.md

dotnet-oracle.md

golang-oracle.md

nodejs-oracledb.md

java-oracle-jdbc.md

Details

From the project README

Oracle DB Skills

A collection of 103 standalone reference guides for Oracle Database. Each file covers one topic with explanations, practical examples, best practices, and common mistakes.

How to Use

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

Category Routing

User asks about…	Read from
Backup, recovery, RMAN, Data Guard, redo/undo logs, users	`skills/admin/`
JDBC, connection pooling, JSON, XML, spatial, full-text, transactions	`skills/appdev/`
RAC, CDB/PDB, Exadata, In-Memory, OCI, ATP/ADW	`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/`

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)
├── 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

Comments

Markdown supported

Details

Author: oracle
Repository: oracle/skills
Category: Data & databases
Installs: 288
GitHub stars: 904

Report

More skills

All skills

hyperframes-core

github.com/heygen-com

930.6k

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="clip"`, tracks, sub-compositions, variables, framework-owned media playback, deterministic-render rules, and validation. Also covers Tailwind projects and the STORYBOARD.md / SCRIPT.md plan formats. Read before writing composition HTML.

lark-base

open.feishu.cn

823.2k

Operate on Feishu Base: create tables, fields, records, and views; handle statistics, formulas/lookups, forms, dashboards, app mode (BaseApp/AppMode pages and components), Workspace directories, workflows, role permissions, and the template center (Base template categories, lists, and search). Use when encountering Base/multidimensional tables/bitable, BaseApp/AppMode, or /base/ or /app/ links. Do not use lark-apps for BaseApp; route file import/export to lark-drive and authentication/authorization to lark-shared.

lark-sheets

open.feishu.cn

821.8k

Feishu Spreadsheets: create and operate spreadsheets. Supports worksheets and row/column structures (add/delete/merge/size/hide/freeze/group), cell read/write (values/formulas/styles/comments/cell images), range copy/move/sort/fill, find and replace, bulk updates, and creating and maintaining objects such as charts, pivot tables, conditional formatting, filters and filter views, dropdown lists, sparklines, and floating images. Also supports formula validation, restoring historical versions, and importing/exporting local Excel/CSV files and Feishu spreadsheets. Use when users need to create or edit spreadsheets, summarize and visualize data, format spreadsheets, calculate formulas (including migrating Excel formulas), or build financial models (DCF, three statements, budgets, Sensitivity, etc.). For multidimensional tables (Base/bitable), use lark-base. If users want to search for spreadsheet files in cloud storage (Drive/cloud storage) by name or keyword, use lark-drive's drive +search to locate resources first. When users provide a doubao.com /sheets/ URL/token, use this skill directly; do not fall back to WebFetch because the domain is not Feishu. Routing is based on the URL path pattern and token, not the domain.

remotion-best-practices

github.com/remotion-dev

701.4k

Best practices and domain knowledge for building videos programmatically with Remotion (videos in React/TypeScript, rendered to MP4). Use whenever writing or editing Remotion code — scaffolding a video project, animating with interpolate/spring over useCurrentFrame(), sequencing scenes and transitions, captions/subtitles, audio, GIFs/Lottie/3D, charts, visual effects, dynamic duration via calculateMetadata, or rendering. Consult before reaching for a Remotion API, since its components and props evolve (e.g. @remotion/media).