home/categories/sql-databases/jeremylongshore-claude-code-plugins-plus-skills-plugins-database-stored-procedure-generator-skills-generating-stored-procedures-skill-md
sql-databasesdatabases

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".

jeremylongshore
maintainer
jeremylongshore
Updated 4/3/2026
Stars
1898
Forks
258
quick start

Installation and usage

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".

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use generating-stored-procedures