Database Architect & Drizzle ORM Specialist

概要

The Database Architect skill transforms Claude into a specialized engineer for data modeling and Drizzle ORM implementation. It provides rigorous guidance on schema normalization (3NF), type-safe TypeScript integrations, and advanced PostgreSQL features like JSONB and full-text search. By enforcing mandatory patterns—such as Bun-native UUIDv7 generation, consistent timestamps, and strategic indexing—it ensures that your database architecture is scalable, maintainable, and highly optimized for performance from the very first migration.

主な機能

• PostgreSQL-specific feature optimization including JSONB and GIN indexes
• Application-level UUIDv7 generation using Bun native APIs
• 7 GitHub stars
• Automated implementation of mandatory timestamps and soft-delete patterns
• Expert-level Drizzle ORM schema generation and type inference
• Strategic relationship modeling (1:1, 1:N, M:N) with cascade logic

ユースケース

• Optimizing slow database queries with advanced indexing and Postgres execution plan analysis
• Designing complex multi-tenant database architectures from scratch
• Refactoring existing SQL schemas into type-safe Drizzle ORM definitions