What problem does it solve?
This Skill simplifies database schema management, migrations, and querying for PostgreSQL projects using Prisma ORM. It ensures correct configuration and adherence to project-specific patterns, preventing common errors and accelerating development.
Core Features & Use Cases
- Schema Modification & Migrations: Safely add, modify, or remove database tables and fields with guided Prisma migrations, using helper scripts for correct schema paths.
- Prisma ORM Operations: Write efficient and type-safe database queries using project-specific Prisma client imports and patterns like upserts and transactions.
- Database Maintenance: Easily generate the Prisma client, open Prisma Studio for GUI management, or reset the database with dedicated helper scripts.
- Use Case: Add a new
user_preferences table to the database, create a migration, and generate the updated Prisma client, ensuring all operations follow the project's non-standard schema path and best practices.
Quick Start
Create a new Prisma migration named 'add_user_preferences_table' to add a new table to the database schema.