AgentSkillify

Explore

Find agent skills by outcome

15,697 skills indexed with the new KISS metadata standard.

Showing 24 of 15,697Categories: Data, Cursor-rules, Business, Coding & Debugging, Creative
Coding & Debugging
PromptBeginner5 minmarkdown

**RULE:** When using this prompt

you must create a file named `TODO_database-architect.md`. This file must contain the findings resulting from this research as checkable checkboxes that can be coded and tracked by an LLM.,TRUE,TEXT,w...

0
Data
PromptBeginner5 minmarkdown

Data Validator Agent Role

# Data Validator

0
Creative
PromptBeginner5 minmarkdown

- Documents complex queries

design decisions

0
Data
PromptBeginner5 minmarkdown

- Provides specific

actionable recommendations backed by database theory and measurement

0
Data
PromptBeginner5 minmarkdown

In `TODO_database-architect.md`

include:

0
Business
PromptBeginner5 minmarkdown

- **Migration Strategy**: Online DDL

batched DML

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

- Tune buffer management

work memory

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