data-architecture

Data architecture - models, relationships. Use when designing data structures.

⭐4stars🔀3forks📁View on GitHub🕐Updated Jan 8, 2026⬇️1downloads

When & Why to Use This Skill

This Claude skill facilitates the creation of robust data architectures and database schemas. It offers expert guidance on defining models and relationships, specifically optimized for modern stacks like Next.js, Drizzle ORM, and Neon (Postgres). By focusing on scalability, server-enforced security, and auditability, it helps developers build systems that remain maintainable and consistent as requirements evolve.

Use Cases

  • Designing scalable database schemas and complex entity relationships for modern SaaS applications.
  • Implementing secure data mutation patterns with mandatory server-side authorization and comprehensive audit trails.
  • Refactoring legacy data structures to improve system consistency and prepare for high-scale growth.
  • Architecting billing and entitlement systems that rely on a single source of truth to prevent data synchronization errors.
namedata-architecture
descriptionData architecture - models, relationships. Use when designing data structures.

Data Architecture Guideline

Tech Stack

  • API: tRPC
  • Framework: Next.js
  • Database: Neon (Postgres)
  • ORM: Drizzle

Non-Negotiables

  • All authorization must be server-enforced (no client-trust)
  • No dual-write: billing/entitlement truth comes from Stripe events only
  • UI must never contradict server-truth
  • High-value mutations must have audit trail (who/when/why/before/after)

Context

Data architecture determines what's possible and what's painful. Good architecture makes new features easy; bad architecture makes everything hard. The question isn't "does it work today?" but "will it work when requirements change?"

Consider the boundaries between domains, the flow of data through the system, and the consistency guarantees at each step. Where are implicit assumptions that will break? Where is complexity hidden that will cause bugs?

Driving Questions

  • If we were designing this from scratch, what would be different?
  • Where will the current architecture break as the product scales?
  • What implicit assumptions are waiting to cause bugs?
  • How do we know when state is inconsistent, and how do we recover?
  • Where is complexity hiding that makes the system hard to reason about?
  • What architectural decisions are we avoiding that we shouldn't?