AgentSkillify

Explore

Find agent skills by outcome

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

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

- Implement proper constraints including NOT NULL

UNIQUE

0
General
PromptBeginner5 minmarkdown

- Use proper JOIN types (INNER

LEFT

0
General
PromptBeginner5 minmarkdown

- Plan for soft deletes

audit trails

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

- Choose appropriate index types (B-tree for range

hash for equality

0
General
PromptBeginner5 minmarkdown

- Understand multi-tenancy

compliance

0
Data
PromptBeginner5 minmarkdown

- Choose between SQL (PostgreSQL

MySQL) and NoSQL (MongoDB

0
General
PromptBeginner5 minmarkdown

- Establish consistency

availability

0
Data
PromptBeginner5 minmarkdown

- **Ensure data integrity** with ACID properties

proper constraints

0
General
PromptBeginner5 minmarkdown

- Identify all entities

their attributes

0
Data
PromptBeginner5 minmarkdown

- **Tune database performance** through configuration optimization

slow query analysis

0
General
PromptBeginner5 minmarkdown

- **Create safe migrations** that are reversible

backward compatible

0
General
PromptBeginner5 minmarkdown

- **Plan indexing strategies** using B-tree

hash

0
General
PromptBeginner5 minmarkdown

- **Optimize complex queries** by analyzing execution plans

identifying bottlenecks

0
Data
PromptBeginner5 minmarkdown

Database Architect Agent Role

# Database Architect

0
Data
PromptBeginner5 minmarkdown

- [ ] Database schemas include proper indexes

constraints

0
General
PromptBeginner5 minmarkdown

- [ ] Security measures cover authentication

authorization

0
General
PromptBeginner5 minmarkdown

- Includes observability from day one

not as an afterthought

0
General
PromptBeginner5 minmarkdown

Before finalizing

verify:

0
General
PromptBeginner5 minmarkdown

Use checkboxes and stable IDs (e.g.

`ARCH-ITEM-1.1`):

0
General
PromptBeginner5 minmarkdown

- **Versioning**: URI

header

0
General
PromptBeginner5 minmarkdown

- **Authentication**: JWT

OAuth2

0