Database Design

Covers the full lifecycle of database work from normalization principles through migration patterns and query optimization. The examples are PostgreSQL-heavy but translate well to other relational databases. The migration patterns section is genuinely useful, especially the zero-downtime deployment sequence and the reminder to use CONCURRENTLY for index creation. The EXPLAIN analysis guidance and optimization patterns (EXISTS over IN, keyset pagination) are the kind of things you look up every time until you've done them enough. Light on the NoSQL side despite mentioning it in the description, but the relational database coverage is thorough enough to be a solid reference when you're designing schemas or debugging slow queries.

Install to Claude Code

npx -y skills add moizibnyousaf/ai-agent-skills --skill database-design --agent claude-code