Skill UI

A comprehensive guide covering best practices for database migrations. It addresses schema changes, data migrations, and rollbacks for major databases (PostgreSQL, MySQL) and modern ORMs (Prisma, Drizzle, etc.). Learn how to implement safe, reversible, and zero-downtime schema updates for production environments.

Generates a production-ready SaaS boilerplate with authentication, database schema, billing integration, API routes, and a dashboard built with Next.js 14 App Router, TypeScript, Tailwind, shadcn/ui, Drizzle ORM, and Stripe—ideal for bootstrapping new subscription-based products.

This expert assists developers in building type-safe, high-performance database layers using Drizzle ORM with TypeScript. It provides deep knowledge of schema design, complex relational querying (joins, aggregations), managing migrations via Drizzle Kit, and seamless integration with modern stacks like Next.js, tRPC, and serverless environments. Ideal for developers needing a zero-overhead, type-safe ORM alternative.

This guide provides comprehensive patterns for designing and implementing secure multi-tenant SaaS applications using shared databases. It covers critical techniques like Row-Level Security (RLS) in PostgreSQL, implementing tenant-aware middleware in TypeScript (Express/Fastify), and enforcing data scoping at the ORM level (Prisma/Drizzle). Learn how to prevent data leakage and manage tenant isolation across shared schemas.

A comprehensive guide to safe and reversible database migration patterns. Covers zero-downtime schema changes, data backfilling, and rollbacks for major databases like PostgreSQL and MySQL, and popular ORMs (Prisma, Drizzle, Django). Learn techniques like concurrent indexing and the expand-contract pattern to ensure production stability.