drizzle-queries

What problem does it solve?

This Skill streamlines writing safe, type-checked SQL queries and nested relational loads by providing idiomatic Drizzle ORM patterns, examples, and notes that reduce runtime errors and developer guesswork.

Core Features & Use Cases

• Type-safe query builder: Idiomatic SQL-like chaining for selects, inserts, updates, deletes with full TypeScript inference.
• Relational API: Load nested relations with db.query.* and with clauses to simplify common nested data patterns.
• Transactions, prepared statements & dialect notes: Guidance for atomic transactions, prepared statements, returning/upsert semantics, and cross-dialect considerations for PostgreSQL, SQLite, and MySQL.
• Use Case: Backend engineers building paginated APIs, transactional imports, or analytical aggregations can rely on these patterns to implement robust, type-safe data access.

Quick Start

Use the drizzle-queries skill to select recent users with their published posts and return up to 10 results including each author's basic profile.