Does this skill help with database security?

Yes, it implements a secure PostgreSQL RBAC model including specific roles for schema migrators, app readers, and app writers to follow the principle of least privilege.

What primary ORM does this skill support?

This skill is specifically optimized for Prisma ORM, providing detailed guidance for schema design, migrations, and client usage.

Can this help with unit testing database logic?

Yes, it includes patterns for mocking the Prisma Client to allow for fast, reliable unit testing of Data Access Objects (DAOs).

How are deletions handled in this pattern?

The skill promotes a 'soft delete' strategy using a deleted_at timestamp, ensuring data can be recovered and audit trails are preserved.

Prisma Data Access Guidelines

Name: Prisma Data Access Guidelines
Author: ZeroGravitySkin-Ron

byZeroGravitySkin-Ron

データベース管理

Manages type-safe database access layers using Prisma, DAO patterns, and PostgreSQL RBAC best practices.

概要

This skill provides a standardized framework for managing a Prisma-based data access library, specifically optimized for high-integrity TypeScript environments. It streamlines the implementation of database operations by enforcing patterns like UUID primary keys, mandatory timestamps, and soft deletes. By guiding users through schema design, Data Access Object (DAO) creation, and PostgreSQL Role-Based Access Control (RBAC), this skill ensures that database interactions remain secure, performant, and maintainable throughout the software development lifecycle.

主な機能

Type-safe Data Access Object (DAO) implementation strategies
Standardized Prisma schema design with UUID and timestamp patterns
Automated soft-delete workflows to prevent data loss
Robust transaction handling for complex, multi-step operations
0 GitHub stars
Comprehensive PostgreSQL RBAC configuration for enhanced security

ユースケース

Refactoring existing data access logic into encapsulated, testable DAO functions
Designing new database models with bi-directional relations and unique constraints
Configuring secure database migrations and role-based permissions for production environments

概要

主な機能

Type-safe Data Access Object (DAO) implementation strategies
Standardized Prisma schema design with UUID and timestamp patterns
Automated soft-delete workflows to prevent data loss
Robust transaction handling for complex, multi-step operations
0 GitHub stars
Comprehensive PostgreSQL RBAC configuration for enhanced security

ユースケース

Refactoring existing data access logic into encapsulated, testable DAO functions
Designing new database models with bi-directional relations and unique constraints
Configuring secure database migrations and role-based permissions for production environments