dba

Generate Prisma models with migrations, seeds, and ownership rules from schema designs.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/phishkatlabs/phishkat-crew --skill dba-phishkatlabs
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dba
Source: https://github.com/phishkatlabs/phishkat-crew/tree/main/dba
Command: npx skills add https://github.com/phishkatlabs/phishkat-crew --skill dba-phishkatlabs

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Prisma schema generation and migrations for architect-designed databases, ensuring production-grade schema evolution, strict data ownership, and reliable rollback capabilities.

Core Features & Use Cases

  • Generate a Prisma schema with UUID primary keys, createdAt/updatedAt timestamps, and user or organization ownership fields.
  • Create safe migrations with reversible down migrations and a seed script to populate realistic development data.
  • Enforce multi-schema setups, explicit relations, and robust indexing aligned to the architect's design for scalable production systems.

Quick Start

Run Prisma migrate dev to apply schema changes and Prisma db seed to populate development data.

Frequently Asked Questions about dba

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

FAQPage Schema
How do I generate a production-ready Prisma schema from a database design?

Generate a production-ready Prisma schema by translating architect designs into models with UUID primary keys, createdAt/updatedAt timestamps, user ownership fields, and explicit relations. The schema enforces strict ownership rules and supports multi-schema PostgreSQL architectures.

How do I create reversible Prisma migrations for PostgreSQL?

Create reversible Prisma migrations by generating safe up and down migrations aligned to your schema design. This enables safe rollbacks for production database architecture evolution while maintaining data integrity during schema changes.

What is the best way to seed realistic development data in Prisma?

Seed realistic development data in Prisma by running Prisma db seed after applying schema changes with Prisma migrate dev. The generated seed script populates your PostgreSQL database with realistic data for development testing.

Does this Prisma schema generation approach support multi-schema PostgreSQL setups?

Yes, this Prisma schema generation approach fully supports multi-schema PostgreSQL setups. It applies explicit relations and carefully designed indexes aligned to the architect's design to satisfy common access patterns in scalable production systems.

How do I enforce user ownership fields and constrained enums in a Prisma schema?

Enforce user ownership fields and constrained enums in a Prisma schema by applying strict ownership rules during model generation. This ensures every generated model includes user or organization ownership fields and constrained enums for data security.