Does this skill support PostgreSQL 18 features?

Yes, it includes specific optimizations for PostgreSQL 18, such as native UUIDv7 for primary keys and Async I/O performance tuning.

Can it help with complex database relations?

Absolutely. The skill covers one-to-many, many-to-many junction table patterns, and the Drizzle Relational Queries API for efficient nested data fetching.

How does it help with database migrations?

It provides standardized workflows for using drizzle-kit to generate, apply, and push migrations safely across development and production environments.

Is this skill suitable for high-load applications?

Yes, it includes a dedicated performance checklist covering connection pooling, partial indexing, and query optimization using EXPLAIN ANALYZE.

PostgreSQL & Drizzle ORM

Name: PostgreSQL & Drizzle ORM
Author: ccheney

byccheney

•

Database Management

Architects type-safe database schemas and high-performance PostgreSQL 18 queries using Drizzle ORM best practices.

About

This skill provides comprehensive guidance for building robust, type-safe database layers using PostgreSQL 18 and Drizzle ORM. It streamlines the creation of complex schemas, efficient migrations, and optimized queries by applying modern patterns like UUIDv7 primary keys, Index Skip Scans, and advanced relational mapping. It is essential for developers building scalable backends who need to ensure data integrity while maximizing database performance through proven architectural structures, performance-tuning checklists, and standardized directory patterns.

Key Features

1 GitHub stars
Type-safe schema definition and Drizzle ORM integration
PostgreSQL 18 optimization including UUIDv7 and Async I/O
Automated migration workflows using drizzle-kit
Advanced SQL patterns for RLS, partitioning, and JSONB
Performance-first relational query handling to prevent N+1 issues

Use Cases

Managing complex, type-safe database migrations in TypeScript projects
Architecting scalable backend data models for production APIs
Optimizing slow PostgreSQL queries with advanced indexing and EXPLAIN analysis

About

Key Features

1 GitHub stars
Type-safe schema definition and Drizzle ORM integration
PostgreSQL 18 optimization including UUIDv7 and Async I/O
Automated migration workflows using drizzle-kit
Advanced SQL patterns for RLS, partitioning, and JSONB
Performance-first relational query handling to prevent N+1 issues

Use Cases

Managing complex, type-safe database migrations in TypeScript projects
Architecting scalable backend data models for production APIs
Optimizing slow PostgreSQL queries with advanced indexing and EXPLAIN analysis