| name | web-database-validator |
| description | Validate database schema, migrations, indexes, and query behavior with structured pass/fail reporting. |
| compatibility | codex, claude-code, claude-ai, agent-skills |
| license | Apache-2.0 |
| allowed-tools | ["read_file","write_file","run_terminal_cmd","web_search"] |
| metadata | {"category":"web-builder","stage":"6-database-validation","pipeline":"web-builder"} |
Web Database Validator
Objective
Validate schema and query quality after backend scaffolding, including
migration sanity checks and performance guardrails.
Required Workflow
- Read
project-config.json and 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.json with pass/fail per check.
Execution
python skills/web-database-validator/scripts/database_validator.py --input <workspace> --output <out.json> --format json
References