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".
SkillScore96Maintained
Automatic
◆Data Engineer packdatabasedeploymentpostgresql
Last verified 8/30/2026
What it changes
Passed 22 of 23 test cases with the skill, and 11 of 23 without it.
Without skill48%
With skill96%
Checks it passed that the model alone missed
Includes argument --db-type mysql.
Includes argument --db-type postgresql.
Uses stored_procedure_deployer.py script.
and 14 more in the full report
11 fixed11 passed either way1 still failing0 broke
Pass-rate lift
+48 pp
Tokens
+63%
Agent turns
0%
Response time
-17%
Model gemini-3.6-flashMeasured 8/30/2026v122 of 23 cases passed with skill
Tokens, turns and time describe resource use, not a dollar price.
See it in action
One of 11 test cases the skill fixed. Same model, same prompt, with and without the skill.
1 of 11
Prompt
Provide the exact command line invocation using the python deployer script to deploy a PostgreSQL SQL file `procedure.sql` to host `localhost` on database `mydb`.
What was checked, without and with the skill
Checked
Without skill
With skill
Uses stored_procedure_deployer.py script.
Missed
Passed
Includes argument --db-type postgresql.
Missed
Passed
case-11 · gemini-3.6-flash · 8/30/2026 · answers are capped and redacted
What's inside
The instructions your model reads when the skill loads.
SKILL.md255 lines12 filesincludes scripts
Stored Procedure Generator
Generate production-ready stored procedures for PostgreSQL, MySQL, and SQL Server with proper error handling, transaction management, and security best practices.
Target database type identified (PostgreSQL, MySQL, or SQL Server)
Instructions
Step 1: Identify Database Type and Requirements
Determine the target database and procedure requirements:
-- PostgreSQL: Check version and extensions
SELECT version();
\dx
-- MySQL: Check version and settings
SELECT VERSION();
SHOW VARIABLES LIKE 'sql_mode';
-- SQL Server: Check version and edition
SELECT @@VERSION;
Step 2: Generate Stored Procedure
PostgreSQL Function (PL/pgSQL):
CREATE OR REPLACE FUNCTION get_user_by_id(p_user_id INTEGER)
RETURNS TABLE(id INTEGER, username VARCHAR, email VARCHAR, created_at TIMESTAMP)
LANGUAGE plpgsql
AS $$
BEGIN
RETURN QUERY