Database

Generate database migration files

Analyze and optimize slow database queries

Design database schema from requirements

Generate database seed/sample data

Suggest database indexes based on query patterns

Generate ORM models from database schema

Convert raw SQL queries to ORM syntax

Create database backup and restore scripts

Configure database connection pooling

Design MongoDB/DynamoDB schemas

Set up Redis caching with proper patterns

Add database query monitoring and logging

Create data validation before database operations

Set up Prisma ORM with schema and migrations

Model complex relationships with Prisma (1:1, 1:n, m:n)

Execute raw SQL with Prisma for complex queries

Add Prisma middleware for logging, soft delete, and audit

Build MongoDB aggregation pipelines with stages and operators

Create and optimize MongoDB indexes for query performance

Set up MongoDB Atlas with clusters, backups, and monitoring

Model data with Mongoose schemas, virtuals, and middleware

Implement multi-document ACID transactions in MongoDB

Use Redis data structures (strings, hashes, lists, sets, sorted sets)

Write Redis Lua scripts for atomic operations

Implement pub/sub messaging with Redis

Configure Redis Cluster for high availability and sharding