What problem does it solve?
This Skill helps you design reliable, high-performance database schemas and make better database and ORM choices instead of copying SQL patterns that don’t fit your context.
Core Features & Use Cases
- Database selection guidance: Pick the right database engine (e.g., PostgreSQL vs Neon vs Turso vs SQLite) based on deployment, query complexity, vector needs, and distribution requirements.
- Schema design principles: Apply normalization, choose appropriate primary keys and timestamps, and model relationships with correct foreign key behaviors (CASCADE/SET NULL/RESTRICT).
- Performance and safety playbooks: Define indexing strategies, avoid common query pitfalls like N+1, and plan safe migrations for zero-downtime changes (especially on serverless databases).
Use Case Example: You’re building a Next.js app with a growing dataset and uncertain query patterns; use this Skill to select a suitable database/ORM, design tables with proper relationships and timestamps, add the right indexes for WHERE/JOIN/ORDER BY, and plan migrations that won’t break production.
Quick Start
Ask: “Design my database schema for this app using the database-design Skill: target database context is serverless, tables will grow to around 50k rows, and I need pagination and fast search; propose the entities, key strategy, timestamp strategy, relationships, indexes, and a safe migration plan.”
