database-design

Choosing between PostgreSQL and serverless databases like Neon or Turso requires evaluating your project requirements, application context, deployment environment, and data access patterns. This Skill guides you through matching database capabilities to your specific workload demands.

Selecting an ORM like Drizzle, Prisma, or Kysely depends on your specific development needs and data access patterns. This Skill provides guidance on evaluating ORM features against your schema design, query optimization, and migration requirements.

Designing efficient database schemas and indexing strategies involves applying principles for normalization, primary keys, timestamps, and relationships. This Skill offers concrete indexing strategies and query optimization techniques to tune performance for your specific data access patterns.

Running zero-downtime database migrations safely requires following established migration best practices to prevent data loss and downtime. This Skill outlines safe migration practices for implementing efficient schema changes without disrupting application availability.

You need to optimize database query performance and restructure schema when your application experiences slow data retrieval or scaling bottlenecks. This Skill addresses query performance tuning and efficient schema structuring based on data access patterns.