Database Schema Design

Handles PostgreSQL and MySQL schema design with built-in templates for common patterns like one-to-many relationships, many-to-many junction tables, and soft deletes. The real value is in the error prevention: it catches missing primary keys, unindexed foreign keys, VARCHAR(MAX) abuse, and the EAV anti-pattern before they become production problems. Includes normalization rules up to 3NF with concrete examples, plus audit column patterns and constraint templates. If you're designing a new database or reviewing an existing schema that feels off, this gives you the checklist and SQL patterns to fix it properly. The critical errors section alone is worth having on hand during code review.

Install to Claude Code

npx -y skills add secondsky/claude-skills --skill database-schema-design --agent claude-code