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

General

PromptBeginner5 minmarkdown

- [ ] Security measures cover authentication

authorization

Mar 21, 2026

General

PromptBeginner5 minmarkdown

Before finalizing

verify:

Mar 21, 2026

General

PromptBeginner5 minmarkdown

- Authentication: JWT

OAuth2

Mar 21, 2026

General

PromptBeginner5 minmarkdown

Use checkboxes and stable IDs (e.g.

`ARCH-ITEM-1.1`):

Mar 21, 2026

Find agent skills by outcome

- Use online schema change tools (gh-ost

- Set up alerts for long-running queries

- Monitoring in place for table bloat

- 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

- Implement proper constraints including NOT NULL

- Plan for soft deletes

- Choose appropriate index types (B-tree for range

- Understand multi-tenancy

- Identify all entities

- Establish consistency

- **Create safe migrations** that are reversible

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

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

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

- Includes observability from day one

**RULE:** When using this prompt

- [ ] Security measures cover authentication

Before finalizing

- **Authentication**: JWT

Use checkboxes and stable IDs (e.g.

- Create safe migrations that are reversible

- Optimize complex queries by analyzing execution plans

- Plan indexing strategies using B-tree

RULE: When using this prompt

- Authentication: JWT