Agent-Skills-Hub web-database-validator

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

install

source · Clone the upstream repo

git clone https://github.com/0x-Professor/Agent-Skills-Hub

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/0x-Professor/Agent-Skills-Hub "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/web-database-validator" ~/.claude/skills/0x-professor-agent-skills-hub-web-database-validator && rm -rf "$T"

manifest: skills/web-database-validator/SKILL.md

source content

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

```
references/tools.md
```