database-schema

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.