Agent skill · software engineering · aiskillstore
drizzle-orm-patterns
This skill provides comprehensive Drizzle ORM patterns for PostgreSQL with Vercel Edge Runtime support. Drizzle is Quetrex's chosen ORM because it's edge-first, type-safe, and supports all deployme...
Why this skill is useful
Adds comprehensive patterns and a Python script for validating Drizzle ORM queries that enhance database operations and security.
What it needs
Requires npm installed locally. About 4k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
Drizzle ORM Patterns - Complete PostgreSQL Reference Use when: Working with database operations, schema design, migrations, or queries in Quetrex. Overview This skill provides comprehensive Drizzle ORM patterns for PostgreSQL with Vercel Edge Runtime support. Drizzle is Quetrex's chosen ORM because it's edge-first, type-safe, and supports all deployment targets. Why Drizzle? Edge Runtime Compatible: Works with Vercel Edge Functions, Cloudflare Workers Type-Safe: Full TypeScript inference without code generation Zero Dependencies: No heavy Node.js runtime requirements SQL-Like API: Familiar to developers who know SQL Lightweight: ~7.4kb minified (vs Prisma's ~300kb) Skill Structure This skill is organized into focused modules: 1. queries-complete.md Complete query patterns: select, insert, update, delete, joins, pagination, filtering, aggregations, subqueries, CTEs. When to use: Building any database query Fetching data with filters Inserting/updating/deleting records Pagination or sorting Aggregating data (count, sum, avg) Complex joins or subqueries 2. transactions.md Transaction patterns: isolation levels, rollback, nested transactions, error handling, deadlock prevention. When to use: Multiple operations that must succeed together Financial operations (payments, transfers) Data consistency requirements Race condition prevention Complex multi-step workflows 3. relations.md Relationship patterns: one-to-one, one-to-many, many-to-many, self-referencing, cascading deletes, nested queries. When to use: Defining schema relationships Querying related data Setting up cascading operations Working with hierarchical data Optimizing related data fetching 4. migrations.md Migration patterns: schema evolution, data migrations, zero-downtime deployments, rollback strategies. When to use: Adding/modifying database schema Migrating data between schemas Deploying schema changes Rolling back problematic migrations Renaming tables/columns safely 5. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/drizzle-orm-patterns