Web Database Validator

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

majiayu000 Updated 567 repo stars

File contents

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

majiayu000/claude-skill-registry-data/tree/main/data/web-database-validator commit aaa59b39a2

Frequently asked questions

npx skillmds@latest add majiayu000/web-database-validator