Oracle
A comprehensive skill catalog for AI agents
npx -y skills add G1Joshi/Agent-Skills --skill oracleAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 10 stars10 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
Oracle Database with PL/SQL, RAC, and enterprise features. Use for enterprise systems.
SKILL.md
1.9 KB, 426 tokens by cl100k_base, as published. Nobody here has run it
Oracle Database
Oracle Database is a multi-model database management system. It is the de-facto standard for Fortune 500 mission-critical systems due to its reliability, scalability (RAC), and PL/SQL power.
When to Use
- Mission Critical: Banking, Airlines, Telecoms where 99.999% uptime is required.
- PL/SQL: When you have massive business logic that needs to run close to the data.
- Complex Workloads: OLTP and OLAP in the same DB.
Quick Start
-- Implicit cursor loop in PL/SQL
BEGIN
FOR r IN (SELECT first_name, last_name FROM employees WHERE department_id = 10)
LOOP
DBMS_OUTPUT.PUT_LINE(r.first_name || ' ' || r.last_name);
END LOOP;
END;
/
Core Concepts
PL/SQL
Procedural Language/SQL. Extremely mature and powerful language stored within the DB.
RAC (Real Application Clusters)
Allows multiple servers to access the same database storage simultaneously. If one server fails, the others keep running (High Availability).
Multi-Tenant (CDB/PDB)
One Container Database (CDB) hosts multiple Pluggable Databases (PDBs). Efficient resource sharing.
Best Practices (2025)
Do:
- Use Oracle 23ai: Leverage "JSON Relational Duality" to view the same data as both Tables and JSON Documents simultaneously.
- Use Tuning Advisor: Oracle's automated tuning tools are excellent.
- Use Flashback: Query data "as of" a timestamp in the past to recover from accidental logical errors.
Don't:
- Don't commit in loops: It kills IO. Commit once at the end.
- Don't treat it like MySQL: Oracle's architecture (Redo, Undo, Shared Pool) is heavier and requires specific tuning.