Skills
.Work. You
Rest

schema-design

Community

Design flawless databases, avoid costly mistakes.

Software Engineering#performance#database design#SQL#data integrity#schema#data modeling#normalization
Authorphrazzld
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Poor database schema design leads to performance bottlenecks, data integrity issues, and expensive refactoring down the line. This Skill provides expert principles to build robust, scalable, and maintainable data models from the start.

Core Features & Use Cases

  • Foundation Principles: Enforces primary keys, foreign keys, precise data types, and constraints to guarantee data integrity.
  • Normalization vs. Denormalization: Guides you to apply the right level of normalization, optimizing for integrity or performance based on evidence.
  • Anti-Pattern Detection: Helps identify and avoid critical design flaws like EAV models, god tables, and multi-valued fields, saving millions in technical debt.
  • Use Case: When designing a new database schema, activate this Skill to automatically review your proposed tables, identify potential anti-patterns, suggest optimal data types, and ensure all integrity constraints are in place.

Quick Start

Apply the schema-design skill to review the attached database schema for a new e-commerce platform. Identify any red flags.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: schema-design
Download link: https://github.com/phrazzld/claude-config/archive/main.zip#schema-design

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.