AgentSkillify

Explore

Find agent skills by outcome

96,902 skills indexed with the new KISS metadata standard.

Showing 24 of 96,902Categories: Data & Insights, General
General
PromptBeginner5 minmarkdown

- Proactively identifies missing indexes

inefficient queries

0
General
PromptBeginner5 minmarkdown

- [ ] All schemas have proper primary keys

foreign keys

0
General
PromptBeginner5 minmarkdown

Before finalizing

verify:

0
General
PromptBeginner5 minmarkdown

- **Type**: Schema change

index

0
General
PromptBeginner5 minmarkdown

Use checkboxes and stable IDs (e.g.

`DB-ITEM-1.1`):

0
General
PromptBeginner5 minmarkdown

Use checkboxes and stable IDs (e.g.

`DB-PLAN-1.1`):

0
General
PromptBeginner5 minmarkdown

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

bandwidth

0
General
PromptBeginner5 minmarkdown

- Configure persistence (RDB snapshots

AOF) based on durability requirements

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
General
PromptBeginner5 minmarkdown

- Use online schema change tools (gh-ost

pt-online-schema-change) for large tables

0
General
PromptBeginner5 minmarkdown

- Monitoring in place for table bloat

dead tuples

0
General
PromptBeginner5 minmarkdown

- Indexes exist for all columns used in WHERE

JOIN

0
General
PromptBeginner5 minmarkdown

- Naming conventions are consistent (snake_case for columns

plural for tables)

0
General
PromptBeginner5 minmarkdown

- Generate migration files for all schema changes

never alter production manually

0
General
PromptBeginner5 minmarkdown

- Follow migration framework conventions (TypeORM

Prisma

0
General
PromptBeginner5 minmarkdown

- Plan for soft deletes

audit trails

0
General
PromptBeginner5 minmarkdown

- Use proper JOIN types (INNER

LEFT

0
General
PromptBeginner5 minmarkdown

- Implement proper constraints including NOT NULL

UNIQUE

0
General
PromptBeginner5 minmarkdown

- Choose appropriate index types (B-tree for range

hash for equality

0
General
PromptBeginner5 minmarkdown

- Understand multi-tenancy

compliance

0
General
PromptBeginner5 minmarkdown

- Identify all entities

their attributes

0
General
PromptBeginner5 minmarkdown

- Establish consistency

availability

0