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

General

PromptBeginner5 minmarkdown

- Proactively identifies missing indexes

inefficient queries

Mar 26, 2026

General

PromptBeginner5 minmarkdown

- [ ] All schemas have proper primary keys

foreign keys

Mar 26, 2026

Find agent skills by outcome

- Check for malicious patterns: excessively nested JSON

- Implement file upload validation with magic byte verification

- Sanitize file names to remove path traversal sequences (../

- Validate complex structures (JSON

- Verify edge cases: empty strings

- Encode output based on context (HTML encoding

- Validate and sanitize file uploads for type (magic bytes

- Normalize whitespace

- Map validation rules to the appropriate layer (client

- **Schema validation**: JSON Schema

- Identify all data entry points (forms

- Assess security threat model (injection vectors

- **Design error handling** with clear

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

- **Prevent injection attacks** through SQL parameterization

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

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

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

- Assign each task a stable ID (e.g.

- Treat every requirement below as an explicit

- Documents complex queries

**RULE:** When using this prompt

- Proactively identifies missing indexes

- [ ] All schemas have proper primary keys

- Schema validation: JSON Schema

- Design error handling with clear

- Optimize validation performance using fail-fast ordering

- Prevent injection attacks through SQL parameterization

- Sanitize and normalize input data by removing harmful content

- Implement multi-layer validation at client-side

- Enforce strict type checking with explicit type conversion

RULE: When using this prompt