PostgreSQL Development Standards

소개

This skill provides a comprehensive set of development patterns for PostgreSQL designed to prevent data corruption and runtime errors. It introduces the 'TX_' prefix naming convention to strictly manage transaction boundaries, mandates the use of ULIDs for secure and sortable primary keys, and ensures financial precision using exact decimal types. By enforcing read-write separation and typed JSONB columns, it helps Claude maintain high-integrity codebases, particularly when working with TypeScript and the Drizzle ORM.

주요 기능

• ULID primary key standards for time-sortable, secure identification
• Proactive indexing rules for foreign keys and common query filters
• TX_ prefix enforcement to distinguish transaction-starting methods from participants
• Strict numeric/decimal typing for financial data to prevent rounding errors
• 45 GitHub stars
• Mandatory type-safe JSONB definitions to avoid undefined property access

사용 사례

• Refactoring legacy database access code to ensure proper transaction wrapping
• Designing new database schemas that require high concurrency and data integrity
• Implementing type-safe PostgreSQL interactions within TypeScript/Drizzle environments