run-sql-validation
Installation
SKILL.md
Run SQL Validation
Generate and present SQL validation queries for a new or modified stored procedure. The user runs the queries against RDS and reports results back.
Input
A stored procedure name or file path (e.g., "GetTopDonors" or "Database/StoredProcedure_GetTopDonors.sql").
Process
Phase 1: Read the Proc
- Find and read the stored procedure file from
Database/. - Identify: parameters, JOINs, WHERE filters, GROUP BY, ORDER BY, aggregations.
Phase 2: Generate Validation Queries
Generate numbered queries in order of diagnostic value: