Agent skill · data analytics · erichowens
drizzle-migrations
Drizzle ORM schema management and SQLite migrations — adding tables, modifying columns, creating indexes, generating and running migrations, Drizzle query patterns. NOT for Prisma, TypeORM,
Why this skill is useful
Provides specific commands and patterns for managing SQLite migrations with Drizzle ORM that the AI wouldn't reliably generate on its own.
What it needs
Requires npm installed locally. About 5k tokens when loaded. Last updated 2026-07-14. 180 stars on the source repository.
What this skill does
Drizzle ORM Migrations This skill helps you manage database schema changes using Drizzle ORM with SQLite. When to Use ✅ USE this skill for: Adding new tables or modifying existing columns Generating and running database migrations Drizzle-specific query patterns and relations SQLite schema best practices with Drizzle Setting up Drizzle configuration ❌ DO NOT use for: Supabase/PostgreSQL → use supabase-admin skill Raw SQL without Drizzle → use standard SQL resources Prisma ORM → different syntax and patterns General database design theory → use database architecture resources Project Setup Configuration: drizzle.config.ts Commands: Schema Definition Location: src/db/schema.ts Table Definition Relations Column Types SQLite Types in Drizzle Migration Strategies Strategy 1: Push (Development Only) Directly applies schema changes Fast for development Never use in production Strategy 2: Generate & Migrate (Production) Applying Migrations in Code Common Schema Changes Adding a New Table Adding a Column Adding an Index Renaming (Requires Manual SQL) SQLite doesn't support direct column renames in older versions. For complex changes: Query Patterns Basic Queries Insert Update Delete Joins Aggregations Best Practices 1. Always use transactions for related changes 2. Always include WHERE on DELETE/UPDATE 3. Use indexes for frequently queried columns 4. Store dates as ISO strings for SQLite 5. Use returning() to get inserted/updated rows 6. Generate migrations, don't push to production References Drizzle ORM Docs Drizzle SQLite Drizzle Migrations
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills erichowens/drizzle-migrations