drizzle_orm

SKILL.md

Status: Production Ready ✅ Last Updated: 2025-10-24 Latest Version: drizzle-orm@0.44.7, drizzle-kit@0.31.5 Dependencies: cloudflare-d1, cloudflare-worker-base

✅ Use drizzle-kit generate for migrations - Never write SQL manually ✅ Test migrations locally first - Always use --local flag before --remote ✅ Define relations in schema - For type-safe joins and nested queries ✅ Use .get() for single results - Returns first row or undefined ✅ Use db.batch() for transactions - D1 doesn't support SQL BEGIN/COMMIT

✅ Use integer with mode: 'timestamp' for dates - D1 doesn't have native date type ✅ Use .$defaultFn() for dynamic defaults - Not .default() for functions ✅ Set migrationsdir in wrangler.jsonc - Points to ./migrations ✅ Use environment variables for credentials - Never commit API keys ✅ Import operators from drizzle-orm - eq, gt, and, or, etc.

Ver original