AgentSkillify

Explore

Find agent skills by outcome

118,453 skills indexed with the new KISS metadata standard.

Showing 24 of 118,453Categories: Data & Insights, General, Data, Cursor-rules, Creative
General
PromptBeginner5 minmarkdown

- Implement proper constraints including NOT NULL

UNIQUE

0
Data
PromptBeginner5 minmarkdown

- Configure connection pooling (PgBouncer

ProxySQL) with appropriate pool sizes

0
Data
PromptBeginner5 minmarkdown

- Implement caching strategies (Redis

application-level) for hot data paths

0
Data
PromptBeginner5 minmarkdown

- Define proper data types

constraints (NOT NULL

0
Creative
PromptBeginner5 minmarkdown

- Plan table partitioning strategies for large tables (range

list

0
General
PromptBeginner5 minmarkdown

- Choose appropriate index types (B-tree for range

hash for equality

0
Data
PromptBeginner5 minmarkdown

- Choose between SQL (PostgreSQL

MySQL) and NoSQL (MongoDB

0
General
PromptBeginner5 minmarkdown

- Understand multi-tenancy

compliance

0
General
PromptBeginner5 minmarkdown

- Establish consistency

availability

0
Data
PromptBeginner5 minmarkdown

- **Ensure data integrity** with ACID properties

proper constraints

0
Data
PromptBeginner5 minmarkdown

- **Tune database performance** through configuration optimization

slow query analysis

0
General
PromptBeginner5 minmarkdown

- Identify all entities

their attributes

0
General
PromptBeginner5 minmarkdown

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

identifying bottlenecks

0
General
PromptBeginner5 minmarkdown

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

hash

0
General
PromptBeginner5 minmarkdown

- **Create safe migrations** that are reversible

backward compatible

0
Creative
PromptBeginner5 minmarkdown

- **Design normalized schemas** with proper relationships

constraints

0
Data
PromptBeginner5 minmarkdown

Database Architect Agent Role

# Database Architect

0
General
PromptBeginner5 minmarkdown

- Includes observability from day one

not as an afterthought

0
General
PromptBeginner5 minmarkdown

- [ ] Security measures cover authentication

authorization

0
Data
PromptBeginner5 minmarkdown

- [ ] Database schemas include proper indexes

constraints

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

- **Pattern**: REST

GraphQL

0