skills.rest
myoshi2891
myoshi2891COMMUNITY
Explore all skills by this author →
GitHub

ec-db-migrator

Manage PostgreSQL schema definitions, migrations, and data seeding with Prisma ORM.

1|Updated Apr 28, 2025
Search Tags:#database#postgresql#schema#migration#prisma#seeding
One-click install
npx skills add https://github.com/myoshi2891/Multi-Vendor-E-Commerce --skill ec-db-migrator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ec-db-migrator
Source: https://github.com/myoshi2891/Multi-Vendor-E-Commerce/tree/main/.agent/skills/ec-db-migrator
Command: npx skills add https://github.com/myoshi2891/Multi-Vendor-E-Commerce --skill ec-db-migrator

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the process of managing your Multi-Vendor EC project's database schema, ensuring consistency and facilitating updates through migrations and data seeding.

Core Features & Use Cases

  • Schema Definition: Define and modify database models using Prisma's schema definition language.
  • Migration Management: Generate and apply database migrations to evolve the schema over time.
  • Data Seeding: Populate the database with initial or test data.
  • Use Case: When a new feature requires adding a 'wishlist' table for users, this Skill can help define the Wishlist and WishlistItem models in prisma/schema.prisma, generate the corresponding migration, and apply it to the database.

Quick Start

Use the ec-db-migrator skill to create a new database migration for adding a user profile table.

Frequently Asked Questions about ec-db-migrator

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

FAQPage Schema
How do I manage PostgreSQL database schema and migrations using Prisma?▼

You can manage PostgreSQL database schema and migrations using Prisma by defining models in the schema file, generating migration files to capture schema changes, and applying them to evolve your database structure while maintaining data integrity.

What is the best way to add a new table to a Prisma schema in a multi-vendor EC project?▼

The best way to add a new table is to define the new model in your Prisma schema file, generate the corresponding database migration, and apply it to update the PostgreSQL database schema for your multi-vendor EC project.

How does data seeding work with Prisma ORM for development environments?▼

Data seeding with Prisma ORM works by populating the PostgreSQL database with initial or test data, facilitating development environment setup and ensuring consistent baseline data for testing schema evolution.

Do I need a PostgreSQL database to use Prisma migrations for schema definition?▼

Yes, you need a PostgreSQL database because Prisma migrations generate and apply schema modifications specifically targeting PostgreSQL to facilitate schema evolution, data integrity, and client regeneration.

Can I regenerate the Prisma client after modifying the database schema?▼

Yes, you can regenerate the Prisma client after modifying the database schema. The migration process executes Prisma commands for schema modification, migration generation, and client regeneration to ensure type safety.

Related Skills

Explore More Software Engineering Skills→
bluebricks-nlbluebricks-nl

prisma-database-setup

Configure Prisma ORM with PostgreSQL, MySQL, SQLite, MongoDB, SQL Server, and CockroachDB.

Official
Intermediate
etylsarinetylsarin
59

prisma-database

Design Prisma schemas, orchestrate migrations, and guide queries for Node.js and TypeScript projects.

Community
Intermediate
xmark168xmark168
4

database-model

Generate Prisma schema models with relations and indexes for PostgreSQL.

Community
Intermediate
linenoizelinenoize
1

db

Generate rollback-aware database migration files and validate schema changes.

Community
Advanced