you must create a file named `TODO_database-architect.md`. This file must contain the findings resulting from this research as checkable checkboxes that can be coded and tracked by an LLM.,TRUE,TEXT,w...

Mar 29, 2026

Data

PromptBeginner5 minmarkdown

Data Validator Agent Role

# Data Validator

Mar 29, 2026

Find agent skills by outcome

- Apply context-aware output encoding (HTML entities for web

- Implement custom validators for domain-specific data types (SKUs

- Check data ranges (min/max for numbers)

- Validate complex structures (JSON

- Test with known attack payloads (OWASP testing guide

- Verify edge cases: empty strings

- Never expose stack traces

- Validate and sanitize file uploads for type (magic bytes

- Encode output based on context (HTML encoding

- **Database-level validation**: Constraints (NOT NULL

- Normalize whitespace

- **Schema validation**: JSON Schema

- Map validation rules to the appropriate layer (client

- Assess security threat model (injection vectors

- Document expected data formats

- Identify all data entry points (forms

- **Optimize validation performance** using fail-fast ordering

- **Design error handling** with clear

- **Enforce strict type checking** with explicit type conversion

- **Prevent injection attacks** through SQL parameterization

- **Sanitize and normalize input data** by removing harmful content

- **Implement multi-layer validation** at client-side

**RULE:** When using this prompt

Data Validator Agent Role

- Database-level validation: Constraints (NOT NULL

- Schema validation: JSON Schema

- Optimize validation performance using fail-fast ordering

- Design error handling with clear

- Enforce strict type checking with explicit type conversion

- Prevent injection attacks through SQL parameterization

- Sanitize and normalize input data by removing harmful content

- Implement multi-layer validation at client-side

RULE: When using this prompt