An expert coding skill for generating optimized Oracle SQL and PL/SQL blocks with enterprise-grade performance patterns.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install oracle-db
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install oracle-db using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Oracle DB?
The Oracle DB skill is a specialized module for Openclaw Skills designed to bridge the gap between generic SQL generation and the specific nuances of the Oracle Database ecosystem. It equips AI agents with the deep domain knowledge required to handle Oracle-specific syntax like ROWNUM pagination, DUAL table expressions, and the unique behavior where empty strings are treated as NULL values.
By integrating this skill, developers can ensure their AI assistants produce production-ready PL/SQL blocks, manage sequences correctly, and utilize performance hints like INDEX or PARALLEL. This Openclaw Skills extension is essential for teams working in enterprise environments where Oracle's specific dialect and performance optimization strategies are paramount.
Oracle DB Use Cases
- Generating complex hierarchical queries using CONNECT BY and START WITH traversal logic.
- Optimizing legacy SQL queries by injecting Oracle-specific performance hints to improve execution plans.
- Writing robust PL/SQL anonymous blocks with proper exception handling and DBMS_OUTPUT debugging.
- Implementing efficient pagination logic using 12c+ FETCH FIRST syntax or traditional ROWNUM subqueries.
- Managing database schema transitions using sequences and identity columns for primary key generation.
How Oracle DB Works
- The AI agent identifies a request related to Oracle Database operations or SQL generation tasks within the Openclaw Skills framework.
- The skill provides the specific syntax rules for Oracle, such as using VARCHAR2 instead of VARCHAR and handling date arithmetic in days.
- The agent applies Oracle-specific functions like NVL or NVL2 for NULL handling based on the skill's logic patterns.
- If performance is a priority, the skill guides the agent to include bind variables and execution hints to optimize shared pool usage.
- The resulting SQL or PL/SQL code is formatted for execution via tools like sqlplus, ensuring compatibility with standard database administrative workflows.
Oracle DB Setup
To use this skill within your Openclaw Skills environment, ensure you have the necessary database CLI tools installed and available on your system path.
# Ensure sqlplus or sql (SQLcl) is installed and accessible
sqlplus -version
# The skill requires one of the following binaries:
# - sqlplus
# - sql
Oracle DB Data Schema & Taxonomy
The skill organizes Oracle-specific knowledge into several logical categories to ensure high-quality code generation:
| Category | Key Elements Managed |
|---|---|
| Syntax | ROWNUM, DUAL table, VARCHAR2, and string concatenation ( |
| Pagination | 12c FETCH/OFFSET and legacy nested ROWNUM subqueries. |
| NULLs | NVL, NVL2, and NULLIF logic (handling empty strings as NULL). |
| Dates | SYSDATE, TO_DATE, TO_CHAR, and day-based date arithmetic. |
| Sequences | NEXTVAL, CURRVAL, and 12c Identity Columns. |
| Hierarchical | CONNECT BY, START WITH, LEVEL, and SYS_CONNECT_BY_PATH. |
Oracle DB Advanced Features
- Multi-version pagination support automatically switching between 12c OFFSET and legacy nested subqueries based on context.
- Advanced hierarchical tree traversal logic with depth limiting and path building via SYS_CONNECT_BY_PATH.
- Automatic injection of bind variables (:variable) to prevent hard parsing and reduce shared pool contention.
- Sophisticated performance diagnostics using EXPLAIN PLAN and DBMS_XPLAN.DISPLAY integration.
- Explicit transaction management support, including SAVEPOINT logic and DDL auto-commit awareness.
SKILL.md
Loading
Related Openclaw Skills
OpenTable
A strategic AI-driven advisor for managing OpenTable restaurant operations, focusing on booking optimization, guest communication, and performance tracking.
Open Source
A structured framework for managing the entire open source lifecycle, from project discovery and evaluation to maintenance and publication.
Open Router
A robust routing engine for OpenRouter that automates model selection, fallback logic, and cost management for multi-model AI workflows.
Onboarding
A strategic framework for designing high-conversion user onboarding flows that prioritize activation and user value.
Organize
A proactive organization tool that learns user preferences to structure files and folders during the active workflow.
Outfits
A personal style assistant that manages your wardrobe inventory and plans outfits for any occasion.
Featured*
