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

Data

PromptBeginner5 minmarkdown

- [ ] Database schemas include proper indexes

constraints

Mar 29, 2026

General

PromptBeginner5 minmarkdown

- [ ] Security measures cover authentication

authorization

Mar 29, 2026

General

PromptBeginner5 minmarkdown

- Includes observability from day one

not as an afterthought

Mar 29, 2026

Find agent skills by outcome

- Implement proper constraints including NOT NULL

- Use proper JOIN types (INNER

- Plan for soft deletes

- Implement caching strategies (Redis

- Configure connection pooling (PgBouncer

- Define proper data types

- Plan table partitioning strategies for large tables (range

- Choose appropriate index types (B-tree for range

- Understand multi-tenancy

- Choose between SQL (PostgreSQL

- Establish consistency

- **Ensure data integrity** with ACID properties

- Identify all entities

- **Tune database performance** through configuration optimization

- **Create safe migrations** that are reversible

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

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

- **Design normalized schemas** with proper relationships

Database Architect Agent Role

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

**RULE:** When using this prompt

- [ ] Database schemas include proper indexes

- [ ] Security measures cover authentication

- Includes observability from day one

- Ensure data integrity with ACID properties

- Tune database performance through configuration optimization

- Create safe migrations that are reversible

- Plan indexing strategies using B-tree

- Optimize complex queries by analyzing execution plans

- Design normalized schemas with proper relationships

RULE: When using this prompt