# Web Database Validator

> Validate database schema, migrations, indexes, and query behavior with structured pass/fail reporting.

- Skill: `majiayu000/web-database-validator` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add majiayu000/web-database-validator`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/web-database-validator/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- License: Apache-2.0
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/web-database-validator

---


# 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

```bash
python skills/web-database-validator/scripts/database_validator.py --input <workspace> --output <out.json> --format json
```

## References

- `references/tools.md`