drizzle-patterns

Automate Drizzle ORM schema patterns with cuid2 keys and cascade deletes.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/leonardoacosta/Installfest --skill drizzle-patterns
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: drizzle-patterns
Source: https://github.com/leonardoacosta/Installfest/tree/main/automate/.claude/skills/drizzle-patterns
Command: npx skills add https://github.com/leonardoacosta/Installfest --skill drizzle-patterns

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides reusable Drizzle ORM schema patterns to encourage consistency in table definitions, relations, and migrations across Otaku Odyssey applications.

Core Features & Use Cases

  • Schema Definition: Standard table definitions with primary keys, fields, and audit timestamps.
  • Relations & Migrations: Patterns for one-to-many, many-to-many relationships and migration commands.
  • Query Patterns: Example queries for common operations like find, insert, update with relations.

Quick Start

Use the patterns when creating or updating a database schema, e.g., define a new features table following the pattern shown.

Frequently Asked Questions about drizzle-patterns

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I define consistent database schemas with Drizzle ORM?

Drizzle ORM schemas benefit from standardized patterns for table definitions, primary keys, and audit fields. This Skill provides reusable schema patterns including cuid2 primary keys, cascade delete foreign keys, audit timestamps, and soft deletion fields to enforce consistency across your application's database design.

What are the best practices for Drizzle ORM migrations and relations?

Best practices for Drizzle migrations include explicit relation declarations, standardized migration commands, and consistent patterns for one-to-many and many-to-many relationships. This Skill defines proven patterns for these scenarios to reduce errors and maintain schema integrity across your database evolution.

How do I structure TypeScript database queries with Drizzle ORM?

TypeScript database queries with Drizzle benefit from standardized patterns for common operations like find, insert, and update with relations. This Skill provides example query patterns that work alongside schema definitions to ensure type safety and consistency in your data access layer.

Can I use Drizzle ORM for soft deletion and audit tracking?

Yes. Drizzle ORM supports soft deletion through dedicated fields and audit tracking via timestamp columns. This Skill enforces these patterns as standard requirements, allowing you to implement compliant soft deletion and maintain audit trails across all tables consistently.

Do I need enum definitions in my Drizzle database schema?

Enum definitions in Drizzle schemas provide type safety and consistency for categorical data. This Skill includes enum patterns as a standard requirement, ensuring your TypeScript types align with database column constraints and reducing validation logic duplication.