Write type-safe Drizzle ORM queries for CRUD, joins, and transactions.
npx skills add https://github.com/theslashdojo/dojo --skill drizzle-queries
Please help me install this Agent Skill. Skill: drizzle-queries Source: https://github.com/theslashdojo/dojo/tree/main/nodes/drizzle/queries Command: npx skills add https://github.com/theslashdojo/dojo --skill drizzle-queries
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.
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.
High-intent search queries and answers about installing and using this skill.
Drizzle ORM enables type-safe database queries by using an SQL-like builder chain for CRUD operations. It provides full TypeScript inference for selects, inserts, updates, and deletes, preventing runtime errors and reducing developer guesswork.
Loading nested relations in Drizzle ORM is done through the relational API using db.query.* and with clauses. This approach simplifies nested data patterns by retrieving related records alongside the primary model in a single operation.
Yes, Drizzle ORM supports atomic transactions and prepared statements for PostgreSQL. It provides specific guidance on transaction atomicity, returning/upsert semantics, and cross-dialect behavior for PostgreSQL, SQLite, and MySQL.
Upsert operations and returning semantics in Drizzle ORM are handled through the query builder. The Skill provides guidance on these features alongside transaction atomicity and prepared statement support for robust backend services and data pipelines.
Yes, the Drizzle ORM query builder supports cross-dialect behavior for PostgreSQL, SQLite, and MySQL. It applies type-safe patterns to CRUD operations, joins, aggregations, and nested relational loading across all supported dialects.
sitharaj88Generate Drizzle ORM schemas, queries, and migrations for TypeScript projects.
multideskioProvides guidance on designing schemas and migrations with PostgreSQL and Drizzle ORM.
contatomayconBuild type-safe SQL data-access layers with compile-time query inference.
amanhsnGenerate relational database schemas, SQL migrations, and type definitions from natural language requirements.
