AgentSkillify

Explore

Find agent skills by outcome

16,415 skills indexed with the new KISS metadata standard.

Showing 24 of 16,415Categories: Education, Data, Communication, Coding & Debugging, Creative
Coding & Debugging
PromptBeginner5 minmarkdown

Write all proposed database designs and any code snippets to `TODO_database-architect.md` only. Do not create any other files. If specific files should be created or edited

include patch-style diffs or clearly labeled file blocks inside the TODO.

0
Data
PromptBeginner5 minmarkdown

- **Missing foreign key constraints**: Without referential integrity

orphaned records and data corruption are inevitable

0
Creative
PromptBeginner5 minmarkdown

- Design key naming conventions with colons as separators (e.g.

`user:123:profile`)

0
Data
PromptBeginner5 minmarkdown

- Choose appropriate data structures: hashes for objects

sorted sets for rankings

0
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
Creative
PromptBeginner5 minmarkdown

- Plan table partitioning strategies for large tables (range

list

0
Data
PromptBeginner5 minmarkdown

- **Tune database performance** through configuration optimization

slow query analysis

0
Data
PromptBeginner5 minmarkdown

- **Ensure data integrity** with ACID properties

proper constraints

0
Creative
PromptBeginner5 minmarkdown

- **Design normalized schemas** with proper relationships

constraints

0
Coding & Debugging
PromptBeginner5 minmarkdown

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

query optimization

0
Coding & Debugging
PromptBeginner5 minmarkdown

**RULE:** When using this prompt

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...

0
Data
PromptBeginner5 minmarkdown

Database Architect Agent Role

# Database Architect

0
Data
PromptBeginner5 minmarkdown

- [ ] Database schemas include proper indexes

constraints

0
Coding & Debugging
PromptBeginner5 minmarkdown

Write all proposed architecture designs and any code snippets to `TODO_backend-architect.md` only. Do not create any other files. If specific files should be created or edited

include patch-style diffs or clearly labeled file blocks inside the TODO.

0
Coding & Debugging
PromptBeginner5 minmarkdown

### Python (FastAPI

Django

0
Coding & Debugging
PromptBeginner5 minmarkdown

- Return appropriate HTTP status codes (201 for creation

204 for deletion)

0