How does this skill handle Row Level Security (RLS)?

The skill mandates that every database operation (Read, Update, Delete) includes a userId check within the where clause. This ensures that user data is protected at the database query level rather than just the application level.

Where should database logic be stored according to this skill?

All database logic must be organized within the /server/database/queries/ directory, grouped by domain (e.g., users.ts, workouts.ts) to keep API routes clean and the codebase maintainable.

What is the difference between queryX and getX functions?

queryX functions return the data or null/undefined without throwing an error, making them ideal for conditional logic. getX functions are designed to throw a 404 error automatically if a record is not found, simplifying API route handlers.

Why should I avoid explicit Promise return types in Drizzle queries?

Letting Drizzle infer return types ensures that complex relational data (using 'with' clauses) is perfectly typed without manual intervention, which prevents type mismatches when schemas or relations change.

Drizzle ORM Database Patterns

Name: Drizzle ORM Database Patterns
Author: JosephAnson

byJosephAnson

0•

Gestión de Bases de Datos

Implements standardized Drizzle ORM patterns, query conventions, and Row Level Security (RLS) for robust database management.

This skill provides comprehensive architectural guidance for managing databases using Drizzle ORM, specifically tailored for applications requiring strict data isolation and type safety. It enforces a clean separation of concerns by centralizing database logic in dedicated query files, preventing the direct use of database clients in API routes. By providing clear naming conventions for CRUD operations—distinguishing between safe queries and error-throwing getters—it streamlines backend development. The skill also mandates the implementation of Row Level Security (RLS) to ensure multi-tenant data privacy and leverages Drizzle's powerful inference engine to maintain end-to-end TypeScript safety without manual type maintenance.

Características Principales

010 GitHub stars

02Mandatory Row Level Security (RLS) patterns for every query to prevent unauthorized data access.

03Advanced patterns for complex relational queries, atomic transactions, and SQL-based aggregations.

04Standardized naming conventions (queryX vs getX) for predictable error handling and API responses.

05Automatic TypeScript type inference to eliminate manual return type definitions and reduce bugs.

06Strict separation of concerns by isolating database logic within the /server/database/queries/ directory.

Casos de Uso

01Migrating from raw SQL or generic ORM patterns to a highly structured, type-safe Drizzle architecture.

02Implementing complex data relationships and paginated list views in high-performance backend services.

03Building multi-tenant applications where users must only access their own private data.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add josephanson/claude-plugin database

For use in Claude.ai and ChatGPT

Download Skill