database-design

Database selection depends on your deployment context, choosing PostgreSQL for robust relational data and SQLite for lightweight local needs. This Skill guides system comparison, ORM integration, and schema design to ensure efficient, scalable data management tailored to project requirements.

Database indexing strategies improve query optimization by structuring indexes to accelerate data retrieval. This Skill provides principles for selecting primary keys, defining relationships, and applying performance tuning techniques to reduce latency and normalize schemas effectively.

Safe database migrations require careful schema change practices to prevent data loss during relationship updates. This Skill outlines migration best practices, guiding normalization and primary key adjustments while maintaining query optimization and ORM compatibility.

Yes, this ORM selection guidance supports Drizzle and Prisma for schema design and query optimization. It assists in mapping relationships, defining primary keys, and structuring migrations across database systems like Turso and Neon for edge deployments.

Database normalization is needed when structuring primary keys and relationships to eliminate data redundancy and ensure integrity. This Skill provides schema design principles to normalize tables, optimize indexes, and tune performance for scalable architectures.