Use when adding Drizzle ORM + Drizzle Kit integration in TypeScript projects, especially Next.js App Router with PostgreSQL. Triggers: setup drizzle, configure drizzle-kit, add db client, add migrations, add schema files, add database scripts.
Set up Drizzle ORM end-to-end with:
drizzle-ormdrizzle-kitpgThis skill should implement files and scripts, not only propose a plan.
Use these templates as the default source when integrating into a Next.js App Router project:
templates/next-app-router/drizzle.config.tstemplates/next-app-router/.env.exampletemplates/next-app-router/lib/db.tstemplates/next-app-router/lib/schema.example.db.tstemplates/next-app-router/package.scripts.snippet.jsontemplates/next-app-router/drizzle/*.sqltemplates/next-app-router/drizzle/meta/*.jsontemplates/next-app-router/README.mdUse this repo-specific reference when the target project follows the same conventions:
reference/sembilan-registry-radix-node/drizzle.config.tsreference/sembilan-registry-radix-node/lib/db.tsreference/sembilan-registry-radix-node/drizzle/*.sqlreference/sembilan-registry-radix-node/drizzle/meta/*.jsonreference/sembilan-registry-radix-node/drizzle/README.mdreference/sembilan-registry-radix-node/README.mdnext, vite, node) from package.json.tsconfig.json.drizzle-orm, pg, @types/pg when TypeScript needs it.drizzle-kit.pnpm, npm, yarn, or bun).drizzle.config.ts.@next/env + loadEnvConfig).dialect: "postgresql".schema glob to where *.db.ts files live../drizzle by default).dbCredentials.url to process.env.DATABASE_URL.pg client.drizzle client with imported schema modules.max, idleTimeoutMillis, connectionTimeoutMillis).*.db.ts files to match drizzle-kit discovery.snake_case vs default).drizzle:generatedrizzle:migratedrizzle:pushdrizzle:studiotemplates/next-app-router/drizzle/ to target drizzle/.meta/ snapshot/journal files.drizzle-kit generate only after baseline migrations are present.drizzle/.DATABASE_URL is documented.drizzle.config.ts exists and resolves env values.package.json.drizzle/ (*.sql + meta/*.json).