Explore

Find agent skills by outcome

6,088 skills indexed with the new KISS metadata standard.

Showing 24 of 6,088Categories: Data & Insights, Data, Research & Learning, Cursor-rules
Data
PromptBeginner5 minmarkdown

### PostgreSQL (TypeORM

Prisma

0
Data
PromptBeginner5 minmarkdown

- Add new columns as nullable first

backfill data

0
Data
PromptBeginner5 minmarkdown

After completing the database design

verify:

0
Data
PromptBeginner5 minmarkdown

- [ ] Security measures in place (SQL injection prevention

access control

0
Data
PromptBeginner5 minmarkdown

- Implement Redis data structures (hashes

sorted sets

0
Data
PromptBeginner5 minmarkdown

- Implement caching strategies (Redis

application-level) for hot data paths

0
Data
PromptBeginner5 minmarkdown

- Configure connection pooling (PgBouncer

ProxySQL) with appropriate pool sizes

0
Data
PromptBeginner5 minmarkdown

- Define proper data types

constraints (NOT NULL

0
Data
PromptBeginner5 minmarkdown

- Choose between SQL (PostgreSQL

MySQL) and NoSQL (MongoDB

0
Data
PromptBeginner5 minmarkdown

- **Ensure data integrity** with ACID properties

proper constraints

0
Data
PromptBeginner5 minmarkdown

- **Tune database performance** through configuration optimization

slow query analysis

0
Data
PromptBeginner5 minmarkdown

Database Architect Agent Role

# Database Architect

0
Data
PromptBeginner5 minmarkdown

- [ ] Database schemas include proper indexes

constraints

0
Data
PromptBeginner5 minmarkdown

- Choose between SQL (PostgreSQL

MySQL) and NoSQL (MongoDB

0
Data
PromptBeginner5 minmarkdown

- Plan read replicas

database sharding

0
Data
PromptBeginner5 minmarkdown

- **Data layer**: Choose databases (SQL vs NoSQL)

design schemas

0
Data
PromptBeginner5 minmarkdown

- **Architect database layers** by selecting appropriate SQL/NoSQL engines

designing normalized schemas

0
Data
PromptBeginner5 minmarkdown

- Plans for operational excellence with monitoring

deployment

0
Data
PromptBeginner5 minmarkdown

- **Shared database between services**: Creates tight coupling

prevents independent deployment

0
Data
PromptBeginner5 minmarkdown

- Data models with entity definitions

relationships

0
Data
PromptBeginner5 minmarkdown

- Design data models with core entities

relationships

0
Data
PromptBeginner5 minmarkdown

- **Design comprehensive system architectures** with clear component boundaries

data flow paths

0
Data
PromptBeginner5 minmarkdown

* Positioning: Fairly cites Entropy/MDPI priors? Compares apples-to-apples (e.g.

same datasets

0
Research & Learning
PromptBeginner5 minmarkdown

- If multiple posts are in one file (separated by quotes or dividers): extract each independently

then provide a synthesis layer at the end showing patterns across all posts

0