vudovn avatar

Database Design

This one teaches you to think through database architecture decisions rather than just copy-pasting schema patterns. It covers the full stack: choosing between PostgreSQL, Neon, Turso, or SQLite based on your deployment context, picking the right ORM (Drizzle, Prisma, Kysely), designing normalized schemas, planning indexes, and avoiding N+1 queries. The approach is deliberately opinionated about not defaulting to PostgreSQL for everything and actually asking about requirements first. It's structured as a decision framework with selective reading guides, so you're not wading through irrelevant docs about Prisma when you're using Drizzle. Honestly refreshing to see database guidance that starts with context instead of assuming everyone needs a full Postgres cluster.

skills.sh installs
139
GitHub stars
7.6K
last updated
Jun 3, 2026

Install

$ npx -y skills add vudovn/antigravity-kit --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.

FileDescriptionWhen to Read
database-selection.mdPostgreSQL vs Neon vs Turso vs SQLiteChoosing database
orm-selection.mdDrizzle vs Prisma vs KyselyChoosing ORM
schema-design.mdNormalization, PKs, relationshipsDesigning schema
indexing.mdIndex types, composite indexesPerformance tuning
optimization.mdN+1, EXPLAIN ANALYZEQuery optimization
migrations.mdSafe migrations, serverless DBsSchema changes

⚠️ Core Principle

  • ASK user for database preferences when unclear
  • Choose database/ORM based on CONTEXT
  • Don't default to PostgreSQL for everything

Decision Checklist

Before designing schema:

  • Asked user about database preference?
  • Chosen database for THIS context?
  • Considered deployment environment?
  • Planned index strategy?
  • Defined relationship types?

Anti-Patterns

Sponsors

Details

Repository
github.com/vudovn/antigravity-kit
Categories
Backend & APIs, Design & UI/UX, Databases
First seen
Jun 3, 2026

More from vudovn/antigravity-kit

All 30
1vudovn avatarapi-patternsvudovn/antigravity-kitapi patterns131skills.sh installs
2eddiebe147 avatarsupabase-experteddiebe147/claude-settingssupabase expert128skills.sh installs
3erichowens avatarapi-architecterichowens/some_claude_skillsapi architect127skills.sh installs
4erichowens avatardrizzle-migrationserichowens/some_claude_skillsdrizzle migrations126skills.sh installs
5lubusin avatarfrappe-api-developmentlubusin/agent-skillsfrappe api development126skills.sh installs
6absolutelyskilled avatarapi-monetizationabsolutelyskilled/absolutelyskilledapi monetization123skills.sh installs