Web Database Validator

Objective

Validate schema and query quality after backend scaffolding, including migration sanity checks and performance guardrails.

Required Workflow

1. Read project-config.json and ORM schema files.
2. Run migrations in a local test database (Docker or in-memory SQLite for dry runs).
3. 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)
4. Seed realistic test data using Faker.js or Python Faker.
5. Run query checks for row counts, relationships, and cascades.
6. Output db-validation-report.json with 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