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

Creative

PromptBeginner5 minmarkdown

- Documents complex queries

design decisions

Mar 20, 2026

Coding & Debugging

PromptBeginner5 minmarkdown

Write all proposed database designs and any code snippets to `TODO_database-architect.md` only. Do not create any other files. If specific files should be created or edited

include patch-style diffs or clearly labeled file blocks inside the TODO.

Mar 20, 2026

Creative

PromptBeginner5 minmarkdown

- Design key naming conventions with colons as separators (e.g.

`user:123:profile`)

Mar 20, 2026

Creative

PromptBeginner5 minmarkdown

- Plan table partitioning strategies for large tables (range

list

Mar 20, 2026

Creative

PromptBeginner5 minmarkdown

- Design normalized schemas with proper relationships

constraints

Mar 20, 2026

Coding & Debugging

PromptBeginner5 minmarkdown

You are a senior database engineering expert and specialist in schema design

query optimization

Mar 20, 2026

Coding & Debugging

PromptBeginner5 minmarkdown

RULE: When using this prompt

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

Mar 20, 2026

Coding & Debugging

PromptBeginner5 minmarkdown

Write all proposed architecture designs and any code snippets to `TODO_backend-architect.md` only. Do not create any other files. If specific files should be created or edited

include patch-style diffs or clearly labeled file blocks inside the TODO.

Mar 20, 2026

Coding & Debugging

PromptBeginner5 minmarkdown

### Python (FastAPI

Django

Mar 20, 2026

Find agent skills by outcome

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

- Use Jakarta Bean Validation annotations (@NotNull

### Python (Pydantic

### JavaScript/TypeScript (Zod

- Keep validation schemas in sync with API documentation (OpenAPI

- Track validation bypass attempts (modified client-side code

- Cache results of expensive validation operations (DNS lookups

- Validate cross-field dependencies (end date after start date

- Validate request origins

- Encode output based on context (HTML encoding

- Identify all data entry points (forms

- **Design error handling** with clear

- **Prevent injection attacks** through SQL parameterization

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

**RULE:** When using this prompt

- Documents complex queries

Write all proposed database designs and any code snippets to `TODO_database-architect.md` only. Do not create any other files. If specific files should be created or edited

- Design key naming conventions with colons as separators (e.g.

- Plan table partitioning strategies for large tables (range

- **Design normalized schemas** with proper relationships

You are a senior database engineering expert and specialist in schema design

**RULE:** When using this prompt

Write all proposed architecture designs and any code snippets to `TODO_backend-architect.md` only. Do not create any other files. If specific files should be created or edited

### Python (FastAPI

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

- Design error handling with clear

- Prevent injection attacks through SQL parameterization

- Sanitize and normalize input data by removing harmful content

RULE: When using this prompt

- Design normalized schemas with proper relationships

RULE: When using this prompt