Agent skill · software engineering · aj-geddes
stored-procedures
Implement stored procedures and functions for database logic. Use when creating reusable database routines, complex queries, or server-side calculations.
Why this skill is useful
Provides specific implementations and patterns for creating reusable database routines that the AI wouldn't reliably generate on its own.
What it needs
About 1k tokens when loaded. Last updated 2026-03-04. 307 stars on the source repository.
What this skill does
Stored Procedures & Functions Table of Contents Overview When to Use Quick Start Reference Guides Best Practices Overview Implement stored procedures, functions, and triggers for business logic, data validation, and performance optimization. Covers procedure design, error handling, and performance considerations. When to Use Business logic encapsulation Complex multi-step operations Data validation and constraints Audit trail maintenance Performance optimization Code reusability across applications Trigger-based automation Quick Start PostgreSQL - Scalar Function: Reference Guides Detailed implementations in the references/ directory: Guide Contents --- --- Simple Functions Simple Functions Stored Procedures Stored Procedures Simple Procedures Simple Procedures Complex Procedures with Error Handling Complex Procedures with Error Handling PostgreSQL Triggers PostgreSQL Triggers MySQL Triggers MySQL Triggers Best Practices ✅ DO Follow established patterns and conventions Write clean, maintainable code Add appropriate documentation Test thoroughly before deploying ❌ DON'T Skip testing or validation Ignore error handling Hard-code configuration values
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aj-geddes/stored-procedures