kentoshimizu/sw-agent-skills/db-logical-design

Claude Code and agent skill by kentoshimizu/sw-agent-skills

Trust tier 3
  • community
Source check pending

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

Logical database design workflow for table structure, key strategy, constraints, and relational consistency. Use when durable schema semantics must be defined before physical tuning; do not use for query-only optimization tasks.

Install

npx vskill@latest install kentoshimizu/sw-agent-skills/db-logical-design

SKILL.md

DB Logical Design

Overview

Use this skill to define schema semantics that preserve integrity and support maintainable application behavior.

Scope Boundaries

  • New domain models must be translated into relational schema.
  • Existing schema suffers from integrity drift or unclear constraints.
  • Teams need consistent key and relationship semantics.

Core Judgments

  • Primary and alternate key strategy.
  • Nullability and optionality semantics.
  • Referential integrity rules and cascade behavior.
  • Audit and lifecycle columns (created/updated/deleted/effective time).

Practitioner Heuristics

  • Model constraints in the database when they are universal invariants.
  • Use explicit unique constraints to encode business identity rules.
  • Avoid ambiguous nullable fields that represent multiple meanings.
  • For dynamic-language apps, define explicit typed schema mappings to avoid broad object payloads and repetitive casts at repository boundaries.

Workflow

  1. Map conceptual entities to relational structures.
  2. Define keys, uniqueness, and relationship cardinality rules.
  3. Specify integrity constraints and lifecycle semantics.
  4. Validate design against expected write/read workflows.
  5. Identify migration implications and compatibility constraints.
  6. Document deferred trade-offs and boundary assumptions.

Common Failure Modes

  • Business identity handled only in application code.
  • Soft-delete semantics conflict with uniqueness and reporting.
  • Overloaded JSON columns hide core relational structure.

Failure Conditions

  • Stop when key strategy cannot guarantee entity identity.
  • Stop when critical invariants rely on informal conventions.
  • Escalate when logical model conflicts with required consistency semantics.

Security

  • Security scanPassed, 100 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
5
7-day trend score
9

Stars and forks are for the whole GitHub repository, not this skill alone. Refreshed 8 Apr 2026, 7 months ago.

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/kentoshimizu/sw-agent-skills/db-logical-design/badge)](https://verified-skill.com/skills/kentoshimizu/sw-agent-skills/db-logical-design)

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