Standardize schema-first Drizzle ORM structure for TypeScript database projects.
npx skills add https://github.com/Levironexe/architect --skill drizzle-orm-levironexe
Please help me install this Agent Skill. Skill: Drizzle ORM Source: https://github.com/Levironexe/architect/tree/main/skills/patterns/drizzle Command: npx skills add https://github.com/Levironexe/architect --skill drizzle-orm-levironexe
This Skill solves the problem of fragile, inconsistent database code in TypeScript projects by standardizing how Drizzle schemas, migrations, connections, and queries are organized so refactors stay safe and predictable.
Ask your AI coding agent to implement Drizzle ORM using a schema-first layout: put all tables and inferred types in src/db/schema.ts, create the singleton connection in src/lib/db.ts, move all queries into src/db/queries/*, and manage schema changes with drizzle-kit migrations.
High-intent search queries and answers about installing and using this skill.
To structure Drizzle ORM for safe refactoring, centralize table definitions in a single schema file, use a singleton database instance, and route all typed queries through dedicated functions to prevent inconsistent runtime behavior.
The best way to manage SQL migrations with Drizzle ORM is to configure drizzle-kit to generate versioned migration SQL files automatically, avoiding manual edits to migration files to maintain schema discipline.
To infer TypeScript types from Drizzle ORM schemas, use the built-in $inferSelect and $inferInsert utilities on your centralized table definitions to generate accurate select and insert types.
When using Drizzle ORM, you should instantiate a single database connection in a dedicated server-safe singleton file like src/lib/db.ts to prevent multiple connections and maintain consistent query execution.
Validating inputs at the service boundary with tools like Zod prevents invalid data from reaching your Drizzle ORM typed queries, defining common guardrails against risky runtime behavior and raw SQL string concatenation.
Yes, you can refactor existing CRUD services to use a schema-first Drizzle ORM architecture by relocating schemas, enforcing a singleton connection, and centralizing query functions to make API routes safe and predictable.
antonyfmunozManage PostgreSQL schemas and queries with Drizzle ORM in TypeScript.
zinohomeGenerate CRUD REST API endpoints with validation and TypeScript types.
VKirillValidate untrusted runtime inputs with Zod 4 schemas and structured errors.
fgarofalo56Generate type-safe database access for Node.js and TypeScript with Prisma ORM.
