Skill · em Construir backend e dados

database-design

Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Procedência

Antes de instalar

8 arquivos · 12,9 KB · inclui 1 script que executa: scripts/schema_validator.py

Instalar na sua CLI

O comando baixa a versão fixada (commit 57f899e) direto da origem, para a pasta que a CLI lê. Precisa de curl (macOS e Linux); no Windows não há comando, porque o Rook Labs é para macOS.

Claude Code

Neste projeto: instala em .claude/skills/database-design/.

d=".claude/skills/database-design"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/development/database-design"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/database-selection.md" "$u/database-selection.md" \
  -o "$d/indexing.md" "$u/indexing.md" \
  -o "$d/migrations.md" "$u/migrations.md" \
  -o "$d/optimization.md" "$u/optimization.md" \
  -o "$d/orm-selection.md" "$u/orm-selection.md" \
  -o "$d/schema-design.md" "$u/schema-design.md" \
  -o "$d/scripts/schema_validator.py" "$u/scripts/schema_validator.py" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Global: instala em ~/.claude/skills/database-design/.

d="$HOME/.claude/skills/database-design"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/development/database-design"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/database-selection.md" "$u/database-selection.md" \
  -o "$d/indexing.md" "$u/indexing.md" \
  -o "$d/migrations.md" "$u/migrations.md" \
  -o "$d/optimization.md" "$u/optimization.md" \
  -o "$d/orm-selection.md" "$u/orm-selection.md" \
  -o "$d/schema-design.md" "$u/schema-design.md" \
  -o "$d/scripts/schema_validator.py" "$u/scripts/schema_validator.py" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Codex

Neste projeto: instala em .agents/skills/database-design/.

d=".agents/skills/database-design"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/development/database-design"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/database-selection.md" "$u/database-selection.md" \
  -o "$d/indexing.md" "$u/indexing.md" \
  -o "$d/migrations.md" "$u/migrations.md" \
  -o "$d/optimization.md" "$u/optimization.md" \
  -o "$d/orm-selection.md" "$u/orm-selection.md" \
  -o "$d/schema-design.md" "$u/schema-design.md" \
  -o "$d/scripts/schema_validator.py" "$u/scripts/schema_validator.py" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Global: instala em ~/.agents/skills/database-design/.

d="$HOME/.agents/skills/database-design"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/development/database-design"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/database-selection.md" "$u/database-selection.md" \
  -o "$d/indexing.md" "$u/indexing.md" \
  -o "$d/migrations.md" "$u/migrations.md" \
  -o "$d/optimization.md" "$u/optimization.md" \
  -o "$d/orm-selection.md" "$u/orm-selection.md" \
  -o "$d/schema-design.md" "$u/schema-design.md" \
  -o "$d/scripts/schema_validator.py" "$u/scripts/schema_validator.py" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Antigravity

Neste projeto: instala em .agents/skills/database-design/.

d=".agents/skills/database-design"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/development/database-design"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/database-selection.md" "$u/database-selection.md" \
  -o "$d/indexing.md" "$u/indexing.md" \
  -o "$d/migrations.md" "$u/migrations.md" \
  -o "$d/optimization.md" "$u/optimization.md" \
  -o "$d/orm-selection.md" "$u/orm-selection.md" \
  -o "$d/schema-design.md" "$u/schema-design.md" \
  -o "$d/scripts/schema_validator.py" "$u/scripts/schema_validator.py" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Global: instala em ~/.gemini/antigravity-cli/skills/database-design/.

d="$HOME/.gemini/antigravity-cli/skills/database-design"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/development/database-design"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/database-selection.md" "$u/database-selection.md" \
  -o "$d/indexing.md" "$u/indexing.md" \
  -o "$d/migrations.md" "$u/migrations.md" \
  -o "$d/optimization.md" "$u/optimization.md" \
  -o "$d/orm-selection.md" "$u/orm-selection.md" \
  -o "$d/schema-design.md" "$u/schema-design.md" \
  -o "$d/scripts/schema_validator.py" "$u/scripts/schema_validator.py" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Peça ao Rook

Já usa o Rook Labs? Cole no chat do Rook: instale a skill https://rooklabs.sh/marketplace/cct.database-design

Prévia do SKILL.md

---
name: database-design
description: Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
allowed-tools: Read, Write, Edit, Glob, Grep
---

# Database Design

> **Learn to THINK, not copy SQL patterns.**

## 🎯 Selective Reading Rule

**Read ONLY files relevant to the request!** Check the content map, find what you need.

| File | Description | When to Read |
|------|-------------|--------------|
| `database-selection.md` | PostgreSQL vs Neon vs Turso vs SQLite | Choosing database |
| `orm-selection.md` | Drizzle vs Prisma vs Kysely | Choosing ORM |
| `schema-design.md` | Normalization, PKs, relationships | Designing schema |
| `indexing.md` | Index types, composite indexes | Performance tuning |
| `optimization.md` | N+1, EXPLAIN ANALYZE | Query optimization |
| `migrations.md` | Safe migrations, serverless DBs | Schema changes |

---

## ⚠️ Core Principle

- ASK user for database preferences when unclear
- Choose database/ORM based on CONTEXT
- Don't default to PostgreSQL for everything

---

## Decision Checklist

Before designing schema:

- [ ] Asked user about database preference?
- [ ] Chosen database for THIS context?
- [ ] Considered deployment environment?
…

Ver todo o marketplace