Skill UI

Master database schema and data migrations across popular ORMs like Sequelize, TypeORM, and Prisma. Learn rollback strategies, zero-downtime deployments, and schema transformations for safe database version upgrades and refactoring.

Practical async patterns in TypeScript with fp-ts TaskEither for clean pipelines, replacing nested try/catch. Includes real fetch, Prisma, and file API examples.

Operate MySQL-compatible databases on PlanetScale with branching workflows, safe migrations, and production rollouts. Covers CLI installation, database management, deploy requests, connection proxying, Prisma integration, and Vitess features.

Expert in Prisma ORM covering schema design, migrations, query optimization, relations modeling, and database operations for PostgreSQL, MySQL, and SQLite. Provides diagnostics, best practices, and prioritized fixes for common issues.

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.