CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

generating-stored-procedures

Use when you need to generate, validate, or deploy stored procedures for PostgreSQL, MySQL, or SQL Server. Creates database functions, triggers, and procedures with proper error handling and transaction management. Trigger with phrases like "generate stored procedure", "create database function", "write SQL procedure", "add trigger to table", or "create CRUD procedures".

Quality

81%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

61%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A well-structured, highly actionable skill with executable multi-database examples and genuinely useful bundle files, sequenced as a clear five-step workflow. Its main weaknesses are the missing validate-fix-retry feedback loop around database deployment, incomplete SQL Server coverage in the later steps, and redundant sections (trailing Overview, mock-dialogue Examples) that inflate token cost.

Suggestions

Add an explicit feedback loop to Steps 4-5: after running stored_procedure_syntax_validator.py, instruct Claude to fix reported errors and re-run until validation passes, and only then invoke stored_procedure_deployer.py — folding the Error Handling table's fixes into that loop.

Cut token waste: remove the trailing '## Overview' section that duplicates the frontmatter description, trim the mock-dialogue '## Examples' section, and move the per-database transaction examples into the existing per-database reference files.

Complete the three-database coverage: add SQL Server examples to Step 3 (transactions), Step 4 (validation), and Step 5 (deployment), and correct the misleading MySQL comment '# 45000 = configured value' (45000 is the standard unhandled user-defined-exception SQLSTATE, not a configured value).

DimensionReasoningScore

Conciseness

The body is mostly lean executable code with no explaining of known concepts, but it can be meaningfully tightened: the trailing '## Overview' section restates the frontmatter description ('Use when you need to generate, validate, or deploy stored procedures...'), the mock-dialogue '## Examples' section adds little actionable content, and five full parallel SQL blocks overlap ground already covered by the bundled per-database reference files. This matches 'mostly efficient but could be tightened' rather than level 4's 'minor instances of over-explanation'.

3 / 5

Actionability

Guidance is concrete and mostly copy-paste ready — full executable PL/pgSQL, MySQL, and T-SQL procedures plus exact script invocations ('python3 ${CLAUDE_SKILL_DIR}/scripts/stored_procedure_syntax_validator.py --db-type postgresql --file procedure.sql') and an error/solution table. It falls short of 5 because SQL Server is absent from the Step 3 transaction, Step 4 validation, and Step 5 deploy examples, and the MySQL comment '# 45000 = configured value' is misleading (45000 is the fixed unhandled user-defined-exception SQLSTATE).

4 / 5

Workflow Clarity

Steps 1-5 are clearly sequenced (identify database → generate → transactions → validate → deploy) with an explicit validation step before deployment, but there is no validate→fix→retry loop: nothing instructs fixing reported errors and re-running the validator before deploying. Per the rubric's scoring note, database-operation workflows missing feedback loops are capped at 3; the Error Handling table supplies fixes but does not close the loop back into re-validation, so level 4's 'minor validation gaps' is not reached.

3 / 5

Progressive Disclosure

All five reference files cited in the Resources section exist and are one level deep, and both invoked scripts (stored_procedure_syntax_validator.py, stored_procedure_deployer.py) are real, so navigation from SKILL.md is sound. It stays below 5 because the Resources list is a bare list with no when-to-use signaling, per-database example content is inlined that overlaps the per-database reference files, and assets/README.md advertises files (e.g. 'stored_procedure_template.sql') that do not exist.

4 / 5

Total

14

/

20

Passed

Description

95%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong description that explicitly states concrete capabilities (generate/validate/deploy; functions, triggers, procedures with error handling and transaction management) and enumerates natural trigger phrases for a well-defined niche. The only deduction is the second-person 'Use when you need to...' phrasing, which the rubric's third-person voice rule penalizes.

DimensionReasoningScore

Specificity

Concrete actions are explicitly stated — 'generate, validate, or deploy stored procedures' and 'Creates database functions, triggers, and procedures with proper error handling and transaction management' — matching the level-5 anchor's multiple specific, comprehensive actions. Reduced by 1 per the third-person-voice guideline because the trigger clause uses second person ('Use when you need to generate...') instead of a third-person form, so it lands at the 'several specific actions; minor gaps' anchor.

4 / 5

Completeness

Explicitly answers 'what' ('Creates database functions, triggers, and procedures with proper error handling and transaction management') and 'when' ('Use when you need to generate, validate, or deploy stored procedures for PostgreSQL, MySQL, or SQL Server', plus concrete trigger phrases). Both are concrete and explicit, matching the level-5 anchor; level 4 ('when could be more explicit') does not apply since the trigger phrases are enumerated.

5 / 5

Trigger Term Quality

Five natural phrases users would actually say — 'generate stored procedure', 'create database function', 'write SQL procedure', 'add trigger to table', 'create CRUD procedures' — plus the database names, covering the common request forms and their synonyms (procedure/function/trigger/CRUD). No obviously missing natural variants, so it fits the comprehensive anchor rather than the 'a few natural terms missing' anchor (4).

5 / 5

Distinctiveness Conflict Risk

A clear niche (stored procedures for PostgreSQL, MySQL, or SQL Server) with distinct triggers ('generate stored procedure', 'add trigger to table', 'create CRUD procedures') gives minimal conflict risk with other skills. Triggers are procedure-specific rather than generic SQL requests, so it matches the level-5 anchor rather than the 'minor overlap risk with closely related skills' anchor (4).

5 / 5

Total

19

/

20

Passed

Validation

87%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 14 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

allowed_tools_field

'allowed-tools' contains unusual tool name(s)

Warning

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

Total

14

/

16

Passed

Repository

jeremylongshore/tons-of-skills-marketplace

Path

plugins/database/stored-procedure-generator/skills/generating-stored-procedures/SKILL.md

Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.