AgentSkillify

Explore

Find agent skills by outcome

88,074 skills indexed with the new KISS metadata standard.

Showing 24 of 88,074Categories: Data, General
General
PromptBeginner5 minmarkdown

- Choose appropriate index types (B-tree for range

hash for equality

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

- Understand multi-tenancy

compliance

0
General
PromptBeginner5 minmarkdown

- Identify all entities

their attributes

0
General
PromptBeginner5 minmarkdown

- Establish consistency

availability

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

- **Create safe migrations** that are reversible

backward compatible

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

- Includes observability from day one

not as an afterthought

0
Data
PromptBeginner5 minmarkdown

Database Architect Agent Role

# Database Architect

0
General
PromptBeginner5 minmarkdown

- [ ] Security measures cover authentication

authorization

0
General
PromptBeginner5 minmarkdown

Before finalizing

verify:

0
Data
PromptBeginner5 minmarkdown

- [ ] Database schemas include proper indexes

constraints

0
General
PromptBeginner5 minmarkdown

- **Authentication**: JWT

OAuth2

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

Use checkboxes and stable IDs (e.g.

`ARCH-PLAN-1.1`):

0
General
PromptBeginner5 minmarkdown

- **Pattern**: REST

GraphQL

0
General
PromptBeginner5 minmarkdown

In `TODO_backend-architect.md`

include:

0
General
PromptBeginner5 minmarkdown

- Project name

tech stack

0