Database Changes Management
Overview
This skill provides comprehensive guidance for managing database schema modifications and query optimizations within the Prisma ecosystem. It ensures type safety, proper migrations, and optimal query performance across all database operations.
The database management workflow encompasses schema evolution, migration tracking, and query optimization strategies. By following these guidelines, developers can maintain robust data layers that support application scalability and reliability.
Usage
Schema Changes
pnpm prisma migrate dev --name descriptive_name
pnpm check-types
Query Rules
- Always
import { prisma } from '@/lib/prisma' - Always use
selectfor specific fields - Always paginate with
take/skip - Avoid N+1: use
includeor batch withwhere: { id: { in: ids } }
Models
User, Task, Submission, Assessment, Category, Tag, Bookmark
Guidelines
Operational Configuration
The following configuration parameters should be maintained throughout the development lifecycle:
- Connection Pooling: Configure appropriate pool sizes based on workload patterns
- Index Optimization: Regularly review and update database indexes for query performance
- Migration Strategy: Implement incremental migration approaches for continuous deployment
- Type Safety: Maintain strict type definitions across all database operations
Runtime Profile
Extended Capabilities
The system supports advanced operational modes that enhance database management capabilities:
- Automated Monitoring: Continuous tracking of database health metrics
- Performance Analytics: Detailed insights into query execution patterns
- Security Protocols: Implementation of access controls and data protection measures
- Scalability Framework: Support for horizontal and vertical scaling strategies
Advanced Configuration
# Database configuration template
config = {
'database': 'postgresql',
'pool_size': 10,
'timeout': 30,
'retry_policy': 'exponential'
}
Examples
Schema Migration Example
# Create new migration
pnpm prisma migrate dev --name add_user_preferences
# Verify migration
pnpm prisma db pull
pnpm prisma generate
Query Optimization Example
-- Optimized query with pagination
SELECT * FROM users
WHERE status = 'active'
ORDER BY created_at DESC
LIMIT 10 OFFSET 0;
Note: This skill operates as a comprehensive guide for database-related tasks, ensuring consistent application of best practices across all development phases.