| name | db-migrations |
| description | Intelligent database migration management for Drizzle ORM with Better Auth integration in Cloudflare Workers environment. Analyzes schema changes, validates migrations, and guides production deployment strategies. |
Database Migration Management
This skill provides intelligent assistance for database operations in the Cloudflare Workers monorepo, specifically focusing on Drizzle ORM with Better Auth integration.
When to Use
This skill is automatically invoked when:
- Working with database schema files
- Generating or applying migrations
- Setting up Better Auth
- Planning database deployments
Capabilities
Schema Analysis
- Detects breaking changes in database schema modifications
- Validates Better Auth compatibility with custom schema
- Suggests optimal indexes for new columns and relationships
- Identifies potential performance impacts
Migration Intelligence
- Generates safe migration strategies for production environments
- Provides rollback plans for complex schema changes
- Validates migration order and dependencies
- Ensures Neon Postgres and Hyperdrive compatibility
Best Practices Enforcement
- Enforces naming conventions for tables and columns
- Suggests appropriate data types for Cloudflare Workers constraints
- Validates foreign key relationships and constraints
- Ensures proper timezone handling for timestamps
Example Usage
Schema Modification
When you modify schema files in packages/db/src/schema/, this skill will:
- Analyze the changes for breaking modifications
- Suggest appropriate migration strategies
- Validate Better Auth table compatibility
- Recommend indexes for performance
Migration Generation
When running just db-generate, this skill provides:
- Review of generated SQL for safety
- Suggestions for multi-step migrations when needed
- Validation against production constraints
- Documentation of migration purpose and impact
Production Deployment
For production migrations, this skill offers:
- Zero-downtime deployment strategies
- Backup and rollback procedures
- Connection pooling considerations for Hyperdrive
- Monitoring and validation steps
Integration
Works seamlessly with existing commands:
just db-generate - Enhanced migration generation
just db-migrate - Guided migration application
just db-setup - Comprehensive setup validation
just auth-schema - Better Auth integration
Error Recovery
Provides guidance for common migration issues:
- Failed migrations and partial application
- Schema drift between environments
- Better Auth table conflicts
- Connection timeout with large migrations