Design scalable PostgreSQL data schemas for PayU financial transactions.
npx skills add https://github.com/fajjarnr/payu --skill data-architect
Please help me install this Agent Skill. Skill: data-architect Source: https://github.com/fajjarnr/payu/tree/main/.agent/skills/data-architect Command: npx skills add https://github.com/fajjarnr/payu --skill data-architect
This Skill provides expert guidance to design scalable, high-performance data schemas for the PayU platform using PostgreSQL, CQRS, event-sourcing, timescale, and JSONB patterns. It helps ensure immutable ledger design, auditability, and scalable data architecture for high-volume financial transactions.
Example: Ask the skill to outline a high-level data architecture plan for a new wallet service, including domain events, projections, and indexing.
High-intent search queries and answers about installing and using this skill.
Design immutable ledger schemas by applying event-sourcing and CQRS patterns in PostgreSQL to ensure reliable, auditable financial records. This approach separates write operations from read models, maintaining strict auditability for high-volume transaction processing.
Model time-series transaction events using TimescaleDB integration to enable efficient analytics on transaction events. This pattern optimizes high-frequency financial data storage and querying by partitioning data into time-based chunks for fast analytical processing.
Structure read models and projection tables for CQRS architecture by creating optimized query schemas separate from the event store. This allows fast analytics and retrieval without impacting the immutable write-side ledger performance.
Handle flexible metadata in PostgreSQL using JSONB data modeling with efficient indexing strategies. This pattern allows you to store dynamic transaction attributes while maintaining query performance through specialized JSONB indexing techniques.
Execute zero-downtime PostgreSQL schema migrations using Flyway for database governance and schema evolution. This strategy ensures continuous availability while applying structural changes to high-volume financial transaction databases.
Yes, you can use event-sourcing and CQRS patterns to build scalable data architecture on the PayU platform. This design ensures immutable ledger design, auditability, and high performance for high-volume financial transaction processing.
JhabbigDesign event store architectures for event-sourced systems across PostgreSQL, EventStoreDB, Kafka, DynamoDB, and Marten.
robomotionioManage time-series data in TimescaleDB via hypertables, compression, and continuous aggregates.
thc1006Project event streams into read models for CQRS and analytics.
stringztechnologiesManage multi-currency financial ledgers with SQL schema and TypeScript logic.
