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

•

数据库管理

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

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.

主要功能

011 GitHub stars

02Type-safe schema definition and Drizzle ORM integration

03PostgreSQL 18 optimization including UUIDv7 and Async I/O

04Automated migration workflows using drizzle-kit

05Advanced SQL patterns for RLS, partitioning, and JSONB

06Performance-first relational query handling to prevent N+1 issues

使用场景

01Managing complex, type-safe database migrations in TypeScript projects

02Architecting scalable backend data models for production APIs

03Optimizing slow PostgreSQL queries with advanced indexing and EXPLAIN analysis

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ccheney/robust-skills postgres-drizzle

For use in Claude.ai and ChatGPT

Download Skill