Skip to content
cccskills
FreePublished on GitHub

web-database-validator

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

The English summary is being prepared. Showing the original description.

See how to install

Files included (4)

  • SKILL.md1.3 KB
  • agents/openai.yaml359 B
  • references/tools.md414 B
  • scripts/database_validator.py6.9 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

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

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Scaffold MCP server projects and baseline tool contract checks. Use for defining tool schemas, generating starter server layouts, and validating MCP-ready structure.

The English summary is being prepared. Showing the original description.

0x-Professor/Agent-Skills-Hub11Updated Feb 27, 2026

Generate reusable multi-step agent workflow blueprints. Use for trigger/action orchestration, deterministic workflow definitions, and automation handoff artifacts.

The English summary is being prepared. Showing the original description.

0x-Professor/Agent-Skills-Hub11Updated Feb 27, 2026

Build incident response timelines and report packs from event logs. Use for detection-to-recovery reporting, phase tracking, and stakeholder-ready incident summaries.

The English summary is being prepared. Showing the original description.

0x-Professor/Agent-Skills-Hub11Updated Feb 27, 2026

Prioritize vulnerability remediation using KEV-style exploitation context plus asset criticality. Use for CVE triage, patch order decisions, and remediation reporting.

The English summary is being prepared. Showing the original description.

0x-Professor/Agent-Skills-Hub11Updated Feb 27, 2026

Map application security findings to OWASP Top 10 categories and generate remediation checklists. Use for normalized AppSec review outputs and category-level prioritization.

The English summary is being prepared. Showing the original description.

0x-Professor/Agent-Skills-Hub11Updated Feb 27, 2026

Build transformer fine-tuning run plans with task settings, hyperparameters, and model-card outputs. Use for repeatable Hugging Face or PyTorch finetuning workflows.

The English summary is being prepared. Showing the original description.

0x-Professor/Agent-Skills-Hub11Updated Feb 27, 2026

See all skills by 0x-Professor

Report a problem with this skill