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".
7.0
Rating
0
Installs
Backend Development
Category
Excellent skill for generating stored procedures across three major database platforms. The description is clear and actionable with good trigger phrases. Task knowledge is comprehensive with concrete SQL examples for PostgreSQL, MySQL, and SQL Server, including transaction management and error handling patterns. Structure is well-organized with prerequisites, step-by-step instructions, validation/deployment scripts, and helpful error handling tables. The skill provides substantial value by codifying database-specific syntax patterns, error handling conventions, and deployment automation that would otherwise require significant research and careful implementation. Minor improvement areas: could benefit from more complex scenarios like dynamic SQL generation or performance tuning examples, and the novelty is somewhat limited since experienced developers can write stored procedures manually, though the cross-platform standardization and validation tooling add meaningful efficiency gains.
jeremylongshore
Skill Author
Loading SKILL.md…
Skill Author
