database-prisma

What problem does it solve?

Prevents unsafe schema changes, accidental destructive migrations, and inefficient queries by providing a validated, reviewable workflow for Prisma schema updates and migrations against a Supabase/PostgreSQL backend.

Core Features & Use Cases

• Schema validation and safety: Inspect Prisma models for relationship, type, and index consistency before generating migrations.
• Migration generation and review: Produce migration SQL, detect destructive operations, and require explicit confirmation and backups before applying.
• Query optimisation and integrity checks: Identify N+1 patterns, suggest includes/selects and missing indexes, and validate foreign key/cascade behaviour.
• Use Case: When adding a new field to ScheduledPost, generate a migration, review SQL for drops or type changes, run it locally against a Supabase dev instance, and regenerate the Prisma client.

Quick Start

Run a migration-create operation named add-slug to validate the schema, generate the migration SQL for review, and update the Prisma client.