AgentSkillify

Explore

Find agent skills by outcome

86,618 skills indexed with the new KISS metadata standard.

Showing 24 of 86,618Categories: Data, Communication, General, 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
Data
PromptBeginner5 minmarkdown

- Provides specific

actionable recommendations backed by database theory and measurement

0
Creative
PromptBeginner5 minmarkdown

- Documents complex queries

design decisions

0
General
PromptBeginner5 minmarkdown

- Proactively identifies missing indexes

inefficient queries

0
General
PromptBeginner5 minmarkdown

Before finalizing

verify:

0
General
PromptBeginner5 minmarkdown

- [ ] All schemas have proper primary keys

foreign keys

0
General
PromptBeginner5 minmarkdown

- **Type**: Schema change

index

0
General
PromptBeginner5 minmarkdown

Use checkboxes and stable IDs (e.g.

`DB-PLAN-1.1`):

0
General
PromptBeginner5 minmarkdown

Use checkboxes and stable IDs (e.g.

`DB-ITEM-1.1`):

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

In `TODO_database-architect.md`

include:

0
Data
PromptBeginner5 minmarkdown

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

orphaned records and data corruption are inevitable

0
General
PromptBeginner5 minmarkdown

- **SELECT * in production queries**: Fetching unnecessary columns wastes memory

bandwidth

0
Creative
PromptBeginner5 minmarkdown

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

`user:123:profile`)

0
General
PromptBeginner5 minmarkdown

- Configure persistence (RDB snapshots

AOF) based on durability requirements

0
Data
PromptBeginner5 minmarkdown

- Choose appropriate data structures: hashes for objects

sorted sets for rankings

0
General
PromptBeginner5 minmarkdown

### Redis (ioredis

redis-py)

0
General
PromptBeginner5 minmarkdown

### MongoDB (Mongoose

Motor)

0
General
PromptBeginner5 minmarkdown

- Set up alerts for long-running queries

lock waits

0
Data
PromptBeginner5 minmarkdown

- Add new columns as nullable first

backfill data

0
Data
PromptBeginner5 minmarkdown

### PostgreSQL (TypeORM

Prisma

0
General
PromptBeginner5 minmarkdown

- Use online schema change tools (gh-ost

pt-online-schema-change) for large tables

0
Data
PromptBeginner5 minmarkdown

After completing the database design

verify:

0