skills.rest
etylsarin
etylsarinCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

prisma-database

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

59|12|Updated Feb 26, 2026
Search Tags:#typescript#database#migrations#queries#orm#prisma#schema-design
One-click install
npx skills add https://github.com/etylsarin/opencastle --skill prisma-database-etylsarin
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-database
Source: https://github.com/etylsarin/opencastle/tree/main/src/orchestrator/plugins/prisma
Command: npx skills add https://github.com/etylsarin/opencastle --skill prisma-database-etylsarin

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It reduces the friction and risk of designing database schemas, creating and applying migrations, and keeping Prisma Client in sync so teams avoid schema drift, runtime errors, and migration surprises.

Core Features & Use Cases

  • Schema Design Guidance: Recommendations for models, relations, indexes, enums, and naming with examples for common patterns.
  • Migration Best Practices: Steps for creating, reviewing, testing, and deploying migrations safely across development and CI/CD pipelines.
  • Query Patterns & Client Usage: Examples for CRUD operations, transactions, pagination, error handling, and the singleton PrismaClient pattern to prevent connection exhaustion.
  • Use Case: Useful for backend engineers adding new domain models, onboarding projects to Prisma, or creating repeatable migration workflows for production deployments.

Quick Start

Use the prisma-database skill to initialize Prisma, create a descriptive migration, and run generate to update Prisma Client for your project.

Frequently Asked Questions about prisma-database

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

FAQPage Schema
How do I design a Prisma schema with relations and indexes for PostgreSQL?▼

Designing a Prisma schema involves defining models, relations, enums, and indexes in your schema file to create type-safe database structures and optimize query performance for supported datastores like PostgreSQL.

What is the best way to manage Prisma migrations in a CI/CD pipeline?▼

Managing Prisma migrations in CI/CD requires creating descriptive migration files, reviewing schema changes, testing locally, and deploying them safely to prevent schema drift and avoid runtime errors.

How do I prevent Prisma Client connection exhaustion in a Node.js backend?▼

Prevent Prisma Client connection exhaustion in Node.js by implementing the singleton PrismaClient pattern, which ensures a single database connection instance is reused across your backend application.

Can I use Prisma ORM for transactions and pagination in TypeScript?▼

Yes, you can use Prisma ORM in TypeScript for transactions and pagination by applying specific query patterns for CRUD operations, handling errors, and managing data limits safely.

Why does my Prisma Client go out of sync after schema changes?▼

Prisma Client goes out of sync after schema changes because the client code must be regenerated using the generate command to reflect the latest database schema and maintain type safety.

Related Skills

Explore More Software Engineering Skills→
gil00pitagil00pita

prisma

Generate a type-safe Prisma Client from declarative schemas for Node.js and TypeScript.

Community
Advanced
ravnhqravnhq
16

tech-prisma

Design Prisma ORM schemas and typed query patterns for Node.js/TypeScript backends.

Official
Advanced
leonj1leonj1

flyway-backend-docker

Modify Dockerfiles and add entrypoint scripts to run Flyway SQL migrations before application startup.

Community
Intermediate
johinsDevjohinsDev

drizzle-orm

Build type-safe SQL schemas and queries in TypeScript with Drizzle ORM.

Community
Intermediate