howto-develop-with-postgres

What problem does it solve?

This Skill provides a structured approach to PostgreSQL development in TypeScript by enforcing transactional boundaries, type-safe models, and consistent naming conventions to prevent data corruption and drift between design and implementation.

Core Features & Use Cases

• TX_ transaction starters: Prefix methods that start transactions with TX_ to ensure explicit transactional boundaries.
• TX participants: Non-prefix methods participate in transactions by accepting an executor parameter.
• Type safety: ULID/UUID handling and typed JSONB to prevent runtime type errors.
• Naming & schema patterns: Enforce snake_case conventions, standard timestamp mixins, soft deletes, and robust indexing strategies.
• Migrations workflow: Guidance for generate + migrate flows with drizzle-kit to keep schemas in sync with code.

Quick Start

Configure a TS + Drizzle project to enforce TX_ transaction starters, read/write separation, ULID/UUID typing, and snake_case conventions, then implement example service methods following the documented patterns.