drizzle-query

What problem does it solve?

This Skill simplifies writing complex, type-safe database queries using Drizzle ORM, ensuring data integrity and reducing common errors in backend development.

Core Features & Use Cases

• Complex Joins: Easily query across multiple related tables.
• JSONB Operations: Read, write, and merge data within JSONB columns.
• Idempotent Inserts: Handle potential duplicate data with upserts.
• Transactions: Ensure atomicity for multi-step database operations.
• Pagination: Implement efficient offset or cursor-based pagination.
• Use Case: When building a feature that requires fetching a user's profile along with their recent orders and associated product details, this Skill provides the patterns to construct a single, efficient, and type-safe query.

Quick Start

Use the drizzle-query skill to fetch all assets for a room including their processed variants.