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".
Overall
score
85%
Does it follow best practices?
Validation for skill structure
Install with Tessl CLI
npx tessl i github:jeremylongshore/claude-code-plugins-plus-skills --skill generating-stored-proceduresActivation
100%This is a well-crafted skill description that excels across all dimensions. It provides specific capabilities, explicit trigger guidance with natural user phrases, and clearly scopes to stored procedures and database functions across three major database platforms. The description effectively communicates both what the skill does and when to use it.
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | Lists multiple specific concrete actions: 'generate, validate, or deploy stored procedures', 'Creates database functions, triggers, and procedures with proper error handling and transaction management'. Covers specific database systems (PostgreSQL, MySQL, SQL Server). | 3 / 3 |
Completeness | Clearly answers both what (creates database functions, triggers, procedures with error handling and transaction management) AND when (explicit 'Use when' clause plus 'Trigger with phrases like' section providing clear activation guidance). | 3 / 3 |
Trigger Term Quality | Excellent coverage of natural trigger phrases users would say: 'generate stored procedure', 'create database function', 'write SQL procedure', 'add trigger to table', 'create CRUD procedures'. These are realistic user requests. | 3 / 3 |
Distinctiveness Conflict Risk | Clear niche focused specifically on stored procedures, database functions, and triggers. The specific database platforms and procedure-focused terminology distinguish it from general SQL or database skills. | 3 / 3 |
Total | 12 / 12 Passed |
Implementation
73%This skill provides comprehensive, actionable guidance for generating stored procedures across three major database platforms with executable code examples. The main weaknesses are some verbosity in showing similar patterns three times and missing explicit validation feedback loops for database deployment operations. The structure and progressive disclosure are well-executed.
Suggestions
Add explicit validation feedback loop: 'If validation fails, review errors, fix SQL, and re-validate before proceeding to deployment'
Consider consolidating the three database examples into a pattern table showing key syntax differences, with full examples in referenced files to reduce token usage
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The skill is reasonably efficient but includes some redundancy - showing nearly identical patterns across three database types when the differences could be summarized more concisely. The examples are useful but verbose for what Claude already knows about SQL syntax. | 2 / 3 |
Actionability | Provides fully executable SQL code for all three database types with complete, copy-paste ready examples. Includes concrete CLI commands for validation and deployment scripts with specific parameters. | 3 / 3 |
Workflow Clarity | Steps are clearly numbered (1-5) with a logical sequence, but validation is only mentioned in step 4 without explicit feedback loops. For database operations that could be destructive, there's no explicit 'validate -> fix -> retry' pattern or rollback verification step before deployment. | 2 / 3 |
Progressive Disclosure | Well-structured with clear sections (Prerequisites, Instructions, Output, Error Handling, Examples, Resources). References to external files are one level deep and clearly signaled. Content is appropriately split between quick examples and referenced best practices documents. | 3 / 3 |
Total | 10 / 12 Passed |
Validation
81%Validation — 13 / 16 Passed
Validation for skill structure
| Criteria | Description | Result |
|---|---|---|
allowed_tools_field | 'allowed-tools' contains unusual tool name(s) | Warning |
metadata_version | 'metadata' field is not a dictionary | Warning |
frontmatter_unknown_keys | Unknown frontmatter key(s) found; consider removing or moving to metadata | Warning |
Total | 13 / 16 Passed | |
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.