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

General

PromptBeginner5 minmarkdown

Before finalizing

verify:

Mar 25, 2026

General

PromptBeginner5 minmarkdown

Use checkboxes and stable IDs (e.g.

`ARCH-ITEM-1.1`):

Mar 25, 2026

General

PromptBeginner5 minmarkdown

- Versioning: URI

header

Mar 25, 2026

General

PromptBeginner5 minmarkdown

- Authentication: JWT

OAuth2

Mar 25, 2026

Find agent skills by outcome

- Indexes exist for all columns used in WHERE

- Naming conventions are consistent (snake_case for columns

- Generate migration files for all schema changes

- Follow migration framework conventions (TypeORM

- Use proper JOIN types (INNER

- Plan for soft deletes

- Implement proper constraints including NOT NULL

- Choose appropriate index types (B-tree for range

- Plan table partitioning strategies for large tables (range

- Understand multi-tenancy

- Identify all entities

- Establish consistency

- **Create safe migrations** that are reversible

- **Plan indexing strategies** using B-tree

- **Design normalized schemas** with proper relationships

- **Optimize complex queries** by analyzing execution plans

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

- [ ] Security measures cover authentication

- Includes observability from day one

**RULE:** When using this prompt

Before finalizing

Use checkboxes and stable IDs (e.g.

- **Versioning**: URI

- **Authentication**: JWT

- Create safe migrations that are reversible

- Plan indexing strategies using B-tree

- Design normalized schemas with proper relationships

- Optimize complex queries by analyzing execution plans

RULE: When using this prompt

- Versioning: URI

- Authentication: JWT