Drizzle ORM Prompt Pack

I'm using Drizzle ORM with Neon serverless PostgreSQL in a Next.js 15 App Router project.
 
Setup:
- Driver: @neondatabase/serverless (not 'pg' or 'postgres')
- DB client: import { db } from '@/lib/db' — already configured
- Schema files: src/lib/db/schema.ts (or schema/*.ts)
- Migrations: managed with drizzle-kit
 
Key rules:
- Use pgTable() from 'drizzle-orm/pg-core' for all table definitions
- Import { eq, and, or, desc, asc, sql } from 'drizzle-orm' for operators

I need a Drizzle schema for [describe your data model].
 
Requirements:
- Use pgTable() from 'drizzle-orm/pg-core'
- Primary keys: use uuid() with .defaultRandom() OR serial() — I'll tell you which
- Timestamps: createdAt and updatedAt on every table, use timestamp() with { withTimezone: true }
- updatedAt should use .$onUpdate(() => new Date())
- Foreign keys: reference the parent table column directly
- Export the table AND the inferred TypeScript types (Select and Insert variants)
 
Tables needed:
[describe each table and its fields, relationships, and any constraints]
 
Also define the relations() for each table so I can use the 'with' syntax in queries.

I need to query [describe what you want to fetch] using Drizzle's relational query API.
 
My schema has these relations already defined:
[paste your relations() definitions]
 
Requirements:
- Use db.query.[tableName].findMany() or findFirst() — not db.select()
- Include related data with the 'with' key
- Filter with the 'where' key using operators from 'drizzle-orm'
- Limit and offset for pagination if needed
- The return type should be inferred — don't write manual return type interfaces
 
Query goal: [describe exactly what data you need and any filters]

I need Drizzle mutations for [describe the operation].
 
Requirements:
- Insert: use db.insert(table).values({...}).returning()
- Update: use db.update(table).set({...}).where(eq(table.id, id)).returning()
- Delete: use db.delete(table).where(eq(table.id, id))
- Always use .returning() on insert/update so I get the created/updated record back
- Infer the insert type: type NewUser = typeof users.$inferInsert
- Wrap in try/catch — throw a typed error on constraint violations
 
Operation: [describe what you're inserting/updating/deleting]
Data shape: [describe the input fields and types]

Explain the correct migration workflow for my Drizzle + Neon setup.
 
My setup:
- drizzle.config.ts is configured with dialect: 'postgresql' and Neon connection string
- Schema is in src/lib/db/schema.ts
 
I need to understand:
1. When to use 'pnpm drizzle-kit push' vs 'pnpm drizzle-kit generate' + 'pnpm drizzle-kit migrate'
2. How to safely apply a schema change [describe the change] to production
3. Whether this change is destructive (column removal, rename, type change)
4. What the migration SQL will look like before I run it
 
Schema change I need to make: [describe what you're adding/changing/removing]

I need [a transaction / an upsert] in Drizzle.
 
[For transactions]:
I need to perform multiple writes atomically:
1. [describe first operation]
2. [describe second operation]
3. [describe third operation]
If any step fails, all changes should be rolled back.
 
Use db.transaction(async (tx) => { ... }) — pass tx instead of db to all operations inside.
 
[For upserts]:
I need to insert a record if it doesn't exist, or update it if it does.
Conflict target: [describe the unique column(s)]
On conflict: [describe what fields to update]
 
Use db.insert(table).values({...}).onConflictDoUpdate({ target: table.column, set: {...} })