Build type-safe SQL schemas and queries in TypeScript with Drizzle ORM.
npx skills add https://github.com/johinsDev/loyalty-app --skill drizzle-orm-johinsdev
Please help me install this Agent Skill. Skill: drizzle-orm Source: https://github.com/johinsDev/loyalty-app/tree/main/.claude/skills/drizzle Command: npx skills add https://github.com/johinsDev/loyalty-app --skill drizzle-orm-johinsdev
Drizzle ORM helps you avoid unsafe, loosely typed database code by giving TypeScript-driven, SQL-like query building with compile-time type safety.
sql tag.Ask the AI to generate a Drizzle schema, a db client setup for your database, and a small set of CRUD queries for a new table in your project.
High-intent search queries and answers about installing and using this skill.
You can build type-safe SQL queries in TypeScript by defining database schemas using Drizzle ORM, which infers types for select and insert operations to ensure compile-time correctness and runtime safety.
Modeling one-to-many and many-to-many relations in a SQL database schema is handled through Drizzle ORM's relation modeling features, allowing you to define structured table connections and execute joins with inferred TypeScript types.
Yes, you can use raw SQL with parameterized queries for advanced SQL patterns like CTEs and window functions by utilizing the built-in SQL tag, ensuring safe execution alongside typed query builders.
You generate and manage database migrations for TypeScript projects by using Drizzle Kit alongside your schema definitions, creating migration files that sync your database state with your codebase.
Drizzle ORM supports multiple SQL dialects for CRUD operations, allowing you to use dialect-specific driver setups and typed query builders to ensure correct database interactions across different environments.
Optimizing type-safe database queries for pagination and indexing requires applying performance-focused patterns within Drizzle ORM, utilizing its query builder to structure efficient database interactions and batching.
Nick777-PixelGenerate TypeScript ORM migrations and models from Drizzle schema definitions for PostgreSQL projects.
Prompt-or-Die-LabsGenerate and apply Drizzle Kit migrations for PostgreSQL or SQLite schema changes.
bobmatnycDefine TypeScript database schemas and build type-safe SQL queries.
rauell1Guide Prisma Client queries for CRUD, relations, transactions, and raw SQL.