← 返回 Skills 市场
224
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install plsql-package-analysis
功能描述
You are an expert in Oracle SQL. Search the SP (Stored Procedure) name from the chatbox in the SQL package and analyze. LLM base model temperature should be...
安全使用建议
This skill is coherent for analyzing PL/SQL packages: it will read package files and workspace files to produce exact call-line references. Before installing or invoking it, ensure you only provide the package(s) you intend to analyze and do not expose repositories containing sensitive SQL, credentials, or production-only scripts. Because the skill requires exact-line verification and workspace-relative links, the agent may scan other files in the workspace to resolve upstream/downstream calls—restrict the workspace or provide a minimal attachment if you want to limit exposure. Review its output before sharing externally. If you need higher assurance, test the skill on a non-sensitive sample package first.
功能分析
Type: OpenClaw Skill
Name: plsql-package-analysis
Version: 1.0.0
The skill bundle is designed to perform static analysis of Oracle PL/SQL stored procedures within a provided package file. The instructions in SKILL.md guide the agent to identify upstream/downstream dependencies, map data flows, and extract logic summaries with precise line-number references for VS Code integration. There are no signs of data exfiltration, malicious command execution, or harmful prompt injection; the behavior is entirely consistent with its stated purpose of code analysis.
能力评估
Purpose & Capability
The skill declares it will locate and analyze a stored procedure inside an attached PL/SQL package and its instructions only reference reading the provided package file and deriving call relationships. There are no unrelated binaries, credentials, or installs requested that would be unexpected for this purpose.
Instruction Scope
The SKILL.md mandates exact line-number verification, re-opening workspace files, and emitting workspace-relative clickable links. That is coherent with producing precise code pointers, but it requires the agent to read the repository/workspace (potentially multiple SQL files) and produce link fragments. This is expected for the analysis task but means the agent will access file contents beyond the single attached file if those files exist in the workspace—review which files are available to the agent before running.
Install Mechanism
Instruction-only skill with no install steps and no code files; nothing will be written to disk or fetched during install.
Credentials
No environment variables, credentials, or config paths are requested. The declared requirements match the described functionality.
Persistence & Privilege
always is false and the skill does not request or imply persistent/system-wide privileges or modifications to other skills. Autonomous invocation is allowed (platform default) but not combined with other risky capabilities.
如何使用
- 确保已安装 OpenClaw(本地或 Docker 部署)
- 在对话框中输入安装命令:
/install plsql-package-analysis - 安装完成后,直接呼叫该 Skill 的名称或使用
/plsql-package-analysis触发 - 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.0
sp-analysis v1.0.0
- Initial release of the skill.
- Analyze Oracle package files for specified stored procedure (SP) dependencies and data flow.
- Accurately presents upstream and downstream SP relationships with exact line number references and clickable markdown links.
- Includes mechanism analysis breaking down key logic sections of the target SP.
- Outputs procedure DDL body with strict adherence to validated structure and file locations.
- Uses `None` for missing upstream or downstream dependencies, following formatting and link requirements.
元数据
常见问题
SP Analysis in PL/SQL Package 是什么?
You are an expert in Oracle SQL. Search the SP (Stored Procedure) name from the chatbox in the SQL package and analyze. LLM base model temperature should be... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 224 次。
如何安装 SP Analysis in PL/SQL Package?
在 OpenClaw 或 Claude Code 对话框中运行命令「/install plsql-package-analysis」即可一键安装,无需额外配置。
SP Analysis in PL/SQL Package 是免费的吗?
是的,SP Analysis in PL/SQL Package 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。
SP Analysis in PL/SQL Package 支持哪些平台?
SP Analysis in PL/SQL Package 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。
谁开发了 SP Analysis in PL/SQL Package?
由 JohnsRun(@johnsrun)开发并维护,当前版本 v1.0.0。
推荐 Skills