Standardizes PostgreSQL schema design and SQLAlchemy implementation for robust ERP data management.
The PatriotForge Database skill provides a comprehensive framework for managing data structures within the PatriotForge ERP ecosystem, specifically tailored for PostgreSQL 15 and SQLAlchemy 2.x. It enforces critical engineering standards such as UUID-based primary keys, mandatory audit columns, and soft-delete patterns to ensure data integrity and traceability. By providing standardized model patterns and Alembic migration workflows, it enables developers to rapidly build complex financial and operational schemas while maintaining strict precision for currency and quantity data.
Key Features
01Enforces standardized naming conventions with forge_ table prefixes
02Streamlines Alembic migration workflows with role-based access conventions
03Provides pre-defined SQLAlchemy 2.0 async model patterns
04Implements robust UUID v4 primary keys and mandatory audit columns
050 GitHub stars
06Configures precision-safe numeric types for financial and percentage data
Use Cases
01Creating new ERP database models with built-in audit and soft-delete capabilities
02Designing complex financial schemas requiring precise currency and quantity handling
03Orchestrating safe database migrations and schema updates using Alembic
