Database Design

This one cuts through the noise of blindly reaching for PostgreSQL every time. It walks you through database selection (PostgreSQL vs Neon vs Turso vs SQLite), ORM tradeoffs (Drizzle vs Prisma vs Kysely), schema design fundamentals, and indexing strategy. The focus is on context-driven decisions rather than cargo-culting patterns. Covers the essentials like avoiding N+1 queries, planning migrations for serverless databases, and knowing when SQLite is actually the right call. The "learn to think, not copy SQL patterns" framing is honest about what matters. Good for when you need to design a schema from scratch or evaluate whether your stack actually fits your deployment model.

skills.sh installs: 531
GitHub stars: 33.2K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add davila7/claude-code-templates --skill database-design --agent claude-code

Installs into .claude/skills of the current project.

Files

Database Design

Learn to THINK, not copy SQL patterns.

🎯 Selective Reading Rule

Read ONLY files relevant to the request! Check the content map, find what you need.

File	Description	When to Read
`database-selection.md`	PostgreSQL vs Neon vs Turso vs SQLite	Choosing database
`orm-selection.md`	Drizzle vs Prisma vs Kysely	Choosing ORM
`schema-design.md`	Normalization, PKs, relationships	Designing schema
`indexing.md`	Index types, composite indexes	Performance tuning
`optimization.md`	N+1, EXPLAIN ANALYZE	Query optimization
`migrations.md`	Safe migrations, serverless DBs	Schema changes