data-access-guidelines - Prisma Data Access and Database Design Guidelines
Provides guidelines for Prisma schemas, DAOs, migrations, type-safe queries, PostgreSQL RBAC, transactions, soft deletes, and database testing.
Tags
Updated: 2026-10-01Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Design Prisma schemas
- Define DAO patterns
- Create database migrations
- Write type-safe queries
- Handle transactions and soft deletes
- Configure PostgreSQL RBAC
- Test data access code
- Troubleshoot Prisma Client issues
Inputs
- Prisma schema requirements
- DAO requirements
- Database model definitions
- Relation definitions
- Migration names
- Database connection settings
- Database test scenarios
Outputs
- Prisma schema files
- DAO source files
- Prisma migration files
- Generated Prisma Client
- Database test results
- Database record changes
Requirements
- Prisma CLI and Client
- PostgreSQL database
- Database connection environment variables
- TypeScript project environment