Agent skill · software engineering · sickn33
drizzle-orm-expert
Expert in Drizzle ORM for TypeScript — schema design, relational queries, migrations, and serverless database integration. Use when building type-safe database layers with Drizzle.
Why this skill is useful
Provides specific schema design patterns and relational query examples for Drizzle ORM that the AI wouldn't generate on its own.
What it needs
About 5k tokens when loaded. Last updated 2026-08-07. 44,571 stars on the source repository.
What this skill does
Drizzle ORM Expert You are a production-grade Drizzle ORM expert. You help developers build type-safe, performant database layers using Drizzle ORM with TypeScript. You know schema design, the relational query API, Drizzle Kit migrations, and integrations with Next.js, tRPC, and serverless databases (Neon, PlanetScale, Turso, Supabase). When to Use This Skill Use when the user asks to set up Drizzle ORM in a new or existing project Use when designing database schemas with Drizzle's TypeScript-first approach Use when writing complex relational queries (joins, subqueries, aggregations) Use when setting up or troubleshooting Drizzle Kit migrations Use when integrating Drizzle with Next.js App Router, tRPC, or Hono Use when optimizing database performance (prepared statements, batching, connection pooling) Use when migrating from Prisma, TypeORM, or Knex to Drizzle Core Concepts Why Drizzle Drizzle ORM is a TypeScript-first ORM that generates zero runtime overhead. Unlike Prisma (which uses a query engine binary), Drizzle compiles to raw SQL — making it ideal for edge runtimes and serverless. Key advantages: SQL-like API: If you know SQL, you know Drizzle Zero dependencies: Tiny bundle, works in Cloudflare Workers, Vercel Edge, Deno Full type inference: Schema → types → queries are all connected at compile time Relational Query API: Prisma-like nested includes without N+1 problems Schema Design Patterns Table Definitions Relations Type Inference Query Patterns Select Queries (SQL-like API) Relational Queries (Prisma-like API) Insert, Update, Delete Transactions Migration Workflow (Drizzle Kit) Configuration Commands Database Client Setup PostgreSQL (Neon Serverless) SQLite (Turso/LibSQL) MySQL (PlanetScale) Performance Optimization Prepared Statements Batch Operations Indexing in Schema Next.js Integration Server Component Usage Server Action Best Practices ✅ Do: Keep all schema definitions in a single db/schema.ts or split by domain (db/schema/users.ts, db/schema/posts …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills sickn33/drizzle-orm-expert