Research Drizzle ORM Patterns

Use this skill when you need to:

• Learn Drizzle ORM query patterns
• Understand schema definitions and migrations
• Research relations and joins
• Find transaction patterns
• Learn type-safe query building

Process

1. Identify Database Need

   • Schema design, queries, or migrations?
   • Relations, joins, or transactions?
   • Performance optimization?

2. Search Documentation (Ref)

   Copy

   Query patterns:
   - "Drizzle ORM [feature] PostgreSQL"
   - "Drizzle schema relations"
   - "Drizzle query builder"
   - "Drizzle migrations"
   

3. Find Implementation Examples (Exa)

   Copy

   Query patterns:
   - "Drizzle ORM PostgreSQL schema definition example"
   - "Drizzle query relations join implementation"
   - "Drizzle transaction rollback example"
   - "Drizzle migration file structure"
   

4. Verify Type Safety

   • Check TypeScript integration
   • Review inferred types
   • Validate query safety

Common Research Topics

Schema Definition

// Documentation
Query: "Drizzle ORM schema definition PostgreSQL types"

// Code examples
Query: "Drizzle pgTable schema relations foreign keys example"

Queries

// Documentation
Query: "Drizzle query builder select where join"

// Code examples
Query: "Drizzle ORM complex query multiple joins filtering example"

Relations

// Documentation
Query: "Drizzle ORM relations one-to-many many-to-many"

// Code examples
Query: "Drizzle relations query nested data user posts example"

Migrations

// Documentation
Query: "Drizzle kit migrations generate apply"

// Code examples
Query: "Drizzle migration alter table add column example"

Transactions

// Documentation
Query: "Drizzle transactions rollback commit"

// Code examples
Query: "Drizzle transaction atomic operations multiple tables example"

Integration with Next.js

Server Actions

// Research pattern
Query: "Drizzle ORM Next.js server actions database mutations"

API Routes

// Research pattern
Query: "Drizzle ORM Next.js API route handler database query"

Server Components

// Research pattern
Query: "Drizzle ORM Next.js server component async query"

Performance Patterns

Research topics:

• Query optimization
• Index usage
• Connection pooling
• Prepared statements
• Batch operations

Query: "Drizzle ORM performance optimization batch insert"
Query: "Drizzle PostgreSQL connection pooling Neon"

Output Format

Provide:

1. Schema examples - Table definitions with relations
2. Query patterns - Common query structures
3. Type safety - How TypeScript types are inferred
4. Best practices - From docs and real implementations
5. Performance tips - Optimization strategies
6. Migration guide - How to handle schema changes

When to Use

• Designing new database tables
• Writing complex queries
• Setting up relations
• Creating migrations
• Optimizing database performance
• Debugging query issues
• Learning Drizzle-specific features

Example Queries

User Authentication Schema

Documentation: "Drizzle schema user authentication sessions"
Code: "Drizzle PostgreSQL user table bcrypt password schema example"

E-commerce Relations

Documentation: "Drizzle relations orders products users"
Code: "Drizzle ORM order items products join query example"

Full-text Search

Documentation: "Drizzle PostgreSQL full text search"
Code: "Drizzle ts_vector search query implementation example"

Project-Specific Context

Your project uses:

• PostgreSQL with Drizzle ORM 0.44.5
• Neon serverless database
• Better Auth for authentication
• Next.js Server Components and Actions

Always research with this context in mind.

Related Skills

• research-typescript (for type patterns)
• research-nextjs (for Next.js integration)
• research-security (for secure queries)