db-design

What problem does it solve?

This Skill provides guidance and best practices for designing efficient and maintainable database schemas, helping you avoid common pitfalls and make informed decisions about database and ORM selection.

Core Features & Use Cases

• Database & ORM Selection: Offers decision trees and comparisons for choosing the right database (PostgreSQL, Neon, Turso, SQLite) and ORM (Drizzle, Prisma, Kysely).
• Schema Design: Covers normalization, primary key strategies, timestamp conventions, and relationship types.
• Performance Optimization: Provides insights into indexing strategies and query optimization techniques like identifying and solving N+1 problems.
• Migrations: Outlines safe migration practices for zero-downtime changes.
• Use Case: When starting a new project, use this Skill to decide between PostgreSQL and Turso, select Prisma as your ORM, and design your initial user and product tables following normalization best practices.

Quick Start

Use the db-design skill to help me choose a database for a new web application that needs to scale globally.