SQL Practice Code Audit
Prompts
-
SQL Query Review Checklist for Correctness, Not Just Speed
Review a query for logic errors.
-
SQL Slowly Changing Data and History Table Audit
Check that history is captured and queried correctly.
-
SQL Join Fan-Out and Duplicate Row Audit
Find join logic that multiplies rows and inflates totals, with a test query plan and corrected pattern for each risky join.
-
SQL NULL Handling and Hidden Data Loss Audit
Review a SQL query for NULL traps in joins, filters, comparisons and aggregates that silently drop or distort rows.
-
SQL Execution Plan and Index Usage Reading Review
Interpret a pasted query plan in plain English, find scans, bad estimates and missing indexes, and list safe things to test.
-
SQL Injection Risk Review for Query-Building Code
Defensive review of your own application code that builds SQL, finding string concatenation, risky inputs and the safe parameterised fix.
-
SQL Date, Time Zone and Period Logic Audit
Check a SQL report for date boundary errors, time zone mix-ups, inclusive or exclusive ranges and period comparisons that quietly mislead.
-
SQL Readability, Naming and Style Audit
Review SQL for readable layout, clear aliases, consistent naming and comments, and get a rewritten version plus a team style guide.
-
SQL Report Totals Reconciliation Check
Build a set of reconciliation queries and a comparison table to prove a SQL report matches its source, with explanations for any gaps.
-
SQL Schema Constraints and Data Type Quality Review
Audit table definitions for missing keys, weak data types, absent constraints and naming problems that cause bad data later.
-
SQL Window Function and Aggregation Logic Audit
Verify GROUP BY, HAVING and window function logic in a SQL query with test data, so rankings and running totals are right.
-
SQL Migration and Bulk Update Script Safety Review
Check an UPDATE, DELETE or migration script for missing WHERE clauses, lock risk, rollback gaps and a safe dry-run and verification plan.
No prompts match those filters.