Database Schema Design

Handles the fundamentals of relational database design with a focus on normalization forms and relationship patterns. You'll use this when you're designing schemas from scratch or refactoring existing ones that have grown messy. It walks through 1NF, 2NF, and 3NF with concrete examples of eliminating repeating groups, partial dependencies, and transitive dependencies. Covers both PostgreSQL and MySQL. The approach is straightforward and example-driven, showing you the wrong way and the right way side by side. Honestly, if you already know your normal forms well, this is basic, but it's solid for getting teams on the same page about schema design principles.

Install to Claude Code

npx -y skills add aj-geddes/useful-ai-prompts --skill database-schema-design --agent claude-code