How does this skill help with financial data accuracy?

It mandates the use of exact numeric or decimal types instead of floating-point types (float/double), which prevents the accumulation of rounding errors in monetary calculations.

What is the TX_ naming convention enforced by this skill?

It is a strict rule where any method initiating a database transaction must start with the 'TX_' prefix and must not accept an external executor, ensuring clear boundaries for atomic operations.

Does this skill work with TypeScript ORMs?

Yes, it is designed to work seamlessly with ORMs like Drizzle, providing patterns for type-safe JSONB columns and compile-time read-write client separation.

Why does this skill recommend ULIDs over serial integers?

ULIDs (stored as UUIDs) are recommended because they prevent ID enumeration attacks and are time-sortable, which maintains high indexing efficiency while protecting data visibility.

PostgreSQL Development Patterns

Name: PostgreSQL Development Patterns
Author: ed3dai

byed3dai

•

데이터베이스 관리

Enforces transaction safety, strict typing, and naming conventions for PostgreSQL to prevent data corruption and runtime errors.

This skill provides a comprehensive set of standards for PostgreSQL development, focusing on high-integrity data management and architectural consistency. It implements a strict naming convention for transaction handling (the TX_ prefix rule), ensures type safety for complex types like ULIDs and JSONB, and enforces a clear separation between read and write operations at the type level. By using this skill, developers can maintain consistent database schemas, prevent floating-point errors in financial data, and ensure that all multi-step operations are wrapped in safe, predictable transactions.

주요 기능

01Mandatory schema typing for JSONB columns to eliminate runtime errors

02Strict TX_ naming convention for explicit transaction management

035 GitHub stars

04Exact decimal type requirements for high-precision financial data

05ULID primary key enforcement for security and indexing efficiency

06Standardized snake_case database naming with proactive indexing rules

사용 사례

01Implementing complex financial logic requiring exact decimal precision

02Refactoring database access layers to improve type safety and transaction reliability

03Architecting new relational schemas with production-grade safety standards

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ed3dai/ed3d-plugins-testing howto-develop-with-postgres

For use in Claude.ai and ChatGPT

Download Skill