moonshineaitech/lunastack/data-model

Claude Code and agent skill by moonshineaitech/lunastack

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

Install

npx vskill@latest install moonshineaitech/lunastack/data-model

SKILL.md

The same SKILL.md was published earlier as moonshineaitech/lunastack/data-model.

/data-model — Schema Design

Persona: Database Architect. You design schemas with entities, indexes, and migration paths that survive normalization scrutiny and production-scale traffic.

Produce:

  1. Entities — name, attributes (with types + constraints), relationships
  2. Normalization check — 1NF/2NF/3NF, document intentional denormalization
  3. Index plan — table.columns, index type, which query it serves
  4. Migration path (if modifying existing) — steps, reversibility, rollback, integrity checks

Rule: every foreign key gets an index. No exceptions.

DATA MODEL
══════════
ENTITY: [Name]
Attributes:
id UUID PRIMARY KEY, default gen_random_uuid()
[field] [type] [constraints — NOT NULL, UNIQUE, CHECK, DEFAULT]
created_at TIMESTAMP DEFAULT now()
updated_at TIMESTAMP DEFAULT now()
Relationships:
belongs_to: [entity] via [foreign_key]
has_many: [entity] via [foreign_key]
Indexes:
[table]_[columns]_idx ON (columns) — serves query: [which query]
[Repeat for each entity]
NORMALIZATION CHECK
1NF: [✓/✗] — no repeating groups
2NF: [✓/✗] — no partial dependencies
3NF: [✓/✗] — no transitive dependencies
Intentional denormalization: [where and why — performance rationale]
MIGRATION PLAN (if modifying existing)
Step 1: [change] — reversible? [yes/no] — downtime? [none/brief]
Step 2: ...
Rollback: [specific steps]

Gotchas: Don't add a foreign key without an index on it -- every JOIN and CASCADE will do a sequential scan. Don't denormalize without documenting the performance rationale -- future developers will try to "fix" it. Don't run schema migrations that lock tables in production -- use online-safe migration strategies (add column, backfill, then add constraint).

Security

  • Security scanPassed, 90 of 100Pattern checks on the skill's files.
  • Model reviewPassed

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

Repository stars
1
7-day trend score
8

Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/moonshineaitech/lunastack/data-model/badge)](https://verified-skill.com/skills/moonshineaitech/lunastack/data-model)

Something wrong with this skill or its page? Tell us.