NestJS Database
NestJS Database Standards
Selection Framework
1. Data Structure Analysis (The "What")
- Structured & Highly Related: Users, Orders, Inventory, Financials.
- Choice: PostgreSQL (Default).
- Why: Strict schema validation, ACID transactions, complex generic queries (Joins).
- Unstructured / Polymorphic: Product Catalogs (lots of unique attributes), CMS Content, Raw JSON blobs.
- Choice: MongoDB.
- Why: Schema flexibility, fast development speed for flexible data models.
- Time-Series / Metrics: IoT Sensor Data, Stock Prices, Server Logs.
- Choice: TimescaleDB (Postgres Extension).
- Why: Compression, hypertable partitioning, rapid ingestion.
2. Access Pattern Analysis (The "How")
- Transactional (OLTP): "User buys items to cart".
More from diegosouzapw/awesome-omni-skill
music-assistant
Control Home Assistant Music Assistant - browse library, search, play, manage preferences and moods.
12agent-code-generator
Generates Agent definitions (.md files) based on user intent and standard templates.
6terragrunt-generator
Comprehensive toolkit for generating best practice Terragrunt configurations (HCL files) following current standards and conventions. Use this skill when creating new Terragrunt resources (root configs, child modules, stacks, environment setups), or building multi-environment Terragrunt projects.
6_backend-mastery
Master backend architectures, REST API design, microservices, and server-side development across multiple languages. Use this as a central index to access specialized sub-skills.
6api contract sync manager
Validate OpenAPI, Swagger, and GraphQL schemas match backend implementation. Detect breaking changes, generate TypeScript clients, and ensure API documentation stays synchronized. Use when working with API spec files (.yaml, .json, .graphql), reviewing API changes, generating frontend types, or validating endpoint implementations.
5upstash/workflow typescript sdk skill
Lightweight guidance for using the Upstash Workflow SDK to define, trigger, and manage workflows. Use this Skill whenever a user wants to create workflow endpoints, run steps, or interact with the Upstash Workflow client.
5