Web Database Validator
Objective
Validate schema and query quality after backend scaffolding, including migration sanity checks and performance guardrails.
Required Workflow
- Read
project-config.jsonand ORM schema files. - Run migrations in a local test database (Docker or in-memory SQLite for dry runs).
- Validate:
- foreign key constraints
- indexes on foreign keys and hot query columns
- N+1 query risk with query logs or explain plans
- soft-delete fields where required
- auto timestamps (
created_at,updated_at)
- Seed realistic test data using Faker.js or Python Faker.
- Run query checks for row counts, relationships, and cascades.
- Output
db-validation-report.jsonwith pass/fail per check.
Execution
python skills/web-database-validator/scripts/database_validator.py --input <workspace> --output <out.json> --format json
References
references/tools.md