skills.rest
allenlin90
allenlin90COMMUNITY
Explore all skills by this author →
GitHub

database-patterns

Standardize Prisma/PostgreSQL data-access patterns for soft delete, transactions, and bulk operations.

1|Updated Jan 2, 2025
Search Tags:#postgresql#transactions#prisma#soft-delete#database-patterns#optimistic-locking
One-click install
npx skills add https://github.com/allenlin90/eridu-services --skill database-patterns-allenlin90
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-patterns
Source: https://github.com/allenlin90/eridu-services/tree/main/.agent/skills/database-patterns
Command: npx skills add https://github.com/allenlin90/eridu-services --skill database-patterns-allenlin90

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Prisma patterns to ensure data integrity, performance, and correct concurrency handling in PostgreSQL-backed applications.

Core Features & Use Cases

  • Soft Delete, Transaction patterns, Bulk operations, Query optimization, and Advisory locks provide guardrails for safe, scalable data access across services.

Quick Start

Apply these patterns to implement consistent, safe data access in your Prisma/NestJS apps.

Frequently Asked Questions about database-patterns

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

FAQPage Schema
How do I implement safe soft delete in Prisma with PostgreSQL?▼

This Skill standardizes Prisma and PostgreSQL data-access patterns to ensure data integrity, safe soft delete, and correct concurrency handling. It provides guardrails for consistent, scalable data access across Node and NestJS services.

How does optimistic locking work for Prisma transactions?▼

This Skill standardizes Prisma and PostgreSQL data-access patterns to ensure data integrity, safe soft delete, and correct concurrency handling. It provides guardrails for consistent, scalable data access across Node and NestJS services.

What is the best way to handle bulk writes in Prisma and NestJS?▼

This Skill standardizes Prisma and PostgreSQL data-access patterns to ensure data integrity, safe soft delete, and correct concurrency handling. It provides guardrails for consistent, scalable data access across Node and NestJS services.

When do I need PostgreSQL advisory locks in a Prisma application?▼

This Skill standardizes Prisma and PostgreSQL data-access patterns to ensure data integrity, safe soft delete, and correct concurrency handling. It provides guardrails for consistent, scalable data access across Node and NestJS services.

Can I use these database patterns for query optimization in Node services?▼

This Skill standardizes Prisma and PostgreSQL data-access patterns to ensure data integrity, safe soft delete, and correct concurrency handling. It provides guardrails for consistent, scalable data access across Node and NestJS services.

Does this Skill work without additional Prisma plugins or dependencies?▼

This Skill standardizes Prisma and PostgreSQL data-access patterns to ensure data integrity, safe soft delete, and correct concurrency handling. It provides guardrails for consistent, scalable data access across Node and NestJS services.

Related Skills

Explore More Software Engineering Skills→
FindMalekFindMalek
9

prisma-database-setup

Configure Prisma for multiple database providers and set up the client.

Community
Intermediate
roberfloroberflo
1

efcore-patterns

Apply standardized EF Core 8 patterns for data access in .NET applications.

Community
Intermediate
henriqueatilahenriqueatila
3

golang-gin-database

Integrate PostgreSQL with Go Gin APIs using GORM or sqlx.

Community
Advanced
lety-ailety-ai

typeorm

Review TypeORM code to eliminate raw SQL and enforce repository patterns.

Official
Advanced