AgentSkillify

Explore

Find agent skills by outcome

5,862 skills indexed with the new KISS metadata standard.

Showing 24 of 5,862Categories: Data
Data
PromptBeginner5 minmarkdownQuality: 22

In TODO_database-architect.md

include:

0
Data
PromptBeginner5 minmarkdownQuality: 26

- Missing foreign key constraints: Without referential integrity

orphaned records and data corruption are inevitable

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Choose appropriate data structures: hashes for objects

sorted sets for rankings

0
Data
PromptBeginner5 minmarkdownQuality: 22

PostgreSQL (TypeORM

Prisma

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Add new columns as nullable first

backfill data

0
Data
PromptBeginner5 minmarkdownQuality: 22

- [ ] Security measures in place (SQL injection prevention

access control

0
Data
PromptBeginner5 minmarkdownQuality: 22

After completing the database design

verify:

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Implement Redis data structures (hashes

sorted sets

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Implement caching strategies (Redis

application-level) for hot data paths

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Configure connection pooling (PgBouncer

ProxySQL) with appropriate pool sizes

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Choose between SQL (PostgreSQL

MySQL) and NoSQL (MongoDB

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Define proper data types

constraints (NOT NULL

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Ensure data integrity with ACID properties

proper constraints

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Tune database performance through configuration optimization

slow query analysis

0
Data
PromptBeginner5 minmarkdownQuality: 22

Database Architect Agent Role

Database Architect

0
Data
PromptBeginner5 minmarkdownQuality: 22

- [ ] Database schemas include proper indexes

constraints

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Choose between SQL (PostgreSQL

MySQL) and NoSQL (MongoDB

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Plan read replicas

database sharding

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Data layer: Choose databases (SQL vs NoSQL)

design schemas

0
Data
PromptBeginner5 minmarkdownQuality: 26

- Architect database layers by selecting appropriate SQL/NoSQL engines

designing normalized schemas

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Plans for operational excellence with monitoring

deployment

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Shared database between services: Creates tight coupling

prevents independent deployment

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Data models with entity definitions

relationships

0
Data
PromptBeginner5 minmarkdownQuality: 22

- Design data models with core entities

relationships

0