agentsclimarketplace
Sign in

Web database validator

Skill 0x-Professor/Agent-Skills-Hub/skills/web-database-validator

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

Install
npx -y skills add 0x-Professor/Agent-Skills-Hub --skill web-database-validator

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 10 stars10 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its file declares

Copied from the file, not written here

The file declares its own license as Apache-2.0. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.

SKILL.md

1.3 KB, 207 tokens by cl100k_base, as published. Nobody here has run it

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

What ships with it: 3 files

7.7 KB alongside SKILL.md, 1 of them executable

agents/

references/

scripts/

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.