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 26, 2026

Data

PromptBeginner5 minmarkdown

- Provides specific

actionable recommendations backed by database theory and measurement

Mar 26, 2026

Find agent skills by outcome

- **Trusting Content-Type headers**: Attackers set any Content-Type they want; validate actual content

- Track validation bypass attempts (modified client-side code

### Python (Pydantic

### JavaScript/TypeScript (Zod

- Cache results of expensive validation operations (DNS lookups

- Keep validation schemas in sync with API documentation (OpenAPI

- [ ] Injection attacks (SQL

- Check referential integrity against existing data (unique usernames

- Validate request origins

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

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

- Check data ranges (min/max for numbers)

- Test with known attack payloads (OWASP testing guide

- Never expose stack traces

- Encode output based on context (HTML encoding

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

- Document expected data formats

- Identify all data entry points (forms

- **Prevent injection attacks** through SQL parameterization

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

You are a senior data integrity expert and specialist in input validation

Data Validator Agent Role

**RULE:** When using this prompt

- Provides specific

- Trusting Content-Type headers: Attackers set any Content-Type they want; validate actual content

- Database-level validation: Constraints (NOT NULL

- Prevent injection attacks through SQL parameterization

- Sanitize and normalize input data by removing harmful content

RULE: When using this prompt