drizzle-orm

What problem does it solve?

This Skill eliminates inconsistencies and manual enforcement of Drizzle ORM coding conventions, ensuring all database queries, schemas, and migrations adhere to Head Shakers' strict patterns for type safety, permission filtering, pagination, and resilience.

Core Features & Use Cases

• Consistent Query Patterns: Automatically applies standardized query structures, context handling, and return values.
• Automated Permission & Soft Delete Filtering: Ensures all user-visible data is filtered by permissions and soft-delete flags.
• Resilience Integration: Enforces the use of circuit breaker and retry logic for robust database operations.
• Use Case: When creating a new query to fetch user data, this Skill ensures the query extends BaseQuery, uses createUserQueryContext, applies buildBaseFilters for permissions, and handles pagination with applyPagination, all automatically.

Quick Start

Generate a new Drizzle ORM query file for the 'Product' entity, ensuring all Head Shakers coding conventions are applied for type safety, permission filtering, and pagination.