A specialized tool for mapping Oracle Stored Procedure dependencies and analyzing data flow within SQL packages with pinpoint precision.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install plsql-package-analysis
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 plsql-package-analysis 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 SQL Stored Procedure Analyzer (sp-analysis)?
The sp-analysis skill is an expert-level utility designed for Openclaw Skills to handle complex Oracle SQL environments. It focuses on auditing stored procedures (SPs) within packages to provide a clear view of how data moves through a system. By analyzing the data flow from upstream to downstream SPs, it ensures developers have a complete dependency chain, making it indispensable for database maintenance and refactoring. This skill is particularly valuable for developers who need to understand legacy codebases or verify the impact of changes across interconnected database objects.
Oracle SQL Stored Procedure Analyzer (sp-analysis) Use Cases
- Visualizing complex dependency chains within large Oracle SQL packages to prevent regression.
- Auditing table access and data flow for specific stored procedures during database migrations or security reviews.
- Debugging complex logic by tracking upstream callers and downstream calls with exact line-number accuracy.
- Generating comprehensive documentation for the internal mechanism and DDL scripts of legacy stored procedures.
How Oracle SQL Stored Procedure Analyzer (sp-analysis) Works
- The agent scans the provided Oracle package file to locate the specific stored procedure requested by the user.
- It performs a mandatory line-number accuracy check to ensure all references match the actual workspace file content.
- The skill identifies all upstream procedures calling the target, extracting invoking commands and identifying which tables are read.
- It breaks down the internal logic of the target procedure into logical sections such as Preparation, Data Loading, and Transformations.
- Downstream procedures called by the target are identified to complete the dependency map.
- The tool performs a final validation pass to ensure every markdown link and line range accurately points to the source code.
Oracle SQL Stored Procedure Analyzer (sp-analysis) Setup
To integrate this skill into your workflow for Openclaw Skills, ensure your Oracle package files are available in your local workspace. There is no external installation required beyond configuring your agent with the skill instructions.
# Example of how to trigger the analysis in your AI IDE:
# Input: [SP Name] and attach [Package File]
# Example: "Analyze SP_UPDATE_RECORDS in main_package.sql"
Oracle SQL Stored Procedure Analyzer (sp-analysis) Data Schema & Taxonomy
The skill generates structured reports based on the following schema to ensure clarity and traceability in Openclaw Skills outputs:
| Data Section | Elements Captured | Metadata Format |
|---|---|---|
| Dependency Analysis | Upstream/Downstream names, Call lines, Table reads | Markdown list with file links |
| Mechanism Analysis | Input/Output parameters, Logic stages, Variable initialization | Nested bullet points |
| Body Script | Full DDL SQL script for the specific procedure | SQL code block |
| References | Exact workspace-relative paths and line ranges | [file:line-line](path#Lline-Lline) |
Oracle SQL Stored Procedure Analyzer (sp-analysis) Advanced Features
- Cross-package search capabilities to identify public procedures called across different database objects.
- Deep cursor and subquery inspection to identify all hidden table reads and system source references like SYSDATE.
- Strict line-number verification protocol that prevents summarized or truncated data from causing reference errors.
- Automated mechanism breakdown that translates complex SQL logic into human-readable functional sections.
SKILL.md
Loading
Related Openclaw Skills
OCAX Passport Skill
A comprehensive identity and resource management skill for generating unique node passports and hardware profiles within the Openclaw Skills ecosystem.
SenseAudio Jingle Forge
A specialized tool for transforming brand names and tone keywords into professional 5-15 second musical jingles and audio logos.
Flow Council
An AI-driven think tank that assembles five domain-expert agents to debate ideas, strategies, or creative work through a structured three-round process.
OpenClaw Cost Guard
A specialized governance tool designed to audit AI agent configurations for financial risk and prevent runaway token spending.
Solidity Project Setup
A specialized skill for initializing Solidity development environments and configuring OpenZeppelin smart contract libraries with Hardhat or Foundry.
BigData Toolkit
A comprehensive CLI data processing toolkit designed for ingesting, transforming, and auditing data workflows with local timestamped logging.
Featured*
