The Complete Production SOP: How to Deploy and Run Drizzle Kit Declarative Migrations & Studio Inspector in Autonomous AI Agents

---
name: "drizzle-kit-schema-migrations"
description: "Generate and apply atomic SQL migrations and inspect database data via Drizzle Studio."
metadata:
  author: "Drizzle Team"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "generate drizzle migrations"
  - "drizzle-kit push schema"
  - "open drizzle studio"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: true
  net_access: true
---

# Execution Boundaries
- Always verify drizzle.config.ts exists before running migrations.
- Never execute interactive studio commands in headless agent subshells without --port flag.
- Ensure all table alterations generate valid SQL in ./drizzle before marking tasks complete.

import { defineConfig } from 'drizzle-kit';

export default defineConfig({
  schema: './src/db/schema.ts',
  out: './drizzle',
  dialect: 'postgresql',
  dbCredentials: {
    url: process.env.DATABASE_URL!,
  },
  verbose: true,
  strict: true,
});

import { pgTable, serial, text, timestamp, varchar } from 'drizzle-orm/pg-core';

export const users = pgTable('users', {
  id: serial('id').primaryKey(),
  fullName: varchar('full_name', { length: 256 }).notNull(),
  email: text('email').notNull().unique(),
  createdAt: timestamp('created_at').defaultNow().notNull(),
});

#!/usr/bin/env bash
set -euo pipefail

echo "Validating schema types..."
npx tsc --noEmit

echo "Checking migration consistency..."
npx drizzle-kit check

echo "Verification successful: All migrations aligned with schema."