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 environment and query complexity. - Schema Design & Indexing Guidance: Principles for normalization, primary key selection, timestamp strategy, foreign key behavior, and composite index ordering. - Schema Validation Script: A Python script that scans Prisma schemas for missing IDs, timestamps, naming violations, and missing indexes on foreign keys. - 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 before committing. ## Quick Start Ask the agent to help design a database schema for your project and validate the existing Prisma schema for common issues.
