web-database-validator

スター10

フォーク2

更新日2026年2月25日 17:47

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

インストール

Codex または Claude でインストールこの Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。

ソース

0x-Professor

0x-Professor/Agent-Skills-Hub

GitHub リポジトリを開く Creator のリポジトリを見る

ダウンロード

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

このリポジトリの他の Skills

同じリポジトリ

nmap-pentest-scans

0x-Professor/Agent-Skills-Hub

Plan and orchestrate authorized Nmap host discovery, port and service enumeration, NSE profiling, and reporting artifacts for in-scope targets.

2026-02-2610

pentest-active-directory

0x-Professor/Agent-Skills-Hub

Assess Active Directory identity attack paths including roasting, relay, and delegation abuse.

2026-02-2610

pentest-api-attacker

0x-Professor/Agent-Skills-Hub

Test APIs against OWASP API Security Top 10 including discovery, auth abuse, and protocol-specific checks.

2026-02-2610

pentest-auth-bypass

0x-Professor/Agent-Skills-Hub

Test authentication and session management controls for bypass and account takeover scenarios.

2026-02-2610

pentest-c2-operator

0x-Professor/Agent-Skills-Hub

Set up authorized C2 simulation workflows and measure defensive detection outcomes.

2026-02-2610

pentest-cloud-auditor

0x-Professor/Agent-Skills-Hub

Assess AWS, Azure, and GCP controls for IAM escalation and cloud service exposure.

2026-02-2610

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

references/tools.md