Drizzle Migrations

If you're using Drizzle ORM with SQLite and need to evolve your schema without breaking things, this handles the full migration lifecycle. It covers table definitions, column types, indexes, and the critical difference between db:push (dev only) and proper migration generation for production. The docs include practical examples for common changes like adding tables, creating composite indexes, and handling SQLite's quirks around column renames. It's scoped specifically to Drizzle with SQLite, so if you're on Postgres with Supabase or using Prisma, you'll want different skills. Pairs well with database design patterns when you're figuring out what schema changes to make in the first place.

skills.sh installs: 126
GitHub stars: 113
last updated: Jun 3, 2026

View on GitHub

Install

$ npx -y skills add erichowens/some_claude_skills --skill drizzle-migrations --agent claude-code

Installs into .claude/skills of the current project.

Files

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

import { defineConfig } from 'drizzle-kit';

export default defineConfig({
  schema: './src/db/schema.ts',
  out: './drizzle',
  dialect: 'sqlite',
  dbCredentials: {
    url: './data/app.db',
  },
});

Commands:

npm run db:generate  # Generate migration files
npm run db:push      # Push schema directly (dev only)
npm run db:studio    # Open Drizzle Studio GUI

Schema Definition

Location: src/db/schema.ts

Table Definition

SKILL.md on GitHub

Details

Repository: github.com/erichowens/some_claude_skills
Categories: Backend & APIs, Databases
First seen: Jun 3, 2026