database-design

What problem does it solve?

This Skill provides guidance and best practices for designing efficient, scalable, and maintainable database schemas and selecting appropriate database technologies and ORMs.

Core Features & Use Cases

• Database Selection: Helps choose between PostgreSQL, Neon, Turso, SQLite, and others based on project needs.
• ORM Selection: Guides the choice between Drizzle, Prisma, Kysely, and raw SQL.
• Schema Design: Covers normalization, primary keys, timestamps, and relationship types.
• Indexing Strategy: Provides principles for effective index creation.
• Query Optimization: Addresses the N+1 problem and query analysis.
• Migrations: Outlines safe migration strategies for zero-downtime changes.
• Use Case: When starting a new web application, use this Skill to decide whether to use PostgreSQL with Prisma or Turso with Drizzle, and then design the initial user and product schemas.

Quick Start

Use the database-design skill to help select an ORM for a new project.