BF sp-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 0. Analyze the data flow of Oracle stored procedures (SPs) within a package, showing complete dependency chains from Upstream SP to downstream SP. And then show the target SP details. Ensure no steps are skipped, and all relevant SPs are included.
As a process F 42/100 · Will not run — References files that are not bundled: ..., ..., Demo_GC_Usage/03Development_Zone/Oracle_Package/JTA_Packages.sql
How to improve
- Say in the description WHEN to use the skill ("use when…", example requests): that is the agent's main cue.
- The text references files that are not there: add them or drop the references.
- Your own cases (evals/evals.json, 4–6 real requests with expected answers): the full check would then run those instead of a model-drafted suite.
- A spec.yaml with trigger phrases and assertions — a behaviour contract for CI; `skilltest init` writes a template.
Guard findings · 0
✓ No critical or high findings
Files scanned: 3. Evidence is masked. Grey chips explain why severity was lowered.
Against the Agent Skills spec
- warning
description-no-whendescription does not say WHEN to use the skill (no "use when") - warning
missing-refreference to a missing file: ... - warning
missing-refreference to a missing file: ... - warning
missing-refreference to a missing file: Demo_GC_Usage/03Development_Zone/Oracle_Package/JTA_Packages.sql - warning
missing-refreference to a missing file: ../02Development_Zone/Oracle_Package/JTA_Packages.sql - warning
missing-refreference to a missing file: ../02Development_Zone/Oracle_Package/JTA_Packages.sql - warning
missing-refreference to a missing file: ../02Development_Zone/Oracle_Package/JTA_Packages.sql - warning
missing-refreference to a missing file: ../02Development_Zone/Oracle_Package/JTA_Packages.sql - warning
missing-refreference to a missing file: ../02Development_Zone/Oracle_Package/JTA_Packages.sql - warning
missing-refreference to a missing file: ../02Development_Zone/Oracle_Package/JTA_Packages.sql
Process rating: all ten parameters 42/100
- 0Tools and files. 9 referenced file(s) missing: ..., ..., Demo_GC_Usage/03Development_Zone/Oracle_Package/JTA_Packages.sql
- 0Inputs and preconditions. Does not say what the process needs to start
- 0Progress reporting. Says nothing while it works
- 20When it triggers. No condition that starts the skill
- 30Running it twice. 2 mutating operations with no state check
- 40Consistency. Frontmatter name (sp-analysis) differs from the folder (plsql-package-analysis)
- 60Result and completion. Output format stated, no completion criterion
- 60Failures and branches. 2 branches
- 100Steps. 20 steps
- 100Execution cost. Instruction body is 1643 tokens
- medium Safety rules and hard prohibitions inside a skill: they belong in the system prompt, here they protect nothing
Everything here is measured from the skill text rather than judged by a model, so the numbers are checkable. A parameter weighs more when it is a more common reason for the process to stall.
Quality signals
- +5Description has no quoted example phrases that should trigger the skill
- +4Description does not say when NOT to use the skill (false activations)
- +1No license
- +2Single-language instructions
- +3Description length 404: enough signal without eating the budget
- +4Structure: 4 headings
- +3Step-by-step instructions: 20 items
- +3Output format is stated explicitly
- +4Has examples (2 code blocks)
Quality base 70; lint remarks subtract, signals add up to 100. Result: 63.