From antigravity-awesome-skills
Guides schema design, indexing, ORM (Drizzle, Prisma) and database (PostgreSQL, SQLite, Neon) selection with checklists, anti-patterns, and optimization for context-specific apps.
npx claudepluginhub absjaded/antigravity-awesome-skillsThis skill uses the workspace's default tool permissions.
> **Learn to THINK, not copy SQL patterns.**
Verifies tests pass on completed feature branch, presents options to merge locally, create GitHub PR, keep as-is or discard; executes choice and cleans up worktree.
Guides root cause investigation for bugs, test failures, unexpected behavior, performance issues, and build failures before proposing fixes.
Writes implementation plans from specs for multi-step tasks, mapping files and breaking into TDD bite-sized steps before coding.
Learn to THINK, not copy SQL patterns.
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 |
Before designing schema:
โ Default to PostgreSQL for simple apps (SQLite may suffice) โ Skip indexing โ Use SELECT * in production โ Store JSON when structured data is better โ Ignore N+1 queries
This skill is applicable to execute the workflow or actions described in the overview.