Individual skill
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".
plugins/database/stored-procedure-generator/skills/generating-stored-procedures/SKILL.md
Source commit 0500b275e963c027f6b410e8c49c0446945c574e
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- No
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Not checked yet
- Last checked
- Nov 12, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 2,917
- Repository last updated
- Nov 12, 2026
- License
- MIT
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- ai Repository topic
- automation Repository topic
- claude-code Repository topic
- devops Repository topic
- mcp Repository topic
- ai-agents Repository topic
- anthropic Repository topic
- claude-code-plugins Repository topic
- developer-tools Repository topic
- llm Repository topic
- database Declared skill tag
- deployment Declared skill tag
- postgresql Declared skill tag
- mysql Declared skill tag
- data Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
SKILL.mdcore · 7,281 bytesSKILL.mdcore · 7,281 bytesSKILL.mdcore · 7,281 bytesSKILL.mdcore · 7,281 bytesSKILL.mdcore · 7,281 bytesSKILL.mdcore · 7,281 bytesSKILL.mdcore · 7,281 bytesSKILL.mdcore · 7,281 bytesSKILL.mdcore · 7,281 bytesassets/README.mddoc · 383 bytesconfig/settings.yamlasset · 1,765 bytesreferences/README.mddoc · 624 bytesreferences/database_security_guidelines.mddoc · 6,045 bytesreferences/mysql_stored_procedure_best_practices.mddoc · 7,209 bytesreferences/postgresql_stored_procedure_best_practices.mddoc · 5,318 bytesreferences/sqlserver_stored_procedure_best_practices.mddoc · 7,957 bytesreferences/stored_procedure_optimization_techniques.mddoc · 6,808 bytesscripts/README.mddoc · 514 bytesscripts/database_connection_test.pyruns · 7,395 bytesscripts/stored_procedure_deployer.pyruns · 10,766 bytesscripts/stored_procedure_syntax_validator.pyruns · 10,572 bytes
Read excerpt
# Stored Procedure Generator
Generate production-ready stored procedures for PostgreSQL, MySQL, and SQL Server with proper error handling, transaction management, and security best practices.
## Prerequisites
- Database connection credentials (host, port, database, user, password)
- Appropriate permissions: CREATE PROCEDURE, CREATE FUNCTION, EXECUTE
- Target database type identified (PostgreSQL, MySQL, or SQL Server)
## Instructions
### Step 1: Identify Database Type and Requirements
Determine the target database and procedure requirements: