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 mit-network/antigravity-awesome-skillsThis skill uses the workspace's default tool permissions.
> **Learn to THINK, not copy SQL patterns.**
Designs database schemas with normalization and relationships, selects databases (PostgreSQL, Neon, Turso, SQLite) and ORMs (Drizzle, Prisma, Kysely), plans indexing and migrations.
Designs schemas, indexes, query optimizations, and migrations for SQL/NoSQL databases. For table design, N+1 fixes, normalization, ORMs, performance tuning.
Provides best practices for database schema design, query optimization, migrations, indexing, N+1 avoidance, pagination, and transactions across PostgreSQL, MySQL, Oracle, SQLite. Use for schema design, queries, or migrations.
Share bugs, ideas, or general feedback.
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.