Which ER notations does the skill support?

The skill covers a wide range of notation systems including Chen, Crow's Foot, UML, and IDEF1X for clear architectural communication.

Can it assist with enterprise data warehousing?

Absolutely. It provides guidance on Star and Snowflake schemas, Slowly Changing Dimensions (SCD), and Data Vault components like hubs, links, and satellites.

Can it help me choose between different database types?

Yes, it includes a polyglot persistence decision table to help you choose the right database based on consistency requirements and data structures.

Does this skill help with NoSQL database design?

Yes, it includes specific patterns for document modeling such as embedding vs. referencing, bucket patterns for time-series, and polymorphic document design.

Data Modeling & Architecture

Name: Data Modeling & Architecture
Author: rnavarych

byrnavarych

•

Database Management

Provides comprehensive methodologies and patterns for designing relational, document, graph, and time-series data models.

This skill equips Claude with advanced data architect capabilities, covering everything from traditional Entity-Relationship modeling and SQL normalization to modern NoSQL patterns like document embedding, graph property modeling, and time-series optimization. It assists developers in making high-stakes architecture decisions, such as choosing between polyglot persistence strategies, implementing Slowly Changing Dimensions (SCD) in data warehouses, or applying Data Vault methodologies for scalable enterprise data management. Whether you are mapping domain models to schemas or choosing between SQL and NoSQL for a new project, this skill provides the necessary patterns and decision frameworks.

Key Features

01Data warehousing schemas including Star, Snowflake, and Data Vault

02Comprehensive ER notation systems including Chen, Crow's Foot, and UML

03Polyglot persistence guidance with CDC, Saga, and CQRS patterns

04Multi-paradigm support including Relational, Document, Graph, and Time-series modeling

05Advanced NoSQL patterns like Polymorphic, Bucket, and Outlier designs

0611 GitHub stars

Use Cases

01Designing scalable MongoDB document structures using embedding vs. referencing strategies

02Architecting graph property models for social networks or recommendation engines

03Mapping complex domain models to normalized PostgreSQL schemas or OLAP Star schemas

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer data-modeling

For use in Claude.ai and ChatGPT

Key Features

01Data warehousing schemas including Star, Snowflake, and Data Vault

02Comprehensive ER notation systems including Chen, Crow's Foot, and UML

03Polyglot persistence guidance with CDC, Saga, and CQRS patterns

04Multi-paradigm support including Relational, Document, Graph, and Time-series modeling

05Advanced NoSQL patterns like Polymorphic, Bucket, and Outlier designs

0611 GitHub stars

Use Cases

01Designing scalable MongoDB document structures using embedding vs. referencing strategies

02Architecting graph property models for social networks or recommendation engines

03Mapping complex domain models to normalized PostgreSQL schemas or OLAP Star schemas