Prisma

Workflow

1. Confirm database engine, Prisma version, and deployment constraints.
2. Model schema with explicit relations, constraints, and naming conventions.
3. Plan migration lifecycle (dev, staging, production) before schema changes.
4. Implement query patterns with performance and transaction discipline.
5. Apply integrity and security controls at app and DB boundaries.
6. Add tests for schema evolution and query correctness.
7. Instrument operational visibility for slow queries and failures.
8. Upgrade Prisma in controlled increments with regression checks.

Preflight (Ask / Check First)

• Target database (PostgreSQL/MySQL/SQL Server/SQLite/Cockroach) and engine mode.
• Existing migration history quality and rollback expectations.
• Multi-tenant or sharding constraints.
• Data consistency requirements for writes and transaction scope.
• Security requirements for PII, secrets, and query logging.
• Release strategy for migration deployment windows.