architecture-data-system-design

Design data-intensive architectures with trade-off analyses for consistency, durability, and throughput.

3|2|Updated Mar 23, 2026
One-click install
npx skills add https://github.com/wesleyegberto/software-engineering-skills --skill architecture-data-system-design
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: architecture-data-system-design
Source: https://github.com/wesleyegberto/software-engineering-skills/tree/main/plugins/architecture/skills/architecture-data-system-design
Command: npx skills add https://github.com/wesleyegberto/software-engineering-skills --skill architecture-data-system-design

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Designing robust, scalable data-intensive architectures.

Core Features & Use Cases

  • Framework coverage for data models, storage engines, replication, partitioning, transactions, and reliability
  • Practical patterns like event sourcing, CDC, polyglot persistence, and architectural trade-off analyses
  • Use cases including building resilient data pipelines, choosing storage engines, and scaling data-intensive workloads

Quick Start

Design a guided walkthrough to design a data-intensive system using the DDIA framework.

Frequently Asked Questions about architecture-data-system-design

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a data-intensive architecture that balances consistency and throughput?

To design a data-intensive architecture, apply the DDIA framework to evaluate trade-offs among consistency, durability, and throughput. It provides structured patterns and guardrails for scaling robust data systems.

What patterns help with scaling data systems and fault tolerance?

Scaling data systems relies on patterns like event sourcing, CDC, and polyglot persistence. These approaches partition data and replicate state to ensure recoverability and fault tolerance.

How does replication and partitioning affect data system reliability?

Replication and partitioning impact reliability by distributing data across nodes. Evaluating architectural trade-offs helps configure fault tolerance, ensuring the system remains durable and recoverable during failures.

When do I need event sourcing and CDC for building resilient data pipelines?

You need event sourcing and CDC for building resilient data pipelines when propagating state changes reliably. They capture data modifications sequentially to maintain consistency across multi-store deployments.

Can I use this approach for choosing storage engines in multi-store deployments?

Yes, you can use this approach for choosing storage engines in multi-store deployments. It guides polyglot persistence by analyzing architectural trade-offs to match specific data models and workload requirements.

What are the limitations of polyglot persistence in distributed transactions?

Polyglot persistence introduces limitations in distributed transactions by increasing complexity around consistency and durability. Architectural reviews evaluate these trade-offs to establish guardrails for multi-store deployments.