skills.rest
habrahgithub
habrahgithubCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

prisma-postgres-ops

Manage Prisma and Postgres workflows for client generation, migrations, seeding, and test resets.

Updated Feb 1, 2026
Search Tags:#devops#database#migrations#prisma#node#postgres#seed
One-click install
npx skills add https://github.com/habrahgithub/node-backend-starter --skill prisma-postgres-ops
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-postgres-ops
Source: https://github.com/habrahgithub/node-backend-starter/tree/main/.codex/skills/prisma-postgres-ops
Command: npx skills add https://github.com/habrahgithub/node-backend-starter --skill prisma-postgres-ops

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines repetitive and error-prone Prisma and Postgres operational tasks so engineers can reliably update schema, generate clients, seed test data, and perform controlled test resets without jeopardizing production data.

Core Features & Use Cases

  • Generate Prisma client after schema changes to keep application code in sync.
  • Local and deployment-safe migrations using migrate:dev for development and migrate:deploy for CI/CD or production apply.
  • Test data management via seeded datasets and dedicated reset flows to recreate deterministic test environments.
  • Use Case: When updating a Prisma schema for a feature branch in projects/node-backend-starter-v2, use this Skill to run generate, apply dev migrations, seed test data, and validate integration tests against the dev database.

Quick Start

Run the Prisma Postgres Ops workflow to install dependencies, set DATABASE_URL, generate the Prisma client, apply dev migrations, seed test data, or reset the test database as needed.

Frequently Asked Questions about prisma-postgres-ops

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run safe Prisma migrations and Postgres operations in Node?▼

Run Prisma migrations safely by using migrate:dev for local development and migrate:deploy for CI/CD deployments, requiring a configured DATABASE_URL per environment and specific npm scripts.

How do I manage test data and reset test databases using Prisma?▼

Manage test data by running dedicated prisma:seed and prisma:reset:test npm scripts to seed datasets and perform controlled test resets, recreating deterministic test environments against a separate test database.

What npm scripts do I need for Prisma and Postgres workflows?▼

You need prisma:generate, prisma:migrate:dev, prisma:migrate:deploy, prisma:seed, and prisma:reset:test npm scripts configured in your Node project to execute client generation, migrations, seeding, and test resets.

Does this Prisma Postgres workflow support separate development and test databases?▼

Yes, the workflow requires a configured DATABASE_URL per environment and explicitly uses separate dev and test databases to ensure controlled test resets do not impact development or production data.

When do I need to generate the Prisma client after schema changes?▼

Generate the Prisma client using prisma:generate immediately after updating your Prisma schema to keep your application code in sync with the latest database schema definitions.

Related Skills

Explore More Software Engineering Skills→
johnnystefanjohnnystefan

prisma-database-setup

Configure Prisma ORM database providers and adapters for PostgreSQL, MySQL, SQLite, CockroachDB, SQL Server, Prisma Postgres, and MongoDB.

Community
Intermediate
meistro57meistro57
1

laravel:migrations-and-factories

Manage Laravel database migrations, models, factories, and seed data.

Community
Intermediate
freedomw1987freedomw1987
2

prisma-add-column-existing-db

Add new columns to existing Prisma models in production PostgreSQL databases.

Community
Intermediate
PlazaCCPlazaCC
2

db-migrate

Generate and apply Drizzle ORM migration scripts for Supabase Postgres.

Official
Intermediate