Database Schema Designer

This handles the full lifecycle of database design, from initial schema generation to migration scripts. Feed it your data model (users, products, orders) and you get normalized SQL or NoSQL schemas with proper foreign keys, indexes, and constraints. The normalization guides are thorough, walking through 1NF to 3NF with before/after examples. It includes a solid anti-patterns section that catches common mistakes like using FLOAT for money or missing FK indexes. The verification checklist is legitimately useful for code reviews. Best for greenfield projects or major refactors where you want to avoid the usual schema debt, though it assumes you can articulate your access patterns upfront.

Install to Claude Code

npx -y skills add davila7/claude-code-templates --skill database-schema-designer --agent claude-code