-
Database
Add database-level validation and constraints
Adds NOT NULL, CHECK constraints, and correct column types so bad data can't be written no matter what the app does.
Free Prompt
What This Does / How This Helps
Adds constraints to the schema itself so invalid data gets refused at write time, no matter which code path or bug tries to write it. Application validation has holes: a new endpoint forgets to check, an import script skips it, a quick admin query writes by hand. Database constraints are the floor that holds regardless. They also turn data bugs into loud write-time errors instead of quiet corruption you discover three months later in a report. The type audit matters as much as the constraints: money stored as float drifts by pennies, and dates stored as strings can't be compared reliably. You get the violations report on existing data before anything is enforced.
Want to skip doing this by hand?
Fortivibe audits your app for all of the areas these prompts cover (and more).