Database Design

This one pushes you to make intentional database choices instead of defaulting to PostgreSQL for everything. It covers database selection (Neon, Turso, SQLite options), ORM comparisons (Drizzle vs Prisma vs Kysely), schema design fundamentals, and query optimization. The decision checklist is practical: it reminds you to ask about preferences upfront and consider deployment context before diving into schema work. What I like here is the emphasis on reading only relevant files and the blunt anti-patterns list calling out SELECT * and N+1 queries. It's lighter on deep implementation details, but solid for framing decisions when you're starting a project or reconsidering your data layer.

skills.sh installs: 1.7K
GitHub stars: 43.1K
last updated: Jul 14, 2026

View on GitHub

Install

$ npx -y skills add sickn33/antigravity-awesome-skills --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