What problem does it solve? Choosing the wrong database, ORM, or schema structure early in a project leads to performance bottlenecks, painful migrations, and costly rewrites. This Skill provides decision frameworks and validation tooling to make informed database architecture choices based on actual project context. ## Core Features & Use Cases - Database & ORM Selection: Decision trees comparing PostgreSQL, Neon, Turso, SQLite, PlanetScale, and ORMs like Drizzle, Prisma, and Kysely based on deployment context. - Schema Design Guidance: Principles for normalization, primary key selection, timestamps, relationships, and foreign key delete behaviors. - Performance Optimization: Indexing strategies, N+1 query detection, EXPLAIN ANALYZE workflows, and safe zero-downtime migration patterns. - Schema Validation Script: A Python script that scans Prisma schemas for missing IDs, timestamps, naming issues, and missing indexes. - Use Case: When starting a new serverless app, use this Skill to decide between Neon and Turso, pick Drizzle as the ORM, design a normalized schema with proper indexes, and validate the Prisma schema for common mistakes. ## Quick Start Ask the agent to help you choose a database and design a schema for your project, describing your deployment environment and query requirements.
