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.
主要功能
01Type-safe Data Access Object (DAO) implementation strategies
02Standardized Prisma schema design with UUID and timestamp patterns
03Automated soft-delete workflows to prevent data loss
04Robust transaction handling for complex, multi-step operations
050 GitHub stars
06Comprehensive PostgreSQL RBAC configuration for enhanced security
使用场景
01Refactoring existing data access logic into encapsulated, testable DAO functions
02Designing new database models with bi-directional relations and unique constraints
03Configuring secure database migrations and role-based permissions for production environments
